| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Slow insert |
| Date: | 2004-12-08 02:42:19 |
| Message-ID: | 41B66A0B.1090003@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi guys,
Why would an INSERT ever be really slow? This is what I see a lot of in
our site logs:
Dec 5 15:57:48 marshall postgres[19599]: [3-1] LOG: duration:
13265.492 ms statement: INSERT INTO users_sessions (sid, cobrand_id,
uid) VALUES ('145982ac39e1d09fec99cc8a606155e7', '1', '0')
13 seconds to insert a single row!
It seems to happen at random times during the day. That sessions table
is heavily updated and inserted, and has pg_autovacuum running vacuum
analyze and analyze on it every few minutes I think.
We don't run any exclusive lock stuff on it.
So what lock or concurrency issue could cause a single-row insert to
take 13 seconds? Could vacuum analyze be doing it?
Thanks,
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stacy White | 2004-12-08 04:32:49 | Re: Partitioned table performance |
| Previous Message | Joshua D. Drake | 2004-12-07 18:35:03 | Re: Fwd: 8.0 vs. 7.4 benchmarks |