From: "bricklen" <bricklen@gmail.com>
To: "Ray Cote" <rgacote@appropriatesolutions.com>
Cc: pgsql-general@postgresql.org
Sent: Thursday, June 6, 2013 3:44:04 PM
Subject: Re: [GENERAL] Database performs massive reads when I'm doing writes.
Yes Autovacuum is set to 'on'.
I'll run a Vacuum Analyze Verbose after the data load finally completes (which could easily be another two hours).
Don't want to touch the system until this data finally gets loaded.
Thanks for the recommendation.
--Ray
--
Ray Cote, President Appropriate Solutions, Inc.
We Build Software
www.AppropriateSolutions.com 603.924.6079