Re: why partition pruning doesn't work?

Поиск
Список
Период
Сортировка
Искать
От
Andrew Dunstan
Тема
Re: why partition pruning doesn't work?
Дата
Msg-id
ba0c9a8d-61a8-b50b-6279-535174ac985b@2ndQuadrant.com
Ответ на
Список
Дерево обсуждения
why partition pruning doesn't work? Pavel Stehule <pavel.stehule@gmail.com>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Pavel Stehule <pavel.stehule@gmail.com>
Re: why partition pruning doesn't work? Jeff Janes <jeff.janes@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Dmitry Dolgov <9erthalion6@gmail.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Pavel Stehule <pavel.stehule@gmail.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Robert Haas <robertmhaas@gmail.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Tom Lane <tgl@sss.pgh.pa.us>
Re: why partition pruning doesn't work? Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: why partition pruning doesn't work? David Rowley <david.rowley@2ndquadrant.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: why partition pruning doesn't work? Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>


On 06/11/2018 06:41 PM, Andrew Dunstan wrote:
>
>
> On 06/11/2018 06:24 PM, Tom Lane wrote:
>>
>> If we had any buildfarm critters running valgrind on
>> RELCACHE_FORCE_RELEASE or CLOBBER_CACHE_ALWAYS builds, they'd have
>> detected use of uninitialized memory here ... but I don't think we have
>> any.  (The combination of valgrind and CCA would probably be too slow to
>> be practical :-(, though maybe somebody with a fast machine could do
>> the other thing.)
>>
>>
>
>
> I don't have a fast machine, but I do have a slow machine already 
> running valgrind and not doing much else :-) Let's see how lousyjack 
> does with -DRELCACHE_FORCE_RELEASE
>
>


It added about 20% to the run time. That's tolerable, so I'll leave it on.

cheers

andrew

-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-hackers по дате отправления
От: Andrew Dunstan
Дата:
От: Darafei Komяpa Praliaskouski
Дата:
FAQ