Postgres Pro
Downloads
Home   >   mailing lists

Re: extremly bad select performance on huge table - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: extremly bad select performance on huge table
Date
Msg-id 1413989639.83279.YahooMailNeo@web122306.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: extremly bad select performance on huge table  (Björn Wittich <Bjoern_Wittich@gmx.de>)
Responses Re: extremly bad select performance on huge table
List pgsql-performance
Tree view 
Björn Wittich <Bjoern_Wittich@gmx.de> wrote:

> I do not want the db server to prepare the whole query result at
> once, my intention is that the asynchronous retrieval starts as
> fast as possible.

Then you probably should be using a cursor.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: Igor Neyman
Date:
Subject: Re: extremly bad select performance on huge table
Next
From: Björn Wittich
Date:
Subject: Re: extremly bad select performance on huge table