Postgres Pro
Downloads
Home   >   mailing lists

Re: why partition pruning doesn't work? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: why partition pruning doesn't work?
Date
Msg-id 23131.1529071325@sss.pgh.pa.us
Whole thread Raw
In response to Re: why partition pruning doesn't work?  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Responses Re: why partition pruning doesn't work?
List pgsql-hackers
Tree view 
Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
> OK, lousyjack is back online with this, new and improved. It currently 
> takes 7.5 hours for a run.  Should I also add -DCATCACHE_FORCE_RELEASE?

I did some experimentation yesterday with valgrind plus both
RELCACHE_FORCE_RELEASE and CATCACHE_FORCE_RELEASE.  I didn't find
any new bugs, but adding CATCACHE_FORCE_RELEASE makes things quite
a lot slower :-(.  Not sure it's worth it.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: why partition pruning doesn't work?
Next
From: Andrew Dunstan
Date:
Subject: Re: why partition pruning doesn't work?