From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Euler Taveira de Oliveira <euler(at)timbira(dot)com>
Cc:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>,
Simon Riggs <simon(at)2ndQuadrant(dot)com>,
Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: reducing statistics write overhead
Date:
2009-01-23 04:58:41
Message-ID:
26106.1232686721@sss.pgh.pa.us (view raw or flat )
Thread:
2008-09-05 19:00:36 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2008-09-05 19:23:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-05 19:27:08 from Joshua Drake <jd(at)commandprompt(dot)com>
2008-09-05 19:51:36 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2008-09-05 23:29:50 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2008-09-06 00:24:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-06 07:22:10 from "Asko Oja" <ascoja(at)gmail(dot)com>
2008-09-07 13:09:25 from Magnus Hagander <magnus(at)hagander(dot)net>
2008-09-07 19:47:44 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2008-09-07 19:52:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-08 07:52:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2008-09-08 12:15:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-08 13:05:06 from Magnus Hagander <magnus(at)hagander(dot)net>
2008-09-08 13:25:20 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2008-09-08 14:05:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-08 21:10:48 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2008-09-08 23:36:15 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-09-09 13:11:58 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2008-11-03 01:18:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-08 07:50:58 from Magnus Hagander <magnus(at)hagander(dot)net>
2008-09-06 15:49:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-09-06 17:52:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-06 18:02:17 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-09-06 18:07:02 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-06 22:30:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-09-06 22:38:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-06 22:45:33 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-07 18:02:51 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2008-09-07 13:11:24 from Magnus Hagander <magnus(at)hagander(dot)net>
2008-09-06 18:12:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-09-06 19:45:13 from "Asko Oja" <ascoja(at)gmail(dot)com>
2009-01-07 10:36:50 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2009-01-07 14:44:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-12 09:38:51 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2009-01-21 10:53:22 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2009-01-21 12:52:09 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-01-21 16:15:29 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2009-01-21 16:27:51 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-01-21 18:16:36 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-01-21 19:45:08 from Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
2009-01-21 20:17:02 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-01-22 21:53:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-01-22 22:00:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-01-22 22:58:53 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2009-01-22 23:14:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-01-23 04:28:03 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2009-01-23 04:58:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
Euler Taveira de Oliveira <euler(at)timbira(dot)com> writes:
> Alvaro Herrera escreveu:
>> Well, the problem is precisely how to size the list. I don't like the
>> idea of keeping an arbitrary number in memory; it adds another
>> mostly-useless tunable that we'll need to answer questions about for all
>> eternity.
Is it so hard? In particular, rather than making it a tunable, what say
we freeze the list size at exactly two, ie each AV worker advertises its
current and most recent target table in shared memory. Other workers
avoid re-vacuuming those. Then the most work you can "waste" by extra
vacuuming is less than the maximum allowed stats file age. I'd have no
problem whatsoever in letting that run into multiple seconds, as long
as it doesn't get into minutes or hours.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: KaiGai KoheiDate: 2009-01-23 05:30:35Subject : SE-PostgreSQL Updated Revision (r1460)Previous :From : Euler Taveira de OliveiraDate : 2009-01-23 04:28:03Subject : Re: reducing statistics write overhead
