From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Dan Langille <dan@langille.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: extending ORDER BY make query much slower
Date: Wed, 12 Mar 2003 13:44:43 -0800 (PST)
Message-ID: <20030312134250.D56401-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3E6F45D8.15284.5994716@localhost>
On Wed, 12 Mar 2003, Dan Langille wrote:
> explain analyse
> SELECT element.id,
> commit_log.id AS my_commit_log_id,
> commit_log.message_id,
> to_char(commit_log.commit_date - SystemTimeAdjust(), 'DD Mon
> YYYY') AS commit_date,
> to_char(commit_log.commit_date - SystemTimeAdjust(),
> 'HH24:MI') AS commit_time,
> commit_log.committer,
> commit_log.description,
> commit_log.encoding_losses,
> commit_log.message_subject,
> element.name,
> commit_log_elements.revision_name,
> element_pathname(element.id) AS element_pathname
> FROM commit_log, commit_log_elements, element
> WHERE commit_log_elements.commit_log_id = commit_log.id
> AND commit_log_elements.element_id = element.id
> ORDER BY commit_log.commit_date DESC,
> my_commit_log_id
> LIMIT 100;
As a question, is it faster if both are marked DESC?
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-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, dan@langille.org
Subject: Re: extending ORDER BY make query much slower
In-Reply-To: <20030312134250.D56401-100000@megazone23.bigpanda.com>
* 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