Scott Marlowe wrote:
The serial based approach sounds a fair bit better.
Er, I meant "sequence".
Add prepared select statements and you'd get get pretty fast
performance.
Yep, and if DB round trips are a problem it can always be wrapped up in
a stored procedure. I'd be tempted to do that anyway just to simplify
the client's job, guarantee query plan caching, etc.
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general