Re: Insert statements really slow - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Insert statements really slow
Date
Msg-id dcc563d10711091118s4069d221k5e9fca51ef814c1d@mail.gmail.com
Whole thread Raw
In response to Insert statements really slow  ("Waller, David" <Waller_D@IMSDM.com>)
List pgsql-general
On Nov 9, 2007 11:53 AM, Waller, David <Waller_D@imsdm.com> wrote:
>
> In MySQL I go through a file in about 2 minutes and it is taking about 30 in
> PG.  I have removed all but the primary key index and have done a BEGIN and
> COMMIT after turning off AUTOCOMMIT.

How many rows are you wrapping in begin/commit pairs?  Hopefully a
good number, but just wondering.

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Insert statements really slow
Next
From: "Scott Marlowe"
Date:
Subject: Re: Optimal time series sampling.