[PERFORM] Can improve 'limit 1' ? with slow function

2014-06-27 Thread songtebo
The simplified scene: select slowfunction() from a order by b limit 1 is slow than select slowfunction() from ( select * from a order by b limit 1) if there are many records in table 'a' The real scene: function ST_Distance_Sphere is slow than ST_Distance, the query: SELECT ST_Distance_Sphere(

[PERFORM] Unsubscribe

2004-11-24 Thread songtebo
Unsubscribe ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]