Re: Dealing with big tables
От
Guillaume Smet
Тема
Re: Dealing with big tables
Дата
Msg-id
1d4e0c10712020355j133e0d31n653a531da1834c80@mail.gmail.com
Ответ на
Dealing with big tables (Mindaugas)
Список
Дерево обсуждения
Dealing with big tables "Mindaugas" <ml@kilimas.com>
Re: Dealing with big tables Sami Dalouche <skoobi@free.fr>
Re: Dealing with big tables "Mindaugas" <ml@kilimas.com>
Re: Dealing with big tables "Guillaume Smet" <guillaume.smet@gmail.com>
Re: Dealing with big tables Mark Kirkwood <markir@paradise.net.nz>
Re: Dealing with big tables Matthew <matthew@flymine.org>
Re: Dealing with big tables Gregory Stark <stark@enterprisedb.com>
Re: Dealing with big tables "Mindaugas" <ml@kilimas.com>
Re: Dealing with big tables "Merlin Moncure" <mmoncure@gmail.com>
On Dec 2, 2007 11:26 AM, Mindaugas wrote: > I execute simple query "select * from bigtable where From='something'". Query returns like 1000 rows and takes 5++ seconds to complete. As far as I understand the query is slow because: Can you post an EXPLAIN ANALYZE? Which version of PostgreSQL do you use? -- Guillaume
В списке pgsql-performance по дате отправления
