From: | "Asko Oja" <ascoja(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Martin Pihlak" <martin(dot)pihlak(at)gmail(dot)com>, "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: reducing statistics write overhead |
Date: | 2008-09-06 19:45:13 |
Message-ID: | ecd779860809061245m1d1d69c5of5104b890d466dda@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Too frequent read protection is already handled in the patch but these
comments might lead it into new directions. Current implementation had this
same limit that file was written no more than once per 500 ms.
On Sat, Sep 6, 2008 at 9:12 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > 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
>
> BTW, we could implement that by, instead of having a global tunable,
> including a field in the request message saying how stale an existing
> file is acceptable for this requestor. 500ms might be the standard
> value but autovac could use a smaller number.
>
> regards, tom lane
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Hunsaker | 2008-09-06 19:58:20 | Re: to_date() validation |
Previous Message | Abhijit Menon-Sen | 2008-09-06 19:40:55 | Re: [PATCH] "\ef <function>" in psql |