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

> Shared buffers is the cache maintained by PostgreSQL. All all the data
> that you read/write need to go through shared buffers.

While this is technically true, I need to point out that you generally
increase shared_buffers for high concurrency, and for reads, not for
writes, especially for row-at-a-time inserts.  There's just not that
much memory required (although more than the out-of-the-box defaults).

I'd suggest increasing wal_buffers to 16MB, which is the maximum useful
amount, rather than 5MB.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com