Thanks for the replies Jeff, Tom and Merlin.
>> Pages that SELECT multiple rows with OFFSET and LIMIT conditions struggle to
>> top 1.3k req/s
>
> Is that tested at the OFFSET and LIMIT of 0 and 15, as shown in the
> explain plan?
Yes — 0 (OFFSET) and 16 (LIMIT), or 15 and 31 (i.e. “second pag
On Thu, Jun 12, 2014 at 12:08 AM, Matt Silverlock
wrote:
>
> Pages that SELECT multiple rows with OFFSET and LIMIT conditions struggle to
> top 1.3k req/s
Is that tested at the OFFSET and LIMIT of 0 and 15, as shown in the
explain plan?
> The query in question is: http://explain.depesz.com/s/7
On Thu, Jun 12, 2014 at 2:48 PM, Andreas Joseph Krogh
wrote:
>
> På torsdag 12. juni 2014 kl. 16:58:06, skrev Tom Lane :
>
> Matt Silverlock writes:
> > Hi all. This might be tricky in so much as there���s a few moving parts
> > (when isn���t there?), but I���ve tried to test the postgres side a
På torsdag 12. juni 2014 kl. 16:58:06, skrev Tom Lane mailto:t...@sss.pgh.pa.us>>: Matt Silverlock writes:
> Hi all. This might be tricky in so much as there���s a few moving parts
(when isn���t there?), but I���ve tried to test the postgres side as much as
possible.
> Trying to work out a pot
On Thu, Jun 12, 2014 at 9:58 AM, Tom Lane wrote:
> Matt Silverlock writes:
>> Hi all. This might be tricky in so much as there’s a few moving parts (when
>> isn’t there?), but I’ve tried to test the postgres side as much as possible.
>> Trying to work out a potential database bottleneck with a H
Matt Silverlock writes:
> Hi all. This might be tricky in so much as thereâs a few moving parts (when
> isnât there?), but Iâve tried to test the postgres side as much as
> possible.
> Trying to work out a potential database bottleneck with a HTTP application
> (written in Go):
> Pages th
Hi all. This might be tricky in so much as there’s a few moving parts (when
isn’t there?), but I’ve tried to test the postgres side as much as possible.
Trying to work out a potential database bottleneck with a HTTP application
(written in Go):
Pages that render HTML templates but don’t perform
