Postgres Pro
Downloads
Home   >   mailing lists

Re: Can you spot the difference? - Mailing list pgsql-general

From Moshe Jacobson
Subject Re: Can you spot the difference?
Date
Msg-id CAJ4CxLn30e3GBR4T57fT=KPMr3odLUHML_CgV_ngObhc0z8i1w@mail.gmail.com
Whole thread Raw
In response to Re: Can you spot the difference?  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Can you spot the difference?
List pgsql-general
Tree view
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 by date:

Previous
From: Ramsey Gurley
Date:
Subject: Re: JDBC driver versions
Next
From: John R Pierce
Date:
Subject: Re: Mysterious table that exists but doesn't exist