Re: Query performance discontinuity - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Query performance discontinuity
Date
Msg-id 200211111114.49300.josh@agliodbs.com
Whole thread Raw
In response to Query performance discontinuity  (Mike Nielsen <miken@bigpond.net.au>)
List pgsql-performance
Mike,

> Just out of curiosity, anybody with any ideas on what happens to this
> query when the limit is 59626?  It's as though 59626 = infinity?

I'd suspect that this size has something to do with your system resources.
have you tried this test on other hardware?

BTW, my experience is that Celerons are dog-slow at anything involveing large
or complex queries.   Something to do with the crippled cache, I think.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Slow response from 'SELECT * FROM table'
Next
From: Stephan Szabo
Date:
Subject: Re: Query performance discontinuity