Re: [GENERAL] Old record migration to another table made the db slower

2013-09-06 Thread Michael Paquier
On Thu, Sep 5, 2013 at 6:05 PM, Tomas Vondra wrote: > On 5 Září 2013, 8:52, Arun P.L wrote: >> Actual intention of the migration of old records was to >> speed up the original_data_table which is used frequently by users. How >> can I get this problem get this fixed? What are the steps to be follo

Re: [GENERAL] Old record migration to another table made the db slower

2013-09-05 Thread Tomas Vondra
On 5 Září 2013, 8:52, Arun P.L wrote: > Hi all, > I have moved a lot of old records from one table say original_data_table > to another table say old_data_table which is newly created for the old > records. There were around 15 milliion old records to move. After this > migration I have done standa

[GENERAL] Old record migration to another table made the db slower

2013-09-04 Thread Arun P . L
Hi all, I have moved a lot of old records from one table say original_data_table to another table say old_data_table which is newly created for the old records. There were around 15 milliion old records to move. After this migration I have done standard vacuum on new old_data_table as well as o