Re: Sustained inserts per sec ... ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Petrilli <petrilli(at)gmail(dot)com>
Cc: jd(at)commandprompt(dot)com, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sustained inserts per sec ... ?
Date: 2005-04-04 16:23:27
Message-ID: 26669.1112631807@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Christopher Petrilli <petrilli(at)gmail(dot)com> writes:
> On Apr 4, 2005 11:52 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message alvin.yk 2005-04-04 16:44:26 Re: 8.0.1 performance question.
Previous Message Kris Jurka 2005-04-04 16:15:40 Re: 8.0.1 performance question.