Re: Insert statements really slow

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Waller, David" <Waller_D(at)imsdm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Insert statements really slow
Date: 2007-11-09 19:18:18
Message-ID: dcc563d10711091118s4069d221k5e9fca51ef814c1d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Nov 9, 2007 11:53 AM, Waller, David <Waller_D(at)imsdm(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-11-09 19:22:51 Re: Optimal time series sampling.
Previous Message Andrew Sullivan 2007-11-09 18:01:33 Re: Insert statements really slow