Re: Millions of tables
| От | Jeff Janes |
|---|---|
| Тема | Re: Millions of tables |
| Дата | |
| Msg-id | CAMkU=1y-YUNFpwmbW7jnfma7Rf6VtKTiuHv4gcYxyEF7NJ33Gw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Millions of tables (Greg Spiegelberg <gspiegelberg@gmail.com>) |
| Ответы |
Re: Millions of tables
|
| Список | pgsql-performance |
On Mon, Sep 26, 2016 at 5:53 AM, Greg Spiegelberg <gspiegelberg@gmail.com> wrote:
I may need to understand autovacuum better. My impression was it consulted statistics and performed vacuums one table at a time based on the vacuum threshold formula on https://www.postgresql.org/docs/9.5/static/routine- vacuuming.html.
A problem is that those statistics are stored in one file (per database; it used to be one file per cluster). With 8 million tables, that is going to be a pretty big file. But the code pretty much assumes the file is going to be pretty small, and so it has no compunction about commanding that it be read and written, in its entirety, quite often.
Cheers,
Jeff
В списке pgsql-performance по дате отправления: