| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Mark Dilger <markdilger(at)yahoo(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-24 10:58:18 |
| Message-ID: | CABUevEx8p6BRgjBy-SwdYH5Q-cnow5Hh6KEh-AFg97_sRhrJyA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, May 24, 2012 at 12:47 AM, Mark Dilger <markdilger(at)yahoo(dot)com> wrote:
> I am running this code on Windows 2003. It
> appears that postgres has in src/port/dirent.c
> a port of readdir() that internally uses the
> WIN32_FIND_DATA structure, and the function
> FindNextFile() to iterate through the directory.
> Looking at the documentation, it seems that
> this function does collect file creation time,
> last access time, last write time, file size, etc.,
> much like performing a stat.
>
> In my case, the code is iterating through roughly
> 56,000 files. Apparently, this is doing the
> equivalent of a stat on each of them.
how did you end up with 56,000 files? Lots and lots and lots of tables?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2012-05-24 11:00:39 | Re: FATAL: lock file "postmaster.pid" already exists |
| Previous Message | Karthik | 2012-05-24 10:07:28 | Is there a way to start postgresql v907 as non daemon process |