Accidentally sent directly to Josh.
---------- Forwarded message ---------- From: Joey Smith <[EMAIL PROTECTED]> Date: Fri, 10 Sep 2004 15:57:49 -0600 Subject: Re: [PERFORM] Interesting performance behaviour To: [EMAIL PROTECTED] > > I see a similar speedup (and change in query plan) using "LIMIT 1 > > OFFSET <anything besides 0>". > > So what's your problem? The problem is that "LIMIT 1 OFFSET 0" has such poor performance. I'm not so much worried about the query time (it's still low enough to be acceptable), but the fact that it behaves oddly raised the question of whether this was correct behaviour or not. I'll try it with a saner value for effective_cache_size. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html