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

Поиск
Список
Период
Сортировка
От Relaxin
Тема Re: SELECT's take a long time compared to other DBMS
Дата
Msg-id bjbb9u$2mmc$1@news.hub.org
обсуждение исходный текст
Ответ на Re: SELECT's take a long time compared to other DBMS  ("Relaxin" <noname@spam.com>)
Список pgsql-performance
It is forward only in the ODBC driver.

"Neil Conway" <neilc@samurai.com> 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
>



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Serious issues with CPU usage
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Serious issues with CPU usage