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

From: Neil Conway <neilc(at)samurai(dot)com>
To: Relaxin <noname(at)spam(dot)com>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SELECT's take a long time compared to other DBMS
Date: 2003-09-05 21:09:49
Message-ID: 1062796189.447.9.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-09-05 21:52:55 Re: [PERFORM] Seq scan of table?
Previous Message Bruce Momjian 2003-09-05 21:02:02 Re: [GENERAL] how to get accurate values in pg_statistic