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 y

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 vi

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 (pgsql-general@postg

[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 simpl