Re: create index updates nrows statistics - Mailing list pgsql-hackers

From ZEUGSWETTER Andreas IZ5
Subject Re: create index updates nrows statistics
Date
Msg-id 219F68D65015D011A8E000006F8590C60267B376@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
In response to create index updates nrows statistics  (ZEUGSWETTER Andreas IZ5 <Andreas.Zeugswetter@telecom.at>)
Responses Re: [HACKERS] Re: create index updates nrows statistics
List 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

pgsql-hackers by date:

Previous
From: Ari Halberstadt
Date:
Subject: pg_dump core dump, upgrading from 6.5b1 to 5/24 snapshot
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction