improve docs on min()/max() performance

From: Neil Conway <neilc(at)samurai(dot)com>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: improve docs on min()/max() performance
Date: 2003-02-02 03:30:28
Message-ID: 1044156596.760.29.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

This patch adds a note to the documentation describing why the
performance of min() and max() is slow when applied to the entire table,
and suggesting the simple workaround most experienced Pg users
eventually learn about (SELECT xyz ... ORDER BY xyz LIMIT 1).

Any suggestions on improving the wording of this section would be
welcome.

Cheers,

Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

Attachment Content-Type Size
min-max-perf-doc-1.patch text/x-patch 2.6 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-02-02 07:44:31 Re: getpeereid() for local ident
Previous Message Alex Cichowski 2003-02-01 12:30:41 Re: getpeereid() for local ident