| From: | <me(at)alternize(dot)com> |
|---|---|
| To: | "Michael Riess" <mlriess(at)gmx(dot)de>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 15,000 tables |
| Date: | 2005-12-01 17:07:37 |
| Message-ID: | 06f401c5f699$bbae2af0$0201a8c0@iwing |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda pgsql-performance |
hi michael
>> Have you ANALYZEd your database? VACUUMing?
>
> Of course ... before 8.1 we routinely did a vacuum full analyze each
> night. As of 8.1 we use autovacuum.
what i noticed is autovacuum not working properly as it should. i had 8.1
running with autovacuum for just 2 days or so and got warnings in pgadmin
that my tables would need an vacuum. i've posted this behaviour some weeks
ago to the novice list requesting more infos on how to "tweak" autovacuum
properly - unfortunately without any respones. thats when i switched the
nightly analyze job back on - everything runs smooth since then.
maybe it helps in your case as well?
cheers,
thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ing. Jhon Carrillo // Caracas, Venezuela | 2005-12-01 17:08:35 | Como verificar los Querys que se estan ejecutando en Pg |
| Previous Message | Manuel Sugawara | 2005-12-01 16:59:26 | Re: " campo con apostrofe" |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2005-12-01 17:09:41 | Re: 15,000 tables |
| Previous Message | Tom Lane | 2005-12-01 16:34:46 | Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 |