X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EFA5E8B9B8A for ; Tue, 15 Feb 2005 02:07:02 +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 11538-09 for ; Tue, 15 Feb 2005 02:06:58 +0000 (GMT) Received: from mail.census.gov.ph (mail.census.gov.ph [203.172.28.120]) by svr1.postgresql.org (Postfix) with ESMTP id 374CC8B9D56 for ; Tue, 15 Feb 2005 02:05:06 +0000 (GMT) Received: from notnot ([192.168.1.70]) by mail.census.gov.ph (8.12.8/8.12.8) with ESMTP id j1F22flW029903; Tue, 15 Feb 2005 10:02:42 +0800 Message-Id: <200502150202.j1F22flW029903@mail.census.gov.ph> From: "Michael Ryan S. Puncia" To: "'Iain'" , Subject: Re: VACCUM FULL ANALYZE PROBLEM Date: Tue, 15 Feb 2005 10:10:30 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C51346.94B49BF0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcUTAMGqF4dGsuPoSPSZQffPSZp92AAAja9w In-Reply-To: <007f01c51300$f44334a0$7201a8c0@mst1x5r347kymb> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-MailScanner: Found to be clean by NSO mail server. X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.366 tagged_above=0 required=5 tests=HTML_MESSAGE, SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200502/223 X-Sequence-Number: 10552 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C51346.94B49BF0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit But I need to do full vacuum because I deleted some of the fields that are not use anymore and I also add another fields. Is there another way to speed up full vacuum? _____ From: Iain [mailto:iain@mst.co.jp] Sent: Tuesday, February 15, 2005 9:52 AM To: Michael Ryan S. Puncia; pgsql-performance@postgresql.org Subject: Re: [PERFORM] VACCUM FULL ANALYZE PROBLEM Hi, just make sure that your freespace map is big enough and then do a vacuum analyse without the full option. I can imagine that database performance might not be as good as it would be after a vacuum full, though I expect that it wouldn't make much difference. regards Iain ----- Original Message ----- From: Michael Ryan S. Puncia To: pgsql-performance@postgresql.org Sent: Tuesday, February 15, 2005 10:34 AM Subject: [PERFORM] VACCUM FULL ANALYZE PROBLEM Hi, I have 3 tables in the database with 80G of data, one of them is almost 40G and the remaining 2 tables has 20G each. We use this database mainly for query and updating is done only quarterly and the database perform well. My problem is after updating and then run VACCUM FULL ANALYZE vacuuming the tables takes days to complete. I hope someone can help me solve my problem. Thanks __________ NOD32 1.998 (20050212) Information __________ This message was checked by NOD32 Antivirus System. http://www.nod32.com ------=_NextPart_000_0000_01C51346.94B49BF0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

 

But I need to do full vacuum = because I deleted some of the fields that are not use anymore and I also add = another fields. Is there

another  way  to speed up = full vacuum?

 

 


From: Iain [mailto:iain@mst.co.jp]
Sent: Tuesday, February = 15, 2005 9:52 AM
To: Michael Ryan S. = Puncia; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] = VACCUM FULL ANALYZE PROBLEM

 

Hi,

 

just make sure that your freespace = map is big enough and then do a vacuum analyse without the full option. =

 

I can imagine that database = performance might not be as good as it would be after a vacuum full, though I expect = that it wouldn't make much difference.

 

regards

Iain

----- Original Message ----- =

Sent: Tuesday, February 15, 2005 10:34 AM

Subject: [PERFORM] VACCUM FULL ANALYZE PROBLEM

 

Hi,

 

I have 3 tables in the database with 80G of data, one = of them is almost 40G and the remaining 2 tables has 20G = each.

We use this database mainly for query and updating is done only quarterly and the database perform well. My = problem

is after updating and then run VACCUM FULL ANALYZE =  vacuuming the tables takes days to complete. I hope = someone

can help me solve my problem.

 

Thanks

 

 



__________ NOD32 1.998 (20050212) Information __________

This message was checked by NOD32 Antivirus System.
http://www.nod32.com
<= /font>

------=_NextPart_000_0000_01C51346.94B49BF0--