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 667C853390 for ; Wed, 23 Mar 2005 16:49:58 +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 44019-05 for ; Wed, 23 Mar 2005 16:49:52 +0000 (GMT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id DF30353396 for ; Wed, 23 Mar 2005 16:49:51 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-33.mail.demon.net with esmtp (Exim 4.42) id 1DE93F-0007v9-Bv; Wed, 23 Mar 2005 16:49:50 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 66B3C15901; Wed, 23 Mar 2005 16:49:48 +0000 (GMT) Message-ID: <42419E2D.3090802@archonet.com> Date: Wed, 23 Mar 2005 16:49:49 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dawid Kuroczko Cc: pgsql-general@postgresql.org Subject: Re: Delay INSERT 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> In-Reply-To: <758d5e7f05032308342828a03f@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.061 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/1131 X-Sequence-Number: 75446 Dawid Kuroczko wrote: > On Wed, 23 Mar 2005 14:50:47 +0000, Richard Huxton 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