I really would like to see bi-temporal table support eventually come to PG<p><a href="https://wiki.postgresql.org/images/6/64/Fosdem20150130PostgresqlTemporal.pdf" rel="nofollow">https://wiki.postgresql.org/images/6/64/Fosdem20150130Postgr...</a><p>Is anybody aware somebody working on that for PG?
> <i>Parallel execution of sequential scans, joins and aggregates</i><p>This confuses me—I thought a sequential scan was slow because it was limited by disk I/O; why is it faster to hawe multiple threads waiting around for the same disk?<p>(I guessed maybe that it was running <i>different</i> sequential scans in the same query in parallel, but no, pages 3 and 4 of the PDF show parallel workers being used for a single scan of a single table)
I am really glad to see "searching for phrases" feature for Full-Text Search, as doing that with POSIX was really painful operation for long text area fields.