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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org