Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set

От: Kris Jurka
Тема: Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
Дата: ,
Msg-id: alpine.BSO.2.00.1004211359050.9190@leary.csoft.net
(см: обсуждение, исходный текст)
Ответ на: Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Nikolas Everett)
Список: pgsql-performance

Скрыть дерево обсуждения

SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Dave Crooke, )
 [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  ("Kevin Grittner", )
  Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Dave Crooke, )
   Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  ("Kevin Grittner", )
    Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Dave Crooke, )
     Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Nikolas Everett, )
     Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  ("Kevin Grittner", )
      Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Dave Crooke, )
       Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Kris Jurka, )
        Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Robert Haas, )
         Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Nikolas Everett, )
          Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Tom Lane, )
           Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Nikolas Everett, )
          Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Kris Jurka, )
         Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Kris Jurka, )
 Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set  (Kris Jurka, )


On Wed, 21 Apr 2010, Nikolas Everett wrote:

> More to the point is there some option that can shift you into method a?
>  I'm thinking of warehousing type applications where you want to re-plan
> a good portion of your queries.
>

This can be done by connecting to the database using the V2 protocol (use
URL option protocolVersion=2).  This does remove some functionality of
the driver that is only available for V3 protocol, but will work just
fine for query execution.

Kris Jurka


В списке pgsql-performance по дате сообщения:

От: Eliot Gable
Дата:
Сообщение: Replacing Cursors with Temporary Tables
От: Mark Wong
Дата:
Сообщение: Re: [PERFORM] Dbt2 with postgres issues on CentOS-5.3‏