Disable temporarily and reenable table indexes can be useful to speed up a large insert or update query
Post tagged: postgresql
A simple way to reset and restart a broken PostgreSQL sequence.
A window function performs a calculation across a set of rows that are related to the current row. Here is an example of utilisation of window functions lag and lead to detect value changes between successive table rows.