Old record migration to another table made the db slower

Поиск
Список
Период
Сортировка
От Arun P.L
Тема Old record migration to another table made the db slower
Дата
Msg-id SNT148-W850C4B1E6F8BA1937D3AAEDB330@phx.gbl
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Adarsh Sharma
Дата:
Сообщение: Re: LogStash For Analysing Postgres DB server Logs
Следующее
От: Jean-Paul Argudo
Дата:
Сообщение: Re: [pgeu-general] Call for design: PostgreSQL mugs