On Tuesday 07 October 2008 08:20:16 am you wrote: > On Tue, Oct 7, 2008 at 11:11 AM, johnf <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
