Old record migration to another table made the db slower - Mailing list pgsql-general

From Arun P.L
Subject Old record migration to another table made the db slower
Date
Msg-id SNT148-W850C4B1E6F8BA1937D3AAEDB330@phx.gbl
Whole thread Raw
Responses How to check if any WAL file is missing in archive folder  ("ascot.moss@gmail.com" <ascot.moss@gmail.com>)
Re: Old record migration to another table made the db slower  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-general
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 on original_data_ table.

 Now the problem is some queries are running very slow especially 'select max(date)  from one of the table'.  Also db seem to be a bit slower after all these works. 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 followed for the same?

My postgresql version is 7.4.3.   


Thanks in Advance for your helps,
Arun 

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Re: LogStash For Analysing Postgres DB server Logs
Next
From: Jean-Paul Argudo
Date:
Subject: Re: [pgeu-general] Call for design: PostgreSQL mugs