[GENERAL] Postgres 8.3 is not using indexes

2008-08-14 Thread Clemens Schwaighofer
Hi, i just stumbled on something very strange. I have here a Postgres 8.3 and a Postgres 8.2 installation, as I am in the process of merging. Both are from the debian/testing tree, both have the same configuration file. In my DB where I found out this trouble I have two tables, I do a very

Re: [GENERAL] Postgres 8.3 is not using indexes

2008-08-14 Thread Peter Eisentraut
Am Thursday, 14. August 2008 schrieb Clemens Schwaighofer: Why is Postgres not using the indexes in the 8.3 installation. Might have something to do with the removal of some implicit casts. You should show us your table definitions. -- Sent via pgsql-general mailing list

Re: [GENERAL] Postgres 8.3 is not using indexes

2008-08-14 Thread Gregory Stark
Clemens Schwaighofer [EMAIL PROTECTED] writes: Any tips why this is so? They don't appear to contain the same data. If they do have you run analyze recently? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via

Re: [GENERAL] Postgres 8.3 is not using indexes

2008-08-14 Thread Schwaighofer Clemens
On Thu, Aug 14, 2008 at 20:27, Peter Eisentraut [EMAIL PROTECTED] wrote: Am Thursday, 14. August 2008 schrieb Clemens Schwaighofer: Why is Postgres not using the indexes in the 8.3 installation. Might have something to do with the removal of some implicit casts. You should show us your