(2014/01/29 15:51), Tom Lane wrote: > KONDO Mitsumasa <[email protected]> writes: >> By the way, latest pg_stat_statement might affect performance in Windows >> system. >> Because it uses fflush() system call every creating new entry in >> pg_stat_statements, and it calls many fread() to warm file cache. > This statement doesn't seem to have much to do with the patch as > committed. There are no fflush calls, and no notion of warming the > file cache either. Oh, all right.
> We do assume that the OS is smart enough to keep > a frequently-read file in cache ... is Windows too stupid for that? I don't know about it. But I think Windows cache feature is stupid. It seems to always write/read data to/from disk, nevertheless having large memory... I'd like to know test result on Windows, if we can... Regards, -- Mitsumasa KONDO NTT Open Source Software Center -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
