On 8th of September, Alvaro Herrera committed patch:
Allow per-tablespace effective_io_concurrency
Per discussion, nowadays it is possible to have tablespaces that have
wildly different I/O characteristics from others. Setting different
effective_io_concurrency parameters for those has been measured to
Author: Julien Rouhaud
Reviewed by: Andres Freund
Continue reading Waiting for 9.6 – Allow per-tablespace effective_io_concurrency
On 7th of September, Jeff Davis committed patch:
Add log_line_prefix option 'n' for Unix epoch.
Prints time as Unix epoch with milliseconds.
Tomas Vondra, reviewed by Fabien Coelho.
Continue reading Waiting for 9.6 – Add log_line_prefix option ‘n' for Unix epoch.
On 2nd of September, Teodor Sigaev committed patch:
Allow usage of huge maintenance_work_mem for GIN build.
Currently, in-memory posting list during GIN build process is limited 1GB
because of using repalloc. The patch replaces call of repalloc to repalloc_huge.
It increases limit of posting list from 180 millions
(1GB / sizeof(ItemPointerData)) to 4 billions limited by maxcount/count fields
in GinEntryAccumulator and subsequent calls. Check added.
Also, fix accounting of allocatedMemory during build to prevent integer
overflow with maintenance_work_mem > 4GB.
Robert Abraham <firstname.lastname@example.org> with additions by me
Continue reading Waiting for 9.6 – Allow usage of huge maintenance_work_mem for GIN build.
There exists an extension to PostgreSQL, which lets you use hypothetical indexes.
What are there? That's simple – these are indexes that don't really exist. So what good are they?
Continue reading Hypothetical indexes