| From: | Harald Fuchs <use_reply_to(at)protecting(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Delay INSERT |
| Date: | 2005-03-23 15:50:06 |
| Message-ID: | pu8y4e2wgh.fsf@srv.protecting.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-php |
In article <14435275218(dot)20050323193122(at)on(dot)kg>,
"ON.KG" <skyer(at)on(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-03-23 16:01:44 | Re: PostgreSQL support |
| Previous Message | tony | 2005-03-23 15:22:14 | Re: OSX, ODBC and Office 2004 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ON.KG | 2005-03-23 16:31:22 | Delay INSERT |
| Previous Message | Richard Huxton | 2005-03-23 14:50:47 | Re: Delay INSERT |