On Wed, Dec 08, 2004 at 10:42:19AM +0800, Christopher Kings-Lynne wrote: > 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!
Do you have a foreign key or other check which could be really slow? /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]