Re: Millions of tables - Mailing list pgsql-performance

From Jeff Janes
Subject Re: Millions of tables
Date
Msg-id CAMkU=1y-YUNFpwmbW7jnfma7Rf6VtKTiuHv4gcYxyEF7NJ33Gw@mail.gmail.com
Whole thread Raw
In response to Re: Millions of tables  (Greg Spiegelberg <gspiegelberg@gmail.com>)
Responses Re: Millions of tables
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] temporary table vs array performance
Next
From: Tom Lane
Date:
Subject: Re: Millions of tables