Re: Statistics use with functions

From: Tom Lane
Subject: Re: Statistics use with functions
Date: ,
Msg-id: 8956.1241799404@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: Statistics use with functions  (Matthew Wakeling)
List: pgsql-performance

Tree view

Statistics use with functions  (Matthew Wakeling, )
 Re: Statistics use with functions  (Tom Lane, )
  Re: Statistics use with functions  (Matthew Wakeling, )
   Re: Statistics use with functions  (Tom Lane, )

Matthew Wakeling <> writes:
> Ah, now I see it - I re-analysed, and found entries in pg_stats where
> tablename is the name of the index. Now the query plans correctly and has
> the right estimates. So, one needs to analyse AFTER creating indexes -
> didn't know that.

Yes, for functional indexes it's helpful to do that.  Doesn't matter
for plain-old-plain-old indexes.

            regards, tom lane


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: Transparent table partitioning in future version of PG?
From: Paolo Rizzi
Date:
Subject: Re: PostgreSQL with PostGIS on embedded hardware