"It may well be that you haven't run into the LIKE + indexes issue or didn't notice it because the table didn't have a lot of data in it."
I dunno, the backups (pgdump -> bzip), last time I looked at one, were over 6GB, so I'd say there's some data in there. I've just never seen Unicode-related issues.
"By the way, do you realise that Django's ORM does not support optimistic locking in a transactionally safe way?"
It doesn't really expose locking, period; consult the many threads on the dev list to find out why.
I dunno, the backups (pgdump -> bzip), last time I looked at one, were over 6GB, so I'd say there's some data in there. I've just never seen Unicode-related issues.
"By the way, do you realise that Django's ORM does not support optimistic locking in a transactionally safe way?"
It doesn't really expose locking, period; consult the many threads on the dev list to find out why.