Re: [PERFORM] slow DELETE on 12 M row table

2009-06-27 Thread Robert Haas
2009/6/27 Scott Carey : > In addition to the above, note that long lived transactions cause all sorts > of other problems in the database.  In particular, table and index bloat can > become severe due to this sort of poor client behavior if there is a lot of > update or delete activity.  You can fi

Re: [PERFORM] slow DELETE on 12 M row table

2009-06-27 Thread Scott Carey
On 6/26/09 6:36 PM, "Robert Haas" wrote: > 2009/6/26 Janet Jacobsen : >> Hi.  The user in question is using psycopg2, which he uses >> psycopg2: >>> import psycopg2 >>> conn = psycopg2.connect("dbname=%s  user=%s host=%s password=%s port=%s" >>> ...) >>> pg_cursor = conn.cursor() >>> pg_cursor