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
Ответ на
Re: why partition pruning doesn't work? (Andrew Dunstan)
Список
Дерево обсуждения
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
Дата: