Re: How to improve insert speed with index on text column

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Saurabh <saurabh(dot)b85(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to improve insert speed with index on text column
Date: 2012-02-29 18:35:37
Message-ID: CA+TgmoYtWVjPvD-koPcNC8NN_t9S1qoYbkt_-+KAYrucCryTgA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sun, Feb 5, 2012 at 12:29 PM, Saurabh <saurabh(dot)b85(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2012-02-29 18:45:25 Re: Vacuuming problems on TOAST table
Previous Message Robert Haas 2012-02-29 18:32:48 Re: text search: tablescan cost for a tsvector