Re: INSERT performance

surdules(at)yahoo(dot)com (Razvan Surdulescu) writes:
> DCorbit(at)connx(dot)com ("Dann Corbit") wrote in message news:<D90A5A6C612A39408103E6ECDD77B829408C2E(at)voyager(dot)corporate(dot)connx(dot)com>...
>> 500 records in 12 seconds is about 42/second. Hard to know if that is
>> good or bad. Is the machine under heavy use? Are the records extremely
>> long?

>> Provide the SQL that defines the table and its indexes.

> CREATE INDEX idx_field1 ON data(field1);
> CREATE INDEX idx_field2 ON data(field2);
> ...
> CREATE INDEX idx_field20 ON data(field20);

Uh, do you actually need an index on every column?

It's obvious that the index insertions are where the time is going.
You're getting close to 900 index insertions per second, which is not
bad at all on consumer-grade ATA disk hardware, if you ask me. It might
help to raise shared_buffers, if you didn't already do that ... but the
real solution here is to only index the columns that you are actually
intending to search on.

regards, tom lane