Re: RFC: planner statistics in 7.2y
От | Bruce Momjian |
---|---|
Тема | Re: RFC: planner statistics in 7.2y |
Дата | |
Msg-id | 200104192303.f3JN36B23599@candle.pha.pa.us обсуждение исходный текст |
Ответ на | RFC: planner statistics in 7.2 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: RFC: planner statistics in 7.2y
|
Список | 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@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: