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 15:52:59
Message-ID: 26454.1112629979@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:
> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message alvin.yk 2005-04-04 16:00:39 8.0.1 performance question.
Previous Message Tom Lane 2005-04-04 15:49:21 Re: 8.0.1 performance question.