From: Frank van Vugt <ftm.van.vugt@foxi.nl>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
Date: Wed, 16 Jun 2004 10:42:10 +0200
Message-ID: <200406161042.10259.ftm.van.vugt@foxi.nl> (raw)
In-Reply-To: <3139.1087322681@sss.pgh.pa.us>
References: <200406150849.29470.ftm.van.vugt@foxi.nl>
<200406151730.40464.ftm.van.vugt@foxi.nl>
<3139.1087322681@sss.pgh.pa.us>
> We don't attempt to make every possible inference (and I don't think
> you'd like it if we did).
I wasn't really asking you to, either ;))
Just trying to achieve a more in-depth understanding of the way things work.
> This example doesn't
> persuade me that it would be worth expending the cycles to do so.
In the real thing I can easily get good processing times by adding an extra
join with article inside in the group by and simply use the constraint on
that as well, so I'm ok with any choice you make on this.
I thought this might have been some kind of special case though, given its
occurence on the use of group by.
> for example, zero and minus zero in IEEE-standard float arithmetic.
Good example, brings back a few memories as well ;)
Thanks for your explanation, Tom!
--
Best,
Frank.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ftm.van.vugt@foxi.nl, tgl@sss.pgh.pa.us
Subject: Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??
In-Reply-To: <200406161042.10259.ftm.van.vugt@foxi.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox