| From: | Roland Roberts <roland(at)astrofoto(dot)org> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Fast Deletion For Large Tables |
| Date: | 2002-10-04 17:35:31 |
| Message-ID: | m21y76qf8c.fsf@kuiper.rlent.pnet |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin pgsql-general |
>>>>> "rc" == Raymond Chui <raymond(dot)chui(at)noaa(dot)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(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lars hofhansl | 2002-10-05 00:53:17 | deadlock using sequences? |
| Previous Message | Roland Roberts | 2002-10-04 16:24:09 | Re: [GENERAL] Fast Deletion For Large Tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Miles | 2002-10-04 18:05:28 | PostgreSQL and 2-node failover cluster solutions |
| Previous Message | mallah | 2002-10-04 16:43:05 | Re: Relation between DROP TABLE and DROP INDEX |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-04 17:36:36 | Re: Odd sum() problem in 7.2.2 |
| Previous Message | Bruce Momjian | 2002-10-04 17:30:21 | Re: transactions |