Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Fast Deletion For Large Tables - Mailing list pgsql-admin

From Roland Roberts
Subject Re: [GENERAL] Fast Deletion For Large Tables
Date
Msg-id m21y76qf8c.fsf@kuiper.rlent.pnet
Whole thread Raw
In response to Fast Deletion For Large Tables  (Raymond Chui <raymond.chui@noaa.gov>)
List pgsql-admin
Tree view 
>>>>> "rc" == Raymond Chui <raymond.chui@noaa.gov> writes:

    rc> Everything is running fine, except take long time to finish.
    rc> Because some tables stored values from 50,000 to 100,000 rows
    rc> Some deletion need to deleted up to 45,000 rows.

Is column_time indexed?

roland
--
               PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
roland@astrofoto.org                       Forest Hills, NY 11375

pgsql-admin by date:

Previous
From:
Date:
Subject: Re: Relation between DROP TABLE and DROP INDEX
Next
From: Chris Miles
Date:
Subject: PostgreSQL and 2-node failover cluster solutions