Thread: Bug #834: not usage index in subquerys o inner joins

Gabriel Monsalvo (gmonsalvo@rentastucuman.gov.ar) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
not usage index in subquerys o inner joins

Long Description
PostgreSQL makes sequencial scans when uses subqueries or inner joins like:
select * from ctacte where numoble in (select numoble from obligacion where numoble='2500001368995');
or:
select c.* from ctacte c inner join obligacion o on (c.numoble=0.numoble and o.objeto='00000007314')

we have ten million of records in our tables and you can imagine how much time that takes long....

Any solution? or idea?

Sample Code


No file was uploaded with this report