On 4/19/2016 2:28 PM, Bill Ross wrote:
I've been running an index build for almost an hour on my 30G server
that takes ~ 20 mins on my puny old macbook.
It seems like I've tuned all I can.. what am I missing?
maintenance_work_mem is the main thing that affects index building
times, I didn't see that in your list of tuning parameters. I
generally set it to 1GB.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
