| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | josh(at)agliodbs(dot)com |
| Cc: | pgsql-performance(at)postgresql(dot)org, Abu Mushayeed <abumushayeed(at)yahoo(dot)com> |
| Subject: | Re: Performance Query |
| Date: | 2007-03-03 02:12:03 |
| Message-ID: | 23598.1172887923@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> Please help in understanding how I can find out what the system is
>> waiting for or why is it taking the query so long.
> First guess would be I/O bound. The planner, at least, thinks you're
> inserting 2 million records. What kind of disk support do you have?
I don't see any need to guess. iostat or vmstat or local equivalent
will show you quick enough if you are maxing out the disk or the CPU.
It seems at least somewhat possible that the thing is blocked on a lock,
in which case the pg_locks view would tell you about it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Bjorklund | 2007-03-03 06:41:51 | Re: Upgraded to 8.2.3 --- still having performance issues |
| Previous Message | Josh Berkus | 2007-03-03 00:52:22 | Re: Performance Query |