X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 8544F9FA5F0
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  7 Jun 2006 09:43:18 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 08876-01
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed,  7 Jun 2006 09:43:14 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from hu-out-0102.google.com (hu-out-0102.google.com [72.14.214.206])
	by postgresql.org (Postfix) with ESMTP id 42C219F9EF3
	for <pgsql-performance@postgresql.org>;
	Wed,  7 Jun 2006 09:43:14 -0300 (ADT)
Received: by hu-out-0102.google.com with SMTP id 23so931530huc
	for <pgsql-performance@postgresql.org>;
	Wed, 07 Jun 2006 05:43:12 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=l+22BM1V/Mg/YiSG2RrscPR9TNMcORGa5FviAfHFlo35eP7WRRVZW0RbdJnpJG80fmrEycmEOKEg+qqNoBNtvMida+/mt5qrJStDBtqo0bxDkxLNrWS5uEOw5EhfoeD+O1rfY6N051kqBS5LN7pG4NqURb/E9/ZiwwrlL8gDpEQ=
Received: by 10.35.41.14 with SMTP id t14mr659235pyj;
	Wed, 07 Jun 2006 05:43:11 -0700 (PDT)
Received: by 10.35.8.14 with HTTP; Wed, 7 Jun 2006 05:43:11 -0700 (PDT)
Message-ID: <9f2e40a90606070543l1066f162v19fc0887d916e2bb@mail.gmail.com>
Date: Wed, 7 Jun 2006 18:13:11 +0530
From: "soni de" <soni.de@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Regarding ALTER Command
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1858_22786569.1149684191734"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/76
X-Sequence-Number: 19433

------=_Part_1858_22786569.1149684191734
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,



We have database on which continueous operations of INSERT, DELETE, UPDATE
are going on, In the mean time irrespective of INSERT and UPDATE we want to
ALTER some filelds from the table can we do that?

Would the ALTER command on heavily loaded database create any perfomance
problem?

Is it feasible to do ALTER when lots of INSERT operations are going on?



Postgresql version we are using is -- PostgreSQL 7.2.4



Please provide me some help regarding this.



Thanks,

Soni

------=_Part_1858_22786569.1149684191734
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>&nbsp;</div>
<div>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">Hello,</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">We have database on which continueous operations of INSERT, DELETE, UPDATE are going on, In the mean&nbsp;time&nbsp;irrespective of INSERT and UPDATE we want to ALTER some filelds from the&nbsp;table can we do that? 
</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">Would the ALTER command on heavily loaded database create any perfomance problem? </span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">Is it feasible to do ALTER when lots of INSERT operations are going on?</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">Postgresql version we are using is -- PostgreSQL 7.2.4 </span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">Please provide me some help regarding this.</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">Thanks,</span></p>
<p class="MsoNormal" style="BACKGROUND: white; MARGIN: 0in 0in 0pt"><span style="FONT-FAMILY: Arial">Soni</span></p></div>

------=_Part_1858_22786569.1149684191734--