Postgres Pro
Downloads
Home   >   mailing lists

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

From Björn Wittich
Subject Re: extremly bad select performance on huge table
Date
Msg-id 5447C9A6.3000107@gmx.de
Whole thread Raw
In response to Re: extremly bad select performance on huge table  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: extremly bad select performance on huge table
List pgsql-performance
Tree view 
Hi Kevin,


this is what I need (I think). Hopefully a cursor can operate on a
join.  Will read docu now.

Thanks!


Björn

Am 22.10.2014 16:53, schrieb Kevin Grittner:
> 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: Kevin Grittner
Date:
Subject: Re: extremly bad select performance on huge table
Next
From: pinker
Date:
Subject: Checkpoints tuning