Postgres Pro
Downloads
Home   >   mailing lists

full vacuum of a very large table - Mailing list pgsql-admin

From Nic Chidu
Subject full vacuum of a very large table
Date
Msg-id 1301414165.2351.1435136873@webmail.messagingengine.com
Whole thread Raw
Responses Re: full vacuum of a very large table  ("Plugge, Joe R." <JRPlugge@west.com>)
Re: full vacuum of a very large table  (raghu ram <raghuchennuru@gmail.com>)
Re: full vacuum of a very large table  (Ashish Nauriyal <ashish.nauriyal@enterprisedb.com>)
Re: full vacuum of a very large table  (Bob Lunney <bob_lunney@yahoo.com>)
Re: full vacuum of a very large table  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-admin
Tree view 
Got a situation where a 130 mil rows (137GB) table needs to be brought down in size to  10 mil records (most recent)
with the least amount of downtime.

Doing a full vacuum would be faster on:
 - 120 mil rows deleted and 10 mil active (delete most of them then full vacuum)
 - 10 mil deleted and 120 mil active. (delete small batches and full vacuum after each delete).

Any other suggestions?

Thanks,

Nic

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Wal archives building up in slave pg_xlog dir
Next
From: "Plugge, Joe R."
Date:
Subject: Re: full vacuum of a very large table