Postgres Pro
Downloads
Home   >   mailing lists

Big delete on big table... now what? - Mailing list pgsql-performance

From Fernando Hevia
Subject Big delete on big table... now what?
Date
Msg-id 042c01c90496$ca8725f0$8f01010a@iptel.com.ar
Whole thread Raw
Responses Re: Big delete on big table... now what?
Re: Big delete on big table... now what?
List pgsql-performance
Tree view 
Hi list.

I have a table with over 30 million rows. Performance was dropping steadily
so I moved old data not needed online to an historic table. Now the table
has about 14 million rows. I don't need the disk space returned to the OS
but I do need to improve performance. Will a plain vacuum do or is a vacuum
full necessary?
¿Would a vacuum full improve performance at all?

Thanks for your hindsight.
Regards,

Fernando.

pgsql-performance by date:

Previous
From: pgsql-performance@ian.org
Date:
Subject: Re: Why do my hash joins turn to nested loops?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Big delete on big table... now what?