Re: Vacuum full on a big table - Mailing list pgsql-admin

From Oleg Bartunov
Subject Re: Vacuum full on a big table
Date
Msg-id Pine.GSO.4.62.0503180118380.5508@ra.sai.msu.su
Whole thread Raw
In response to Re: Vacuum full on a big table  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Mark Travis"
Date:
Subject: Re: Cannot get postgres started on Fedora core 3
Next
From: Tom Lane
Date:
Subject: Re: Cannot get postgres started on Fedora core 3