From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: tgl@sss.pgh.pa.us
To: bruno@wolff.to
Cc: linux@alteeve.com
Cc: john@arbash-meinel.com
Cc: tobias@nordicbet.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Index ot being used
Date: Mon, 13 Jun 2005 11:46:46 -0500
Message-ID: <s2ad7232.064@gwmta.wicourts.gov> (raw)
I agree that ignoring useless columns in an ORDER BY clause is less
important than ignoring index columns where the value is fixed. There
is one use case for ignoring useless ORDER BY columns that leaps to
mind, however -- a column is added to the ORDER BY clause of a query to
help out the optimizer, then the indexes are modified such that that
column is no longer useful. Whether this merits the programming effort
and performance hit you describe seems highly questionable, though.
-Kevin
>>> Tom Lane <tgl@sss.pgh.pa.us> 06/13/05 11:22 AM >>>
I don't think the use-case has been shown that justifies doing this much
work to ignore useless ORDER BY clauses. The examples that have come up
in the past all suggest ignoring index columns not the other way 'round.
Can you make a case that we need to do that part of it?
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: Kevin.Grittner@wicourts.gov, tgl@sss.pgh.pa.us, bruno@wolff.to, linux@alteeve.com, john@arbash-meinel.com, tobias@nordicbet.com
Subject: Re: Index ot being used
In-Reply-To: <s2ad7232.064@gwmta.wicourts.gov>
* 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