From: | Dawid Kuroczko <qnex42(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Delay INSERT |
Date: | 2005-03-23 16:34:49 |
Message-ID: | 758d5e7f05032308342828a03f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-php |
On Wed, 23 Mar 2005 14:50:47 +0000, Richard Huxton <dev(at)archonet(dot)com> wrote:
> ON.KG wrote:
> > Hi
> >
> > Does PostgreSQL have something like "INSERT DELAYD" - like it is used in
> > MySQL?
> >
> > or any other way to delay inserting?
>
> What precisely does this do?
It adds an insert into a 'do this' queue and returns. From PostgreSQL-s
point of view it would be equivalent of issuing INSERT and not waiting
for the result.
The MySQL has this mainly because when other statement such as
SELECT or UPDATE is in progress, the INSERT would be blocked.
PostgreSQL doesn't have such issues with blocking, so only difference
between INSERT and INSERT DELAYED from PostgreSQL's standpoint
would be waiting and not for the result...
From | Date | Subject | |
---|---|---|---|
Next Message | A. Mous | 2005-03-23 16:37:28 | Re: Simple query takes a long time on win2K |
Previous Message | ON.KG | 2005-03-23 16:31:22 | Delay INSERT |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-03-23 16:49:49 | Re: Delay INSERT |
Previous Message | ON.KG | 2005-03-23 16:31:22 | Delay INSERT |