Обсуждение: Re: How to improve insert speed with index on text column
Saurabh wrote: > wal_buffers = 5MB As as already been suggested, use 16MB (or if the version you're using supports it, the default of -1); > autovacuum = off If the only activity while this is off is a bulk load, that might be OK, but be sure *not* to leave this off. You will almost certainly regret very much later. Your tables will tend to bloat and slowly get very slow and very big. At that point it will be much more painful to do aggressive maintenance to clean things up. If you think you have some particular reason to turn it off, please discuss it here -- you might have better options. -Kevin
Kelvin, 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). Thanks, Saurabh
On Sun, Feb 5, 2012 at 12:29 PM, Saurabh <saurabh.b85@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