> What could you recommend? Locking the table and selecting > max(invoice_id) wouldn't really be much faster, with max(invoice_id) > not using an index...
select invoice_id from table order by invoice_id desc limit 1; should get you the maximum fast if you have a unique index on invoice_id. Andreas ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
