Hi, we ran a large database on moderate hardware. Disks are usually the slowest part so we do not log every statement. Sometimes we do and our IOwait and CPU increases by 10%. too much for peak times!
it would be nice if you could say: log_statement = sample sample_rate = 100 you would get a good sample to analyze your database usage. Of course log_min_duration helps a lot as you see your slowest queries. But with a tool like hibernate, you have often have the problem issuing many many small statements like "SELECT * from table where id = ?". They don't show up in the log with a reasonable log_min_duration setting. With my proposal every 100th query is logged and you get a detailed view of your database usage without excessive disk IO. Of course it should be combinable with log_min_duration. What do you think about it? kind regards Janning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
