Gabriel Monsalvo ([EMAIL PROTECTED]) 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
