create index updates nrows statistics - Mailing list pgsql-hackers

From ZEUGSWETTER Andreas IZ5
Subject create index updates nrows statistics
Date
Msg-id 219F68D65015D011A8E000006F8590C60267B374@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: [HACKERS] create index updates nrows statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
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.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: INSERT INTO view means what exactly?
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] createlang - ?