Postgres Pro
Downloads
Home   >   mailing lists

Re: Sustained inserts per sec ... ? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Sustained inserts per sec ... ?
Date
Msg-id 26454.1112629979@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sustained inserts per sec ... ?  (Christopher Petrilli <petrilli@gmail.com>)
Responses Re: Sustained inserts per sec ... ?  (Christopher Petrilli <petrilli@gmail.com>)
List pgsql-performance
Tree view 
Christopher Petrilli <petrilli@gmail.com> writes:
> The table has:
>     * 21 columns (nothing too strange)
>     * No OIDS
>     * 5 indexes, including the primary key on a string

Could we see the *exact* SQL definitions of the table and indexes?
Also some sample data would be interesting.  I'm wondering for example
about the incidence of duplicate index keys.

            regards, tom lane

pgsql-performance by date:

Previous
From: Steve Poe
Date:
Subject: Re: How to improve db performance with $7K?
Next
From: Christopher Petrilli
Date:
Subject: Re: Sustained inserts per sec ... ?