Re: Postgresql INSERT speed (how to improve performance)? - Mailing list pgsql-general

From Andrej Ricnik-Bay
Subject Re: Postgresql INSERT speed (how to improve performance)?
Date
Msg-id b35603930708132001m729fceeerd9b3b79db189bc3f@mail.gmail.com
Whole thread Raw
In response to Postgresql INSERT speed (how to improve performance)?  ("Lim Berger" <straightfwd007@gmail.com>)
Responses Re: Postgresql INSERT speed (how to improve performance)?  ("Lim Berger" <straightfwd007@gmail.com>)
List pgsql-general
On 8/14/07, Lim Berger <straightfwd007@gmail.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

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Postgresql INSERT speed (how to improve performance)?
Next
From: Greg Smith
Date:
Subject: Re: Index not being used