Bruce Momjian wrote:
>
>
> Here is what you can do:
>
> SELECT filename,
> (SELECT file_len FROM pg_file_stat(filename)),
> (SELECT file_ctime FROM pg_file_stat(filename)),
> (SELECT file_mtime FROM pg_file_stat(filename)),
> (SELECT file_atime FROM pg_file_stat(filename))
> FROM pg_dir_ls('/etc') AS d (filename text...)
> WHERE filename like 's%'
Not really satisfying (pg_file_stat is volatile) but subselects give the
desired result.
>
> Are we done? Seems pg_file_stat() works fine. Do we need other
> adjustments?
The only single spot where performance could be improved is in
pg_file_stat, where attinmeta is created again and again; this may be
cached in a static memory context instead.
