Re: extremly bad select performance on huge table

From: Björn Wittich <Bjoern_Wittich(at)gmx(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: extremly bad select performance on huge table
Date: 2014-10-22 15:13:42
Message-ID: 5447C9A6.3000107@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)gmx(dot)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
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message pinker 2014-10-23 13:24:00 Checkpoints tuning
Previous Message Kevin Grittner 2014-10-22 14:53:59 Re: extremly bad select performance on huge table