Re: serious problems with vacuuming databases

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To:
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: serious problems with vacuuming databases
Date: 2006-04-09 20:44:51
Message-ID: 44397243.6010208@fuzzy.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I guess you're right. I forgot to mention there are 12 composed indexes
> on the largest (and not deleted) table B, having about 14.000.000 rows
> and 1 GB of data. I'll try to dump/reload the database ...

Aaargh, the problem probably is not caused by the largest table, as it
was dropped, filled in with the data and after that all the indexes were
created. The problem could be caused by the tables with deleted data, of
course.

t.v.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2006-04-09 20:45:55 Re: serious problems with vacuuming databases
Previous Message Tomas Vondra 2006-04-09 20:37:05 Re: serious problems with vacuuming databases