Re: [PoC] pgstattuple2: block sampling to reduce physical read

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: [PoC] pgstattuple2: block sampling to reduce physical read
Дата
Msg-id CAJKUy5g1Kh8Urc1nSUDOyTG_b3opBVjp=7_ZBjgiGdPutee-jQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PoC] pgstattuple2: block sampling to reduce physical read  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Ответы Re: [PoC] pgstattuple2: block sampling to reduce physical read  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Re: [PoC] pgstattuple2: block sampling to reduce physical read  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-hackers
On Thu, Oct 10, 2013 at 5:32 PM, Mark Kirkwood
<mark.kirkwood@catalyst.net.nz> wrote:
>
> Quietly replying to myself - looking at the code the sampler does 3000
> random page reads...

FWIW, something that bothers me is that there is 3000 random page
reads... i mean, why 3000? how do you get that number as absolute for
good accuracy in every relation? why not a percentage, maybe an
argument to the function?

also the name pgstattuple2, doesn't convince me... maybe you can use
pgstattuple() if you use a second argument (percentage of the sample)
to overload the function

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Patch for reserved connections for replication users
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Patch: FORCE_NULL option for copy COPY in CSV mode