PG 10 hash index create times

Since upgrading to PG 10 a few weeks ago I've been experimenting with hash indexes. One thing I've noticed is that they seem to take a _lot_ longer to create than btree indexes, particularly on large tables. I've got a moderately sized table of about 38M rows and the create index using hash for a

Re: pg_xlog unbounded growth

Hi, Am 24.01.2018 um 12:48 schrieb Stefan Petrea: We're using PostgreSQL 9.6.6 on a Ubuntu 16.04.3 LTS. During some database imports(using pg_restore), we're noticing fast and unbounded growth of pg_xlog up to the point where the partition(280G in size for us) that stores it fills up and Postgr