| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
| Cc: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DB files, sizes and cleanup |
| Date: | 2010-12-17 22:43:21 |
| Message-ID: | 16586.1292625801@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> writes:
> ls -1 | wc took a while for the other bad one but eventually came up
> with exactly 7,949,911 files, so yes, millions. The other one had
> millions too before I dropped it. Something is clearly wrong.
No doubt, but it's impossible to tell what from just the bare statement
that you had a lot of unexpected files.
Did you happen to notice the timestamps on those files --- eg, were
there recent ones, or were they all old? Do you use a lot of temporary
tables? Have you had a lot of crashes in this database?
>> This is PG v 8.3.4 on linux.
It wouldn't be a bad idea to update to 8.3.something-recent.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raimon Fernandez | 2010-12-17 22:49:09 | Getting number of affected rows after DELETE FROM |
| Previous Message | Gauthier, Dave | 2010-12-17 22:22:24 | Re: DB files, sizes and cleanup |