| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mark Dilger <markdilger(at)yahoo(dot)com> |
| Cc: | deepak <deepak(dot)pn(at)gmail(dot)com>, Alban Hertroys <haramrae(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FATAL: lock file "postmaster.pid" already exists |
| Date: | 2012-05-23 20:54:43 |
| Message-ID: | 11891.1337806483@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mark Dilger <markdilger(at)yahoo(dot)com> writes:
> We only use one database, not counting the
> built-in template databases. The server is
> running 9.1.3. We were running 9.1.1 until
> fairly recently.
OK. I had forgotten that in recent versions, RemovePgTempFiles doesn't
only iterate through the pgsql_tmp directories; it scans the regular
database directories too, looking for possibly orphaned temp relations.
So if you had lots and lots of files in your regular database
directories, possibly scanning those could be slow. Still, it's only
looking at the file names, not attempting to stat() them or anything,
so it would be a pretty shoddy filesystem that would take a really long
time for that.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lists | 2012-05-23 21:37:38 | Extreme PostgreSQL? |
| Previous Message | Igor | 2012-05-23 20:22:40 | Re: One schema per different databases |