X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 59B10D1B4E2 for ; Sat, 6 Sep 2003 01:07:11 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 43714-05 for ; Fri, 5 Sep 2003 22:07:02 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id AD050D1BA5D for ; Fri, 5 Sep 2003 22:07:00 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h8616tsn091068 for ; Sat, 6 Sep 2003 01:06:59 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h860tQSc088781 for pgsql-performance@postgresql.org; Sat, 6 Sep 2003 00:55:26 GMT From: "Relaxin" X-Newsgroups: comp.databases.postgresql.performance Subject: Re: SELECT's take a long time compared to other DBMS Date: Fri, 5 Sep 2003 17:55:46 -0700 Organization: Hub.Org Networking Services Lines: 22 Message-ID: References: <1062796189.447.9.camel@tokyo> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/111 X-Sequence-Number: 3477 It is forward only in the ODBC driver. "Neil Conway" wrote in message news:1062796189.447.9.camel@tokyo... > On Fri, 2003-09-05 at 14:18, Relaxin wrote: > > Expect that the Declare/Fetch only creates a forwardonly cursor, you can go > > backwards thru the result set. > > No, DECLARE can create scrollable cursors, read the ref page again. This > functionality is much improved in PostgreSQL 7.4, though. > > -Neil > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match >