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?



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to