Home
About
Download
Documentation
Community
Developers
Support
Donate
Your account
Quick Links
Community
Contributors
Mailing Lists
IRC
Local User Groups
Events
International Sites
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:
2012-07-04 12:25:28 from Hermann Matthes <hermann(dot)matthes(at)web(dot)de>
2012-07-06 13:18:38 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
2012-07-06 13:19:15 from "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
2012-07-06 13:35:08 from Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>
2012-07-06 13:43:58 from Misa Simic <misa(dot)simic(at)gmail(dot)com>
2012-07-09 11:55:33 from Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
2012-07-09 12:02:38 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
2012-07-09 13:22:10 from Shaun Thomas <sthomas(at)optionshouse(dot)com>
2012-07-09 14:16:00 from Craig James <cjames(at)emolecules(dot)com>
2012-07-09 14:33:36 from Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>
2012-07-09 23:48:28 from Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
2012-07-09 17:41:09 from Misa Simic <misa(dot)simic(at)gmail(dot)com>
2012-07-09 17:46:26 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2012-07-09 18:13:16 from Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
2012-07-11 08:15:38 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
2012-07-11 08:23:01 from Віталій Тимчишин <tivv00(at)gmail(dot)com>
Lists:
pgsql-performance
Use cursors.
By far the most flexible. offset/limit have their down sides.
In response to
Re: Paged Query
at 2012-07-06 13:43:58 from Misa Simic
Responses
Re: Paged Query
at 2012-07-09 12:02:38 from Craig Ringer
Re: Paged Query
at 2012-07-09 17:41:09 from Misa Simic
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?