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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [HACKERS] temporary table vs array performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Millions of tables