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

Re: Bug? 8.0 does not use partial index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: John Hansen <john(at)geeknet(dot)com(dot)au>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Bug? 8.0 does not use partial index
Date: 2005-01-14 00:44:57
Message-ID: 18183.1105663497@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Palle Girgensohn <girgen(at)pingpong(dot)net> writes:
> Trying all this out, I realize that on 7.4.5, I can sometimes get different 
> results after `vacuum analyze' vs. a plain `analyze' (again, not exactly 
> the same data, and I cannot reproduce this on the other machine with the 
> data I sent you). It does not really relate to the question above, but 
> perhaps you can explain how come I get different results?

No surprise.  vacuum analyze produces an exact total row count, whereas
analyze can only produce an approximate total row count (since it only
samples the table rather than groveling over every row).  Sometimes the
approximate count will be far enough off to affect the estimates.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Palle GirgensohnDate: 2005-01-14 00:52:04
Subject: Re: Bug? 8.0 does not use partial index
Previous:From: Greg StarkDate: 2005-01-14 00:44:44
Subject: Re: [HACKERS] Much Ado About COUNT(*)

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