| From: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can you spot the difference? |
| Date: | 2013-04-16 20:55:49 |
| Message-ID: | CAJ4CxLn30e3GBR4T57fT=KPMr3odLUHML_CgV_ngObhc0z8i1w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 16, 2013 at 3:29 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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(at)neadwerx(dot)com | www.neadwerx.com
"Quality is not an act, it is a habit." -- Aristotle
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2013-04-16 21:01:37 | Re: Mysterious table that exists but doesn't exist |
| Previous Message | Ramsey Gurley | 2013-04-16 20:54:18 | Re: JDBC driver versions |