pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-performance@postgresql.org
Subject: Re: seq scan in the case of max() on the primary key column
Date: Wed, 22 Jun 2011 13:01:43 -0400
Message-ID: <4E021FF7.7@2ndQuadrant.com> (raw)
In-Reply-To: <BANLkTim5saGCxhLCAx4nEUQ4tZuOSy65fg@mail.gmail.com>
References: <BANLkTikntdSrhneCPzPutY9T-sAQpFXTMw@mail.gmail.com>
	<BANLkTikuFEyOse=sUoH0BXYrpUW=7Pp_tw@mail.gmail.com>
	<4DFA4D2F.8020101@peak6.com>
	<BANLkTim5saGCxhLCAx4nEUQ4tZuOSy65fg@mail.gmail.com>

On 06/22/2011 05:55 AM, Marti Raudsepp wrote:
> Now I created a wiki snippet page for this handy
> feature here:
> https://wiki.postgresql.org/wiki/Efficient_min/max_over_partitioned_table
>    

I just tweaked this a bit to document the version compatibility issues 
around it and make it easier to follow.  I think that's now the page we 
should point people toward when this pops up again.  Between that and my 
blog post I reference in it, they can find all the details and a 
workaround in one place.

-- 
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books




view thread (15+ messages)  latest in thread

Message-ID: <4E021FF7.7@2ndQuadrant.com>
Permalink:  ../4E021FF7.7@2ndQuadrant.com/
Also on:    postgresql.org/message-id/4E021FF7.7@2ndQuadrant.com

 · 

reply
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: greg@2ndQuadrant.com
  Subject: Re: seq scan in the case of max() on the primary key column
  In-Reply-To: <4E021FF7.7@2ndQuadrant.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