Postgres Pro
Downloads
Home   >   mailing lists

Re: Why this Query Plan is different - Mailing list pgsql-admin

From Tom Lane
Subject Re: Why this Query Plan is different
Date
Msg-id 26503.1111675756@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why this Query Plan is different  ("Thilina Gunasekara" <tgunasekara@openworld.org>)
List pgsql-admin
Tree view 
"Thilina Gunasekara" <tgunasekara@openworld.org> 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 effort into fixing IN in 7.4 ;-)

            regards, tom lane

pgsql-admin by date:

Previous
From: "Joel Fradkin"
Date:
Subject: Admin tools with the ability to alter a field type?
Next
From: "Lee Wu"
Date:
Subject: pg_dump, pg_restore, insert vs copy