Old record migration to another table made the db slower

From: Arun P(dot)L <arunpl(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Old record migration to another table made the db slower
Date: 2013-09-05 06:52:35
Message-ID: SNT148-W850C4B1E6F8BA1937D3AAEDB330@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Paul Argudo 2013-09-05 06:55:06 Re: [pgeu-general] Call for design: PostgreSQL mugs
Previous Message Adarsh Sharma 2013-09-05 06:07:59 Re: LogStash For Analysing Postgres DB server Logs