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
