Gregory Stark wrote:
> Note that speeding up a query from 20s to 5s isn't terribly useful.
I disagree totally with that.
That is the difference between no chance of someone waiting for a web
page to load; vs. a good chance they'd wait. And 2s vs 0.5s is the
difference between a web site that feels responsive and one that doesn't.
> If it's OLTP you can't be using all your cores for each user anyways.
Even so, I'd much rather keep each response time lower. If web page
requests are coming in at 1 a second, it's much nicer to respond to
each of them in 1 second than in 4 seconds -- even if the overall
throughput is identical.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
