On 08/11/10 6:32 PM, David Fetter wrote:
does anyone have any suggestions for what to look for, or what sort
of common partition management mistakes in the application could
lead to this sort of deadlock?
DDL is a "don't do it at peak load" event.  More realistically, it's
more like a "down time" event.  Maybe when we have "real"
partitioning...

Thats an *ouch* for this application, as the load is a 24/7 thing... the database has to handle a steady stream of events and requests at a fairly high rate coming from a factory operation, and we need to prune weekly partitions while all the rest is going on.

The developers (and operations) are coming from an Oracle Enterprise environment, where this all just works. I've been pushing for years to give postgres a try, this is the first substantial database deployment.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to