Skip site navigation (1) Skip section navigation (2)

Re: Statistics use with functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Statistics use with functions
Date: 2009-05-08 16:16:44
Message-ID: 8956.1241799404@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Matthew Wakeling <matthew(at)flymine(dot)org> 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

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2009-05-08 16:47:42
Subject: Re: Transparent table partitioning in future version of PG?
Previous:From: Matthew WakelingDate: 2009-05-08 16:11:50
Subject: Re: Statistics use with functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group