Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
От
Piotr Gasidło
Тема
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND
SELECT ...
Дата
Msg-id
AANLkTimXCyTD7f8VX25MsixdvPV9Sj-MbiTHOZpNRBCq@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND
SELECT ... Piotr Gasidło <quaker@barbara.eu.org>
Re: Big difference in time returned by EXPLAIN ANALYZE
SELECT ... AND SELECT ... Craig Ringer <craig@postnewspapers.com.au>
Re: Big difference in time returned by EXPLAIN ANALYZE
SELECT ... AND SELECT ... Vitalii Tymchyshyn <tivv00@gmail.com>
Re: Big difference in time returned by EXPLAIN ANALYZE
SELECT ... AND SELECT ... Craig Ringer <craig@postnewspapers.com.au>
Re: Big difference in time returned by EXPLAIN ANALYZE
SELECT ... AND SELECT ... Lew <noone@lewscanon.com>
Re: Big difference in time returned by EXPLAIN ANALYZE
SELECT ... AND SELECT ... Vitalii Tymchyshyn <tivv00@gmail.com>
Re: Big difference in time returned by EXPLAIN ANALYZE
SELECT ... AND SELECT ... Piotr Gasidło <quaker@barbara.eu.org>
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... Tom Lane <tgl@sss.pgh.pa.us>
Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND
SELECT ... Piotr Gasidło <quaker@barbara.eu.org>
W dniu 26 lipca 2010 10:35 użytkownik Piotr Gasidło
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 по дате отправления
От: Piotr Gasidło
Дата:
