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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
