Re: Postgresql INSERT speed (how to improve performance)?

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Lim Berger" <straightfwd007(at)gmail(dot)com>
Cc: "Postgresql General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql INSERT speed (how to improve performance)?
Date: 2007-08-14 03:01:21
Message-ID: b35603930708132001m729fceeerd9b3b79db189bc3f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/14/07, Lim Berger <straightfwd007(at)gmail(dot)com> wrote:

> INSERTing into MySQL takes 0.0001 seconds per insert query.
> INSERTing into PgSQL takes 0.871 seconds per (much smaller) insert query.
>
> What can I do to improve this performance? What could be going wrong
> to elicit such poor insertion performance from Postgresql?
MySQL might not be writing the data straight out
to disk ... just a guess.

> Thanks.
Cheers,
Andrej

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-08-14 03:02:39 Re: Index not being used
Previous Message Tony Caduto 2007-08-14 03:00:45 Re: Postgresql INSERT speed (how to improve performance)?