Re: How do I know my table is bloated?
| От | Rodrigo Barboza |
|---|---|
| Тема | Re: How do I know my table is bloated? |
| Дата | |
| Msg-id | CANs8QJZ9Ekd06zwwk7n=Lu0=eWxC2dinxa+RHxvkFoVPuYaXNw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How do I know my table is bloated? (Igor Neyman <ineyman@perceptron.com>) |
| Ответы |
Re: How do I know my table is bloated?
|
| Список | pgsql-admin |
On Thu, May 30, 2013 at 1:35 PM, Igor Neyman <ineyman@perceptron.com> wrote:
Sent: Thursday, May 30, 2013 12:04 PMTo: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?I have some tables that I do a lot of updates, deletes and inserts.--------------------------
So I am worried that my cluster can grow up to a huge size...
The best option would be to create a scheduled process to check if it is bloated and if so, reindex?
Depends on whether it's table bloat or index bloat.
But first, you try to minimize bloat by tuning autovacuum.
Igor Neyman
I am using the defualt values for autovaccum.
How do you suggest to tune the autovacuum?
If the problem is index bloat, autovaccum won't be a solution, am I right?
В списке pgsql-admin по дате отправления: