Re: Slow query and indexes...
От
Jim Nasby
Тема
Re: Slow query and indexes...
Дата
Msg-id
92B150E6-C210-4797-B407-88B66A55ACD7@decibel.org
Ответ на
Slow query and indexes... (Jonas Henriksen)
Список
Дерево обсуждения
Slow query and indexes... "Jonas Henriksen" <jonas.f.henriksen@gmail.com>
Re: Slow query and indexes... Peter Eisentraut <peter_e@gmx.net>
Re: Slow query and indexes... "Jonas Henriksen" <jonas.f.henriksen@gmail.com>
Re: Slow query and indexes... Jim Nasby <decibel@decibel.org>
Re: Slow query and indexes... Andrew Kroeger <andrew@sprocks.gotdns.com>
Re: Slow query and indexes... "Jonas Henriksen" <jonas.f.henriksen@gmail.com>
Re: Slow query and indexes... PFC <lists@peufeu.com>
Re: Slow query and indexes... Jim Nasby <decibel@decibel.org>
Re: Slow query and indexes... "Isak Hansen" <isak.hansen@gmail.com>
Re: Slow query and indexes... Jim Nasby <decibel@decibel.org>
On May 7, 2007, at 8:53 AM, Jonas Henriksen wrote: > while if I add a GROUP BY data_logger the query uses a seq scan and a > lot of time: >>> explain analyze SELECT max(date_time) FROM data_values GROUP BY > data_logger_id; What do you get if you run that with SET enable_seqscan = off; ? -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
В списке pgsql-general по дате отправления
