Indexen on 8.0.3

Поиск
Список
Период
Сортировка
От han.holl@informationslogik.nl
Тема Indexen on 8.0.3
Дата
Msg-id 200510061656.10741.han.holl@informationslogik.nl
обсуждение исходный текст
Ответы Re: Indexen on 8.0.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

After upgrading to 8.0.3 I see very poor performance on several indexes.
Like this: (udps is a view on main)

palga=> explain analyze select rapnaam from udps where naamvrouw like 'vos%';
                                                     QUERY PLAN
--------------------------------------------------------------------------------------------------------------------
 Index Scan using nv on main  (cost=0.00..242.65 rows=60 width=14) (actual
time=6.475..11598.502 rows=5692 loops=1)
   Index Cond: (((naamvrouw)::text >= 'vos'::character varying) AND
((naamvrouw)::text < 'vot'::character varying))
   Filter: ((naamvrouw)::text ~~ 'vos%'::text)
 Total runtime: 11606.250 ms
(4 rows)

The index was created with:
CREATE INDEX nv ON main USING btree (naamvrouw);

Database was recently analyzed. Clearly, something has to be tuned that didn't
need tuning on 7.4.3 ? (Main table has about 1.7 million records).

Any suggestions welcome.

Cheers,

Han Holl

В списке pgsql-general по дате отправления:

Предыдущее
От: Zlatko Matić
Дата:
Сообщение: Re: [INTERFACES] [ODBC] Unbound text box, Text > 255 characters, MSAccess/PostgreSQL
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: pg_restore --disable-triggers does not stop triggers