Quick Links

full vacuum of a very large table

From:	"Nic Chidu" <nic(at)chidu(dot)net>
To:	pgsql-admin(at)postgresql(dot)org
Subject:	full vacuum of a very large table
Date:	2011-03-29 15:56:05
Message-ID:	1301414165.2351.1435136873@webmail.messagingengine.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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

Responses

Re: full vacuum of a very large table at 2011-03-29 16:04:33 from Plugge, Joe R.
Re: full vacuum of a very large table at 2011-03-29 16:21:48 from raghu ram
Re: full vacuum of a very large table at 2011-03-29 16:27:02 from Ashish Nauriyal
Re: full vacuum of a very large table at 2011-03-29 16:38:20 from Bob Lunney
Re: full vacuum of a very large table at 2011-03-29 17:07:32 from Steve Crawford

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Plugge, Joe R.	2011-03-29 16:04:33	Re: full vacuum of a very large table
Previous Message	Ravi Thati	2011-03-29 08:43:10	pg_restore on windows with pipe