On Thu, May 24, 2012 at 12:47 AM, Mark Dilger <markdil...@yahoo.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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
