Re: Old record migration to another table made the db slower

On 5 Září 2013, 8:52, Arun P.L wrote:
> 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

Hi,

First of all, 7.4 reached end-of-life ~3 years ago. And 7.4.3 is not even
the last release in this branch - there are ~30 updates. Go and upgrade to
7.4.30 now.

We'll need a bit more info about the tables / queries. What exactly have
you done? Show us the commands you've executed. Then show us EXPLAIN
ANALYZE for the queries.

Tomas