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

Re: correct behavior of ANALYZE ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: correct behavior of ANALYZE ...
Date: 2007-08-29 16:44:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hans-Juergen Schoenig <postgres(at)cybertec(dot)at> writes:
> i came across some interesting behavior of pg_stats and i am not sure
> if this is something we should treat the way we do it.

Setting target zero means "expend no work on this column".  In my book
that includes not doing anything to any pre-existing pg_stats entry.
What you propose would defeat the ability to analyze an unchanging
column once and then make ANALYZE skip over it henceforth.

			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Josh BerkusDate: 2007-08-29 17:09:07
Subject: Re: [HACKERS] Contrib modules documentation online
Previous:From: Hans-Juergen SchoenigDate: 2007-08-29 16:07:48
Subject: correct behavior of ANALYZE ...

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