Re: [PERFORM] OFFSET/LIMIT - Disparate Performance w/ Go application

2014-06-12 Thread Matt Silverlock
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

[PERFORM] OFFSET/LIMIT - Disparate Performance w/ Go application

2014-06-12 Thread Matt Silverlock
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