Re: RFC: planner statistics in 7.2y

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RFC: planner statistics in 7.2y
Date: 2001-04-19 23:03:06
Message-ID: 200104192303.f3JN36B23599@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> (1) The statistics-gathering process should be available as a standalone
> command, ANALYZE [ tablename ], not only as part of VACUUM. (This was
> already discussed and agreed to for 7.1, but it never got done.) Note
> that a pure ANALYZE command needs only a read lock on the target table,
> not an exclusive lock as VACUUM needs, so it's much more friendly to
> concurrent transactions.

7.1 already does the ANALYZE part of VACUUM ANALYZE with lighter
locking. I just never split out the command to be separate, partly
because of fear of user confusion, and I ran out of time.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-04-19 23:10:27 Re: RFC: planner statistics in 7.2y
Previous Message Tom Lane 2001-04-19 22:37:45 RFC: planner statistics in 7.2