create index updates nrows statistics

From: ZEUGSWETTER Andreas IZ5 <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'hackers(at)postgresql(dot)org'" <hackers(at)postgresql(dot)org>
Subject: create index updates nrows statistics
Date: 1999-05-25 15:04:17
Message-ID: 219F68D65015D011A8E000006F8590C60267B374@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.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-05-25 15:05:36 Re: [HACKERS] createlang - ?
Previous Message Tom Lane 1999-05-25 14:42:39 INSERT INTO view means what exactly?