Re: Paged Query

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: Misa Simic <misa(dot)simic(at)gmail(dot)com>
Cc: Hermann Matthes <hermann(dot)matthes(at)web(dot)de>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Paged Query
Date: 2012-07-09 11:55:33
Message-ID: CAJY59_icde+87mo65fJT8v9GdOTFemQFMNg5mxy52GCgjVe85w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Use cursors.
By far the most flexible. offset/limit have their down sides.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2012-07-09 12:02:38 Re: Paged Query
Previous Message Yan Chunlu 2012-07-09 09:20:56 Re: how could select id=xx so slow?