| From: | Daniel Åkerud <zilch(at)home(dot)se> |
|---|---|
| To: | "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Multiple Indexing, performance impact |
| Date: | 2001-06-22 18:06:03 |
| Message-ID: | 000a01c0fb45$fffcb2c0$c901a8c0@automatic100 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
I just made i simple little test application inserting 50'000 'pwgen 8' data into a table with only a primary key id and a text column.
In every run, it is all deleted and the tables are vacuumed.
Having one separate index on name it took 36 seconds
Having an additional index, also on name, it took 69 seconds.
Furthermore:
3 indexes: 97 seconds
4 indexes: 131 seconds
5 indexes: 163 seconds
6 indexes: 210 seconds
7 indexes: 319 seconds
8 indexes: 572 seconds
9 indexes: 831 seconds
10 indexes: 1219 seconds
Anyone know what causes the signifacant performance decrease after 7 indexes?
Daniel Åkerud
| From | Date | Subject | |
|---|---|---|---|
| Next Message | will trillich | 2001-06-22 18:12:06 | Re: where's the reference to a view, here? |
| Previous Message | will trillich | 2001-06-22 18:02:45 | Re: where's the reference to a view, here? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-06-22 18:48:25 | Re: Multiple Indexing, performance impact |
| Previous Message | Larry Rosenman | 2001-06-22 17:40:35 | Re: Why would this use 600Meg of VM? |