X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5A4DA329E6A for ; Fri, 10 Sep 2004 23:02:15 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30541-05 for ; Fri, 10 Sep 2004 22:02:07 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.204]) by svr1.postgresql.org (Postfix) with ESMTP id 0FA64329E6C for ; Fri, 10 Sep 2004 23:02:05 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so553067rnk for ; Fri, 10 Sep 2004 15:02:05 -0700 (PDT) Received: by 10.38.22.67 with SMTP id 67mr2240688rnv; Fri, 10 Sep 2004 15:02:05 -0700 (PDT) Received: by 10.38.181.20 with HTTP; Fri, 10 Sep 2004 15:02:05 -0700 (PDT) Message-ID: Date: Fri, 10 Sep 2004 16:02:05 -0600 From: Joey Smith Reply-To: Joey Smith To: pgsql-performance@postgresql.org Subject: Fwd: Interesting performance behaviour In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <200409101446.53309.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/66 X-Sequence-Number: 8194 Accidentally sent directly to Josh. ---------- Forwarded message ---------- From: Joey Smith Date: Fri, 10 Sep 2004 15:57:49 -0600 Subject: Re: [PERFORM] Interesting performance behaviour To: josh@agliodbs.com > > I see a similar speedup (and change in query plan) using "LIMIT 1 > > OFFSET ". > > 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.