Re: Sorting Improvements for 8.4

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Subject: Re: Sorting Improvements for 8.4
Date: 2007-12-20 22:17:51
Message-ID: 476AEA0F.9080702@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Mielke 2007-12-20 23:20:48 Re: Sorting Improvements for 8.4
Previous Message Dann Corbit 2007-12-20 20:35:02 Re: Sorting Improvements for 8.4