Re: serious problems with vacuuming databases - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: serious problems with vacuuming databases
Date
Msg-id 44397243.6010208@fuzzy.cz
Whole thread Raw
In response to Re: serious problems with vacuuming databases  (Tomas Vondra <tv@fuzzy.cz>)
List 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.

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: serious problems with vacuuming databases
Next
From: Alvaro Herrera
Date:
Subject: Re: serious problems with vacuuming databases