From: | han(dot)holl(at)informationslogik(dot)nl |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Indexen on 8.0.3 |
Date: | 2005-10-06 14:56:10 |
Message-ID: | 200510061656.10741.han.holl@informationslogik.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2005-10-06 15:03:30 | Re: pg_restore --disable-triggers does not stop triggers |
Previous Message | CN | 2005-10-06 14:33:52 | pg_restore --disable-triggers does not stop triggers |