Re: Delay INSERT - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Delay INSERT
Date
Msg-id pu8y4e2wgh.fsf@srv.protecting.net
Whole thread Raw
In response to Delay INSERT  ("ON.KG" <skyer@on.kg>)
List pgsql-general
In article <14435275218.20050323193122@on.kg>,
"ON.KG" <skyer@on.kg> writes:

> Hi
> Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
> MySQL?

> or any other way to delay inserting?

Every INSERT in PostgreSQL is delayed in some sense: firstly, it is
not visible to anyone else until you commit, and secondly, it is
written first to the (supposedly fast) write-ahead log and only later
to the table files.

If you have problems with INSERT speed, describe hardware,
configuration, and table structure.

pgsql-general by date:

Previous
From: Edson Vilhena de Carvalho
Date:
Subject: backend process
Next
From: "A. Mous"
Date:
Subject: Re: Simple query takes a long time on win2K