X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 909BA5338C for ; Wed, 23 Mar 2005 13:33:46 +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 77102-04 for ; Wed, 23 Mar 2005 13:33:44 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id E474D5335E for ; Wed, 23 Mar 2005 13:33:43 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j2NDXT0f033089 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 23 Mar 2005 06:33:32 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j2NDXTLp042872; Wed, 23 Mar 2005 06:33:29 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j2NDXT6d042871; Wed, 23 Mar 2005 06:33:29 -0700 (MST) (envelope-from mfuhr) Date: Wed, 23 Mar 2005 06:33:29 -0700 From: Michael Fuhr To: "ON.KG" Cc: pgsql-php@postgresql.org Subject: Re: Delay INSERT Message-ID: <20050323133329.GA42811@winnie.fuhr.org> References: <20050321131047.93504.qmail@web53406.mail.yahoo.com> <20050321161555.GA22145@winnie.fuhr.org> <16718190640.20050323144638@on.kg> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <16718190640.20050323144638@on.kg> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/54 X-Sequence-Number: 3069 On Wed, Mar 23, 2005 at 02:46:38PM +0300, ON.KG wrote: > Does PostgreSQL have something like "INSERT DELAYD" - like it is used in > MySQL? > > or any other way to delay inserting? What problem are you trying to solve? Are you aware that PostgreSQL uses Multiversion Concurrency Control (MVCC) so readers and writers don't block each other? http://www.postgresql.org/docs/8.0/static/mvcc.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/