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: 5730.1188405879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

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