From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: sort_mem statistics ... |
Date: | 2005-10-25 01:09:03 |
Message-ID: | 200510250109.j9P193h27830@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> "Marc G. Fournier" <scrappy(at)postgresql(dot)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 ...
I think it should go to the logs, hence LOG. Right now it just scrolls
off my screen:
test=> select * from pg_class order by relname;
NOTICE: begin tuple sort: nkeys = 1, workMem = 1024, randomAccess = t
NOTICE: performsort starting: CPU 0.00s/0.00u sec elapsed 0.00 sec
NOTICE: performsort done: CPU 0.00s/0.00u sec elapsed 0.00 sec
NOTICE: sort ended: CPU 0.00s/0.00u sec elapsed 0.00 sec
relname | relnamespace | reltype | relowner |
relam | relfilenode | reltablespace | relpages | reltup
les | reltoastrelid | reltoastidxid | relhasindex | relisshared |
relkind | relnatts | relchecks | reltriggers | relukeys | relf
...
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2005-10-25 01:45:30 | Re: [GENERAL] 'a' == 'a ' |
Previous Message | Bruce Momjian | 2005-10-25 00:57:17 | Re: [GENERAL] 'a' == 'a ' |