Raymond,
Partitioned tables would solve your issue since you
could just truncate a partiotion in order to delete the
unneeded data. Unfortunately they are not available in
PostgreSQL. But maybe in a future release.
Unfortunately you also cannot use a UNION ALL in a view
to fake partitions.
So
Hi,
I get occasional deadlocks when using sequences from
multiple clients.
Here's the table DDL:
create sequence ids;
create table foo( id integer default nextval('ids'),
parent integer, type char(4), name text, value text )
without oids;
create index xml_id on xml(id);
I'm inserting 1000s of
