| 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: | Whole Thread | Raw Message | 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 |