Re: reducing statistics write overhead - Mailing list pgsql-hackers

From Tom Lane
Subject Re: reducing statistics write overhead
Date
Msg-id 20796.1220724422@sss.pgh.pa.us
Whole thread Raw
In response to Re: reducing statistics write overhead  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: reducing statistics write overhead  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Some sort of "if stats were requested in the last 500 ms, just tell the
> requester to read the existing file".

Hmm, I was thinking of delaying both the write and the reply signal
until 500ms had elapsed.  But the above behavior would certainly be
easier to implement, and would probably be good enough (TM).

> - 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.

The signaling would become way too complex, I think.  Also what do you
do about shared tables?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: reducing statistics write overhead
Next
From: Tom Lane
Date:
Subject: Re: reducing statistics write overhead