Andrey,
- Another idea for your problem is the one Kevin gave in the message following:
##
> SELECT * FROM t_route
> WHERE t_route.route_type_fk = 1
> limit 4;
This
me=*0.026..0.028* rows=*3* loops=1)
2 ) -> Index Scan using core_object_pkey_desc on
core_object (cost=0.00..113516.08 rows=3091134 width=4) (actual
time=*0.027..284.195* rows=*1244479* loops=1)
1 ) Total runtime: 0.244 ms
2 ) Total runtime: 4436.894 ms
Regards...
--
Helio Campos Mello de Andrade
. Tomorrow i will take a look at the manual
and try to understand all the necessary for the postgresql use an index.
Regards
On Thu, Nov 6, 2008 at 2:33 PM, Віталій Тимчишин <[EMAIL PROTECTED]> wrote:
>
>
> 2008/11/6 Helio Campos Mello de Andrade <[EMAIL PROTECTED]>
>
>
ny_dup_cons_company
> as select * from production.company where 1=1 and status='unprocessed' and
> run_id in (select id from production.run where name='test')
>
>>
>>
>> Next, do:
>>
>> EXPLAIN ANALYZE select something from table where condition1 or
>> condition2;
>
>
> without analyze is in OR-plan.txt
> Also plans for only condition1, only condition2 and union is attached
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>
--
Helio Campos Mello de Andrade
