| From: | ZEUGSWETTER Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
|---|---|
| To: | "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org> |
| Subject: | Re: create index updates nrows statistics |
| Date: | 1999-05-25 18:05:50 |
| Message-ID: | 219F68D65015D011A8E000006F8590C60267B376@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> a create index updates the statistics in pg_class,
> this leads to substantial performance degradation compared to
> 6.4.2.
>
> If you want to see what I mean simply run the performance test in
> our test subdirectory.
>
> I think the create index statement should not update this statistic.
> (at least not in the newly created empty table case)
> This behavior would then be in sync with the create table behavior.
>
To fix this I urgently suggest the following patch:
<<index.patch>>
regression passes and is a little faster :-)
performance test: without patch 7min now 22 sec
Andreas
| Attachment | Content-Type | Size |
|---|---|---|
| index.patch | application/octet-stream | 4.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vadim Mikheev | 1999-05-25 18:36:43 | Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction |
| Previous Message | The Hermit Hacker | 1999-05-25 17:54:35 | Re: [HACKERS] Call for updates! |