Re: [ADMIN] Why this Query Plan is different

2005-03-24 Thread Tom Lane
"Thilina Gunasekara" <[EMAIL PROTECTED]> writes: > This is Box A which runs on 7.4.5 and delivers very quick result. > ... > ** And this is the Box B which runs on 7.3.9 and takes hours to deliver > the result. Well, that's what I'd expect. There's a reason why we put a great deal of eff

Re: [ADMIN] Why this Query Plan is different

2005-03-24 Thread Thilina Gunasekara
IL PROTECTED] Cc: PGSQL Admin Subject: Re: [ADMIN] Why this Query Plan is different "Thilina Gunasekara" <[EMAIL PROTECTED]> writes: > I have two PostgreSQL Database Servers running on Gentoo which versions are > PostgreSQL 7.4.5 (Box A) and PostgreSQL 7.3.9 (Box B) >

Re: [ADMIN] Why this Query Plan is different

2005-03-23 Thread Tom Lane
"Thilina Gunasekara" <[EMAIL PROTECTED]> writes: > I have two PostgreSQL Database Servers running on Gentoo which versions are > PostgreSQL 7.4.5 (Box A) and PostgreSQL 7.3.9 (Box B) > Due to a recent query posted by a developer I was interested to know which > factors are affecting these two serve