| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> |
| Cc: | "Sven Geisler" <sgeisler(at)aeccom(dot)com>, "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL and Xeon MP |
| Date: | 2006-03-16 16:34:58 |
| Message-ID: | 17483.1142526898@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com> writes:
> You mean strace -p pid with pid on some of the postgres process not on
> the postmaster itself, does you?
Right, pick a couple that are accumulating CPU time.
> Do we need other options?
strace will generate a *whole lot* of output to stderr. I usually do
something like
strace -p pid 2>outfile
and then control-C it after a few seconds.
> Which pattern should we expect?
What we want to find out is if there's a lot of select()s and/or
semop()s shown in the result. Ideally there wouldn't be any, but
I fear that's not what you'll find.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sven Geisler | 2006-03-16 16:36:52 | Re: PostgreSQL and Xeon MP |
| Previous Message | Guillaume Smet | 2006-03-16 16:08:46 | Re: PostgreSQL and Xeon MP |