Re: Sustained inserts per sec ... ?

Christopher Petrilli <petrilli@gmail.com> writes:
> On Apr 4, 2005 11:52 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Could we see the *exact* SQL definitions of the table and indexes?

> Of course, this is a bit cleansed, since it's an internal project, but
> only the column names are changed:

Thanks.  No smoking gun in sight there.  But out of curiosity, can you
do a test run with *no* indexes on the table, just to see if it behaves
any differently?  Basically I was wondering if index overhead might be
part of the problem.

Also, the X-axis on your graphs seems to be total number of rows
inserted ... can you relate that to elapsed real time for us?

            regards, tom lane