pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Dawid Kuroczko <qnex42@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Delay INSERT
Date: Wed, 23 Mar 2005 16:49:49 +0000
Message-ID: <42419E2D.3090802@archonet.com> (raw)
In-Reply-To: <758d5e7f05032308342828a03f@mail.gmail.com>
References: <20050321131047.93504.qmail@web53406.mail.yahoo.com>
	<20050321161555.GA22145@winnie.fuhr.org>
	<14435275218.20050323193122@on.kg>
	<42418247.7070108@archonet.com>
	<758d5e7f05032308342828a03f@mail.gmail.com>

Dawid Kuroczko wrote:
> On Wed, 23 Mar 2005 14:50:47 +0000, Richard Huxton <dev@archonet.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



view thread (12+ messages)  latest in thread

Message-ID: <42419E2D.3090802@archonet.com>
Permalink:  ../42419E2D.3090802@archonet.com/
Also on:    postgresql.org/message-id/42419E2D.3090802@archonet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: dev@archonet.com, qnex42@gmail.com, pgsql-general@postgresql.org
  Subject: Re: Delay INSERT
  In-Reply-To: <42419E2D.3090802@archonet.com>
  References: <20050321131047.93504.qmail@web53406.mail.yahoo.com> <20050321161555.GA22145@winnie.fuhr.org> <14435275218.20050323193122@on.kg> <42418247.7070108@archonet.com> <758d5e7f05032308342828a03f@mail.gmail.com> <42419E2D.3090802@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox