Christopher Petrilli <[EMAIL PROTECTED]> writes: > On Apr 4, 2005 11:52 AM, Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq