Saturday, September 6, 2008

Re: [HACKERS] reducing statistics write overhead

Tom Lane escribió:

> (In fact, maybe this patch ought to include some sort of maximum update
> rate tunable? The worst case behavior could actually be WORSE than now.)

Some sort of "if stats were requested in the last 500 ms, just tell the
requester to read the existing file".

Things that come to mind:

- autovacuum could use a more frequent stats update in certain cases

- Maybe we oughta have separate files, one for each database? That way
we'd reduce unnecessary I/O traffic for both the reader and the writer.

Alvaro Herrera
The PostgreSQL Company - Command Prompt, Inc.

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

No comments: