Re: [GENERAL] empty table explain...

2008-10-27 Thread Tom Lane
Luca Ferrari <[EMAIL PROTECTED]> writes: > I'm curious to know why, if a table is empty, it seems that an ANALYZE > of the table does not insert any stats in the pg_stats table, Uh ... because there are no stats to insert. The only available information is that the table is empty, which is someth

Re: [GENERAL] empty table explain...

2008-10-27 Thread Sam Mason
On Mon, Oct 27, 2008 at 05:43:08PM +0100, Luca Ferrari wrote: > I'm curious to know why, if a table is empty, it seems that an > ANALYZE of the table does not insert any stats in the pg_stats table, > since maybe this could be useful to solve joins including this table. I think it's tryi