X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC005533B0 for ; Wed, 23 Mar 2005 16:34:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38968-07 for ; Wed, 23 Mar 2005 16:34:51 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 937A153399 for ; Wed, 23 Mar 2005 16:34:50 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so210344rnf for ; Wed, 23 Mar 2005 08:34:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=MCSjqRwn4XVIxxl1eju+iIR5qMJ1rQEcS239CZxfNiNH3zWooLcKxJQgiyUWVnS+dMq4f7SmUhCV7mHX1VFVszeTvtI1Owim+9pT21y2V9Ofl8w0XZAyiW59H7J+9BL4gjwE2AWryJcroYiu4N7F/DJl4yPOn/FZL5x3Fqqfh8o= Received: by 10.38.181.38 with SMTP id d38mr692219rnf; Wed, 23 Mar 2005 08:34:50 -0800 (PST) Received: by 10.38.101.75 with HTTP; Wed, 23 Mar 2005 08:34:49 -0800 (PST) Message-ID: <758d5e7f05032308342828a03f@mail.gmail.com> Date: Wed, 23 Mar 2005 17:34:49 +0100 From: Dawid Kuroczko Reply-To: Dawid Kuroczko To: pgsql-general@postgresql.org Subject: Re: Delay INSERT In-Reply-To: <42418247.7070108@archonet.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <20050321131047.93504.qmail@web53406.mail.yahoo.com> <20050321161555.GA22145@winnie.fuhr.org> <14435275218.20050323193122@on.kg> <42418247.7070108@archonet.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.746 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/1127 X-Sequence-Number: 75442 On Wed, 23 Mar 2005 14:50:47 +0000, Richard Huxton 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...