From wweng@kencast.com Fri Jan  31 16:45:13 2003
X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 314DA475CB1
	for <pgsql-sql@postgresql.org>; Fri, 31 Jan 2003 11:45:13 -0500 (EST)
Received: from mta5.snet.net (mta5.snet.net [204.60.203.77])
	by postgresql.org (Postfix) with ESMTP id D13F2475DF2
	for <pgsql-sql@postgresql.org>; Fri, 31 Jan 2003 11:45:09 -0500 (EST)
Received: from pop.snet.net (pop.snet.net [204.60.203.72])
	by mta5.snet.net (8.12.3/8.12.3/SNET-mx-1.2/D-1.1.1.1/O-1.1.1.1) with
	ESMTP id h0VGdRGe008339
	for <pgsql-sql@postgresql.org>; Fri, 31 Jan 2003 11:39:28 -0500 (EST)
X-Originating-IP: [64.252.95.167]
X-SBCIS-MTA: [pop.snet.net]
Received: from monet (167.95.252.64.snet.net [64.252.95.167])
	by pop.snet.net (8.12.3/8.12.3/SNET-pop-1.2/D-1.1.1.1/O-1.1.1.1) with
	SMTP id h0VGgpKF026929
	for <pgsql-sql@postgresql.org>; Fri, 31 Jan 2003 11:42:51 -0500 (EST)
Message-ID: <001401c2c947$d97b6980$5301a8c0@monet>
From: "Wei Weng" <wweng@kencast.com>
To: <pgsql-sql@postgresql.org>
Subject: Which version is this?
Date: Fri, 31 Jan 2003 11:43:14 -0500
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0011_01C2C91D.F0715930"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/521
X-Sequence-Number: 11386

This is a multi-part message in MIME format.

------=_NextPart_000_0011_01C2C91D.F0715930
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Since which version PostgreSQL is able to do Vacuum Analyze even in the mid=
dle of a transaction, namely, insert, delete, update?


Thanks


Wei

------=_NextPart_000_0011_01C2C91D.F0715930
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-125=
2">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Since which version PostgreSQL is able to do Vacuum Ana=
lyze=20
even in the middle of a transaction, namely, insert, delete,=20
update?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Thanks</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Wei</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0011_01C2C91D.F0715930--




From mallah@trade-india.com Sat Feb  1 05:08:08 2003
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 <pgsql-sql@postgresql.org>; 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 <pgsql-sql@postgresql.org>; 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." <mallah@trade-india.com>
Organization: Infocom Network Limited.
To: "Wei Weng" <wweng@kencast.com>, <pgsql-sql@postgresql.org>
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.