Skip site navigation (1) Skip section navigation (2)

Re: Useless sort by

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: gnuoytr(at)rcn(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Useless sort by
Date: 2010-09-23 04:01:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
gnuoytr(at)rcn(dot)com wrote:
> Spoken like a dyed in the wool COBOL coder.  The RM has no need for order; it's set based.  I've dabbled in PG for some time, and my sense is increasingly that PG developers are truly code oriented, not database (set) oriented.  

I can't tell if you meant for this to be insulting or my reading it that 
way is wrong, but it certainly wasn't put in a helpful tone.  Let me 
summarize for you.  You've been told that putting ORDER BY into a view 
is a generally poor idea anyway, that it's better to find ways avoid 
this class of concern altogether.  There are significant non-obvious 
technical challenges behind actually implementing the behavior you'd 
like to see; the concerns raised by Tom and Maciek make your idea 
impractical even if it were desired.  And for every person like yourself 
who'd see the benefit you're looking for, there are far more that would 
find a change in this area a major problem.  The concerns around 
breakage due to assumed but not required aspects of the relational model 
are the ones the users of the software will be confused by, not the 
developers of it.  You have the classification wrong; the feedback 
you've gotten here is from the developers being user oriented, not 
theory oriented or code oriented. 

Greg Smith, 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services and Support
Author, "PostgreSQL 9.0 High Performance"    Pre-ordering at:

In response to


pgsql-performance by date

Next:From: Scott MarloweDate: 2010-09-23 04:18:27
Subject: Re: Useless sort by
Previous:From: gnuoytrDate: 2010-09-23 03:05:31
Subject: Re: Useless sort by

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group