Re: [GENERAL] Confused on a some deadlocks occuring...

2006-08-29 Thread Erik Jones
Erik Jones wrote: Ok, consider the following table definition: CREATE TABLE stats ( id SERIAL PRIMARY KEY, hits bigint default 0, clickthrus bigint default 0, referrals bigint default 0); Now, this table has a lot of rows that are constantly being updated by queries of the following form: U

[GENERAL] Confused on a some deadlocks occuring...

2006-08-29 Thread Erik Jones
Ok, consider the following table definition: CREATE TABLE stats ( id SERIAL PRIMARY KEY, hits bigint default 0, clickthrus bigint default 0, referrals bigint default 0); Now, this table has a lot of rows that are constantly being updated by queries of the following form: UPDATE stats SET cli