On Tue, Apr 16, 2013 at 3:29 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
I did not -- I expected the autovacuum daemon to do so. Why did it not?
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
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com
moshe@xxxxxxxxxxxx | www.neadwerx.com
"Quality is not an act, it is a habit." -- Aristotle
