Database Design Advice

Matt Lawrence matt.lawrence at
Mon Nov 18 13:04:14 GMT 2013

On 18/11/13 11:18, Philip Skinner wrote:
> Auto-increment a double column primary key, something like:
> uid int(11) not null auto_increment, revision int(11) not null 
> auto_increment, primary key(uid, revision)
> ; works in mysql. You won't have your concurrent query issues there, 
> for the most part anyway. Maybe marking a records as tainted.

As far as I know that only works with MyISAM in mysql. It certainly 
doesn't work like that in Postgres.


More information about the mailing list