On Tuesday 07 October 2008 08:20:16 am you wrote: > On Tue, Oct 7, 2008 at 11:11 AM, johnf <jfabiani@xxxxxxxx> wrote: > > I then thought it had something to do with the data -although the data > > set is small. I did a complete dump and restored on his machine and > > again got the same results. The machine has a recent motherboard with 2 > > gb of ram. It does not appear to be swapping out ram. > > The standard first question- has the 8.3 db been analyzed? > > Compare the plans from the two systems- you may be getting different > plans that account for the apparent slowdown. No I did not check. But we are talking about very small data sets. No table has more than 50 rows. I doubt that analyze will provide anything - but I could be wrong. There is about 20 SQL statements that read data (selects only) and they are very straight forward without joins or sub-selects. So I'm thinking it has something to do with the way windows runs postgres or a setting in XP. -- John Fabiani
