Postgres Pro
Downloads
Home   >   mailing lists

Re: How to improve insert speed with index on text column - Mailing list pgsql-performance

From Robert Haas
Subject Re: How to improve insert speed with index on text column
Date
Msg-id CA+TgmoYtWVjPvD-koPcNC8NN_t9S1qoYbkt_-+KAYrucCryTgA@mail.gmail.com
Whole thread Raw
In response to Re: How to improve insert speed with index on text column  (Saurabh <saurabh.b85@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: text search: tablescan cost for a tsvector
Next
From: Robert Haas
Date:
Subject: Re: Vacuuming problems on TOAST table