Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer
Date
Msg-id 36F14C60.A80D697F@krs.ru
Whole thread Raw
In response to Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:
> 
> So, yes, I suppose there is an inconsistency there.  Zero-sized
> tables(according to vacuum), use index, while tables with some data
> don't use index.
> 
> How does the system know there is a row in there if you didn't run
> vacuum?  That confuses me.

Create index updates ntuples & npages in pg_class...

Vadim


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Re: [BUGS] General Bug Report: Bug in optimizer