Re: SELECT's take a long time compared to other DBMS

From: "Relaxin" <noname(at)spam(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT's take a long time compared to other DBMS
Date: 2003-09-06 00:55:46
Message-ID: bjbb9u$2mmc$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

It is forward only in the ODBC driver.

"Neil Conway" <neilc(at)samurai(dot)com> wrote in message
news:1062796189(dot)447(dot)9(dot)camel(at)tokyo(dot)(dot)(dot)
> 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
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hannu Krosing 2003-09-06 09:10:13 Re: Serious issues with CPU usage
Previous Message Tom Lane 2003-09-06 00:05:00 Re: Serious issues with CPU usage