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

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" >>&

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

solation_level for psycopg, and if so to what? Is there any Postgres configuration parameter that I should set? Should the user close the database connection after every fetchall? Thank you for any help you can give. Janet Marcin Stępnicki wrote > On Fri, Jun 26, 2009 at 9:34 AM, Janet Jaco

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

On 25/06/2009 08:17 p.m., Greg Stark wrote: On Fri, Jun 26, 2009 at 3:33 AM, Janet Jacobsen wrote: (1) is my interpretation of the posts correct, i.e., if I am deleting rows from table1, where the pkey of table 1 is a fkey in table 2, then do I need to create an index on the fkey field in table 2?

[PERFORM] slow DELETE on 12 M row table

Hi. We are running Postgres 8.3.7 on an eight-processor Linux system. Because the machine has very little local disk, the database files are on a file system running GPFS. The machine is mostly dedicated to processing images. After the images are processed, the image attributes and processing pa

[PERFORM] performance using table partitions in Postgres 8.2.6

using partitions? Do these results point to some obvious implementation error? Thank you for any help/suggestions you can give. Janet Jacobsen -- Janet Jacobsen NERSC Analytics/HPCRD Visualization Group Lawrence Berkeley National Laboratory -- Sent via pgsql-performance mailing list (pgsql-