On Sun, Feb 5, 2012 at 12:29 PM, Saurabh <saurabh....@gmail.com> wrote: > My intention to keep autovacuum as off is bulk loading only. I was > thinking after bullk load I will change it. > > I changed wal_buffer from 5MB to 16MB but I got same performance that > I got with 5MB (even less).
Does it help if you create the index using COLLATE "C"? Assuming you're on 9.1.x... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
