Re: [PERFORM] [SQL] ORDER BY Optimization

2005-05-07 Thread Tom Lane
[ cc list limited to -performance ] Derek Buttineau|Compu-SOLVE <[EMAIL PROTECTED]> writes: >> It seems to me a merge join might be more appropriate here than a >> nestloop. After some experimentation, I don't seem to be able to get the planner to generate a mergejoin based on a backwards index s

Re: [PERFORM] Whence the Opterons?

2005-05-07 Thread Josh Berkus
A- > On Fri, May 06, 2005 at 02:39:11PM -0700, Mischa Sandberg wrote: > > IBM, Sun and HP have their fairly pricey Opteron systems. > > We've had some quite good experiences with the HP boxes. They're not > cheap, it's true, but boy are they sweet. Question, though: is HP still using their propr

Re: [PERFORM] Bad choice of query plan from PG 7.3.6 to PG 7.3.9

2005-05-07 Thread Tom Lane
Jona <[EMAIL PROTECTED]> writes: > anyway, here's the info for relpages: > Live Server: 424 > Test Server: 338 I was asking about the indexes associated with the table, not the table itself. regards, tom lane ---(end of broadcast)--

Re: [PERFORM] Whence the Opterons?

2005-05-07 Thread Andrew Sullivan
On Fri, May 06, 2005 at 02:39:11PM -0700, Mischa Sandberg wrote: > IBM, Sun and HP have their fairly pricey Opteron systems. We've had some quite good experiences with the HP boxes. They're not cheap, it's true, but boy are they sweet. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future t

Re: [PERFORM] Bad choice of query plan from PG 7.3.6 to PG 7.3.9

2005-05-07 Thread Jona
Wouldn't the VACUUM have made them equivalent?? anyway, here's the info for relpages: Live Server: 424 Test Server: 338 Please note though that there're more rows on the live server than on the test server due to recent upload. Total Row counts are as follows: Live Server: 12597 Test Server: