Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...

From: Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
Date: 2010-07-26 08:44:15
Message-ID: AANLkTimXCyTD7f8VX25MsixdvPV9Sj-MbiTHOZpNRBCq@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

W dniu 26 lipca 2010 10:35 użytkownik Piotr Gasidło
<quaker(at)barbara(dot)eu(dot)org> napisał:
>> \d+ ocache_2010_12
>                              Table "public.ocache_2010_12"
> Indexes:
> (...)

Missed index in listing:
"ocache_2010_12_ukey" UNIQUE, btree (oc_date_from, oc_date_to,
oc_h_id, oc_transport, oc_ofc_id_1) WITH (fillfactor=80)

--
Piotr Gasidło

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vlad Arkhipov 2010-07-26 08:47:00 Explains of queries to partitioned tables
Previous Message Piotr Gasidło 2010-07-26 08:35:43 Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...