X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 88C6D476160 for ; Sat, 1 Feb 2003 00:08:08 -0500 (EST) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id A07D1476773 for ; Fri, 31 Jan 2003 23:58:25 -0500 (EST) Received: (qmail 19864 invoked from network); 1 Feb 2003 04:54:59 -0000 Received: from unknown (HELO system67.trade-india-local.com) (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 1 Feb 2003 04:54:59 -0000 From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: "Wei Weng" , Subject: Re: Which version is this? Date: Sat, 1 Feb 2003 10:33:43 +0530 User-Agent: KMail/1.5 References: <001401c2c947$d97b6980$5301a8c0@monet> In-Reply-To: <001401c2c947$d97b6980$5301a8c0@monet> MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1252" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200302011033.43288.mallah@trade-india.com> X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/1 X-Sequence-Number: 11399 your question doesnt' seem to be very clear. But the following appeared in release note of version 7.2 hope it helps regds mallah. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~` A.5. Release 7.2 Release date: 2002-02-04 A.5.1. Overview This release improves PostgreSQL for use in high-volume applications. Major changes in this release: VACUUM Vacuuming no longer locks tables, thus allowing normal user access during the vacuum. A new VACUUM FULL command does old-style vacuum by locking the table and shrinking the on-disk copy of the table. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ On Friday 31 January 2003 10:13 pm, Wei Weng wrote: > Since which version PostgreSQL is able to do Vacuum Analyze even in the > middle of a transaction, namely, insert, delete, update? > > > Thanks > > > Wei -- -------------------------------------------- Regds Mallah Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)26152172 (221) (L) 9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.