Re: Delay INSERT

Dawid Kuroczko wrote:
> On Wed, 23 Mar 2005 14:50:47 +0000, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
>>ON.KG wrote:
>>
>>>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.

OK - thanks.

> 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...

Well, if you don't actually care whether it got inserted or not, just
throw the data away! That's got to be the quickest of all.

--
Richard Huxton
Archonet Ltd