Re: database not using indexes, yet
От
Szymon Guz
Тема
Re: database not using indexes, yet
Дата
Msg-id
CAFjNrYvvBgm=qG2cPjqojhJ_pfAMgTT-q1Abq4-R3X4BAtixRQ@mail.gmail.com
Ответ на
database not using indexes, yet (Silvio Brandani)
Список
Дерево обсуждения
database not using indexes Silvio Brandani <silvio.brandani@tech.sdb.it>
Re: database not using indexes "Ruslan A. Bondar" <fsat@list.ru>
Re: database not using indexes Silvio Brandani <silvio.brandani@tech.sdb.it>
Re: database not using indexes Craig Ringer <ringerc@ringerc.id.au>
Re: database not using indexes Craig Ringer <ringerc@ringerc.id.au>
Re: database not using indexes "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
database not using indexes, yet Silvio Brandani <silvio.brandani@tech.sdb.it>
Re: database not using indexes, yet Tom Lane <tgl@sss.pgh.pa.us>
Re: database not using indexes, yet Silvio Brandani <silvio.brandani@tech.sdb.it>
Re: database not using indexes, yet Tom Lane <tgl@sss.pgh.pa.us>
Re: database not using indexes, yet Szymon Guz <mabewlun@gmail.com>
Re: database not using indexes, yet Silvio Brandani <silvio.brandani@tech.sdb.it>
2011/11/18 Silvio Brandani <silvio.brandani@tech.sdb.it>
On postgres 8.3.11 on linux centos 5 we have a table not too big with primary key index on
Indexes:
"aida_references_pkey" PRIMARY KEY, btree (aida_reference_id)
the query not use index:
aidadb=# explain analyze select aida_reference_id from aida.aida_references where aida_reference_id = '3145';
QUERY PLAN
----------------------------------------------------------------------------------------------------------------
Seq Scan on aida_references (cost=0.00..51489.15 rows=1 width=4) (actual time=0.173..1457.643 rows=1 loops=1)
Filter: (aida_reference_id = 3145)
Total runtime: 1457.696 ms
already executed the vacuum ,reindex.
Please help
--
Silvio Brandani
Hi Silvio,
how many rows do you have in the table?
Usually PostgreSQL doesn't want to use index when the table is small.
regards
Szymon
http://simononsoftware.com/
В списке pgsql-admin по дате отправления
