Postgres Pro
Downloads
Home   >   mailing lists

Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... - Mailing list pgsql-performance

From Piotr Gasidło
Subject Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
Date
Msg-id AANLkTimXCyTD7f8VX25MsixdvPV9Sj-MbiTHOZpNRBCq@mail.gmail.com
Whole thread Raw
In response to Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...  (Piotr Gasidło <quaker@barbara.eu.org>)
List pgsql-performance
Tree view 
W dniu 26 lipca 2010 10:35 użytkownik Piotr Gasidło
<quaker@barbara.eu.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

pgsql-performance by date:

Previous
From: Piotr Gasidło
Date:
Subject: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
Next
From: Vlad Arkhipov
Date:
Subject: Explains of queries to partitioned tables