Re: Can you spot the difference?

Поиск
Список
Период
Сортировка
От Moshe Jacobson
Тема Re: Can you spot the difference?
Дата
Msg-id CAJ4CxLn30e3GBR4T57fT=KPMr3odLUHML_CgV_ngObhc0z8i1w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can you spot the difference?  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Can you spot the difference?  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
On Tue, Apr 16, 2013 at 3:29 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
Given that the copy is causing the 'problem', the question to ask is; did you run ANALYZE on the table once the data was copied in?

I did not -- I expected the autovacuum daemon to do so. Why did it not?
The database was created & restored days ago, and the autovacuum daemon is running with default settings.

Thanks.

-- 
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | 
www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

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

Предыдущее
От: Ramsey Gurley
Дата:
Сообщение: Re: JDBC driver versions
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Mysterious table that exists but doesn't exist