Re: Sorting Improvements for 8.4 - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: Sorting Improvements for 8.4
Date
Msg-id 476AEA0F.9080702@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Sorting Improvements for 8.4  (Gregory Stark <stark@enterprisedb.com>)
List 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.



pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Sorting Improvements for 8.4
Next
From: Mark Mielke
Date:
Subject: Re: Sorting Improvements for 8.4