Re: Poor performance using CTE

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Claudio Freire <klaussfreire(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, David Greco <David_Greco(at)harte-hanks(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Poor performance using CTE
Date: 2012-11-21 15:32:22
Message-ID: CAEYLb_W3yc+L413=WjbLLBUzoYDhfygDVaAOCtE6WenR9rDo6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 21 November 2012 15:21, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> And I continue to think that spelling it "OFFSET 0" is horribly obscure.

I'm not sure that it's any more obscure than the very idea of an
optimisation fence.

--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gavin Flower 2012-11-21 15:42:16 Re: Poor performance using CTE
Previous Message Andres Freund 2012-11-21 15:32:09 Re: Poor performance using CTE