Re: sort_mem statistics ...
От | Simon Riggs |
---|---|
Тема | Re: sort_mem statistics ... |
Дата | |
Msg-id | 1130192672.8300.1102.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: sort_mem statistics ... (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Tue, 2005-10-18 at 18:57 -0400, Tom Lane wrote: > "Marc G. Fournier" <scrappy@postgresql.org> writes: > > On Tue, 18 Oct 2005, Tom Lane wrote: > >> Looking at the code, I notice that the messages are all emitted at level > >> NOTICE. Perhaps that was not such a good idea --- it'd be pretty much > >> in-your-face if it were on all the time. Does anyone think it'd be a > >> good idea to emit the trace_sort messages at level LOG, instead? > > > If someone sets trace_sort, does it matter what level its emit'd at? > > Well, yeah. It depends whether you are thinking of the trace feature as > being used interactively, or as something turned on to gather data over > time in a production installation. In the second case you'd want the > info to go to the postmaster log, but not want to see it dumped on your > terminal all the time ... Yes, please set this at LOG. It will certainly provide many more data points for us to analyse. Best Regards, Simon Riggs
В списке pgsql-hackers по дате отправления: