Postgres Pro
Downloads
Home   >   mailing lists

improve docs on min()/max() performance - Mailing list pgsql-patches

From Neil Conway
Subject improve docs on min()/max() performance
Date
Msg-id 1044156596.760.29.camel@tokyo
Whole thread Raw
Responses Re: improve docs on min()/max() performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: improve docs on min()/max() performance  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Tree view 
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@samurai.com> || PGP Key ID: DB3C29FC
Attachment

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpython: fix for improperly handled NULL arguments in prepared plans
Next
From: Alex Cichowski
Date:
Subject: Re: getpeereid() for local ident