Re: Double entries in log for page slots in beta3

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Double entries in log for page slots in beta3
Дата
Msg-id 8F7BD696-23EB-4B63-BF71-A47BD99A27B3@decibel.org
обсуждение исходный текст
Ответ на Re: Double entries in log for page slots in beta3  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Ответы Re: Double entries in log for page slots in beta3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Nov 28, 2006, at 1:37 PM, Ron Mayer wrote:
> If there's a way of getting the info without doing the vacuum,
> (i.e. was a pg_* view created that lets me see it?) I'll be even
> happier to withdraw that request.

AFAIK there isn't, and it would be useful to have. But FSM info alone  
doesn't tell you the whole picture; you'd have to know that vacuum  
couldn't find space in the FSM to store some pages. So perhaps what's  
really needed is information about how many pages in a relation  
couldn't be put into the FSM the last time a vacuum was run.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: old synchronized scan patch
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: FOR SHARE vs FOR UPDATE locks