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
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 |