| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Atul Kumar <akumar14871(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: time taking deletion on large tables |
| Date: | 2020-12-03 14:51:26 |
| Message-ID: | 20201203145126.GA4726@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-docs pgsql-in-general pgsql-performance |
On Thu, Dec 03, 2020 at 08:15:06PM +0530, Atul Kumar wrote:
> Hi,
>
> The feed_posts table has over 50 Million rows.
>
> When I m deleting all rows of a certain type that are over 60 days old.
The common solution to this problem is to partition, and then, instead
of deleting rows - delete old partitions.
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravikumar Reddy | 2020-12-03 15:13:57 | Re: time taking deletion on large tables |
| Previous Message | Atul Kumar | 2020-12-03 14:49:19 | time taking deletion on large tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravikumar Reddy | 2020-12-03 15:13:57 | Re: time taking deletion on large tables |
| Previous Message | Atul Kumar | 2020-12-03 14:49:19 | time taking deletion on large tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravikumar Reddy | 2020-12-03 15:13:57 | Re: time taking deletion on large tables |
| Previous Message | Atul Kumar | 2020-12-03 14:49:19 | time taking deletion on large tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravikumar Reddy | 2020-12-03 15:13:57 | Re: time taking deletion on large tables |
| Previous Message | Atul Kumar | 2020-12-03 14:49:19 | time taking deletion on large tables |