Big delete on big table... now what?

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Big delete on big table... now what?
Date: 2008-08-22 20:36:44
Message-ID: 042c01c90496$ca8725f0$8f01010a@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2008-08-22 21:30:59 Re: Big delete on big table... now what?
Previous Message pgsql-performance 2008-08-22 18:33:25 Re: Why do my hash joins turn to nested loops?