X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 300BC52A77 for ; Thu, 17 Mar 2005 22:21:40 +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 01776-05 for ; Thu, 17 Mar 2005 22:21:30 +0000 (GMT) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6273556710 for ; Thu, 17 Mar 2005 22:21:22 +0000 (GMT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id j2HML95Q006506; Fri, 18 Mar 2005 01:21:09 +0300 (MSK) Date: Fri, 18 Mar 2005 01:21:09 +0300 (MSK) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Lee Wu Cc: Gaetano Mendola , pgsql-admin@postgresql.org Subject: Re: Vacuum full on a big table In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.349 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/270 X-Sequence-Number: 16768 Also, just speculating, is't possible to create new table (select * into) in different tablespace if there is no space on disk ? I didn't find this. Oleg On Fri, 18 Mar 2005, Oleg Bartunov wrote: > On Thu, 17 Mar 2005, Lee Wu wrote: > >> I wish. >> >> I am having a table, size of more than 60G, with 2.04412e+08 rows. >> Vacuum full and reindex it just kill me. > > In my case ( I have more than 500,000,000 rows) I had to 'select * into > new_big_table from big_table' > it was faster and didn't kill server. > As a bonus, you could 'CLUSTER' your big table if add > 'order by somekey'; > > After that, dont' forget to recreate indices and then you could drop > big_table and 'alter table new_big_table rename to big_table'. > > > Oleg > > >> >> -----Original Message----- >> From: pgsql-admin-owner@postgresql.org >> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Gaetano Mendola >> Sent: Thursday, March 17, 2005 2:10 PM >> To: pgsql-admin@postgresql.org >> Subject: [ADMIN] Vacuum full on a big table >> >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Hi all, >> is there a way to vacuum full a table but working only >> a part of the table ? I have a table with 6 milion rows >> and vacuum full it will send out of line for hours my >> server, so I'll like to vacuum that table multiple times >> in order to not block that table for a long period. >> >> It will work decresing the FSM settings ? >> >> >> Regards >> Gaetano Mendola >> >> >> >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG v1.2.5 (MingW32) >> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org >> >> iD8DBQFCOfIs7UpzwH2SGd4RAsXaAKDIgcNZLqsYULjnNVNhTktXvWmJTgCg4zcK >> V/gFNRTCu0y99HLbTtGm610= >> =0SF3 >> -----END PGP SIGNATURE----- >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 8: explain analyze is your friend >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster >> > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83