From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Index |
Date: | 2024-03-10 18:29:22 |
Message-ID: | CANzqJaC2hVQhd60OzEDM8n+yfnK-G=J32DyE0odis6YYwakUaw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Tune your autovacuum settings.
On Sun, Mar 10, 2024 at 2:21 PM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:
> If we are deleting rows often.....I am talking ABT the possibility of
> index bloat.
>
> On Sun, 10 Mar 2024, 23:40 Ron Johnson, <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>> What does "if index is not managed" mean?
>>
>> On Sun, Mar 10, 2024 at 9:11 AM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
>> wrote:
>>
>>> What will happen if index is not managed in this case?
>>>
>>> On Sun, 10 Mar 2024, 17:20 Holger Jakobs, <holger(at)jakobs(dot)com> wrote:
>>>
>>>> Am 10.03.24 um 12:19 schrieb Rajesh Kumar:
>>>> > Hi ,
>>>> >
>>>> > I have a table where size is increasing daily. In that table only
>>>> > inserts and deletes happens. This table is referencing 15 other
>>>> > tables. We have given delete cascade, so if a row is deleted in
>>>> parent
>>>> > table, the matching records will also be deleted in those child
>>>> tables.
>>>> >
>>>> > It is taking lot of time to delete. So, I am planning to create index
>>>> > on those child tables.
>>>> >
>>>> > My question is, apart from inserts, I am only going to delete records
>>>> > from those tables. How index improves performance for deleting
>>>> > records? How index is affected or how to do index management in this
>>>> case?
>>>>
>>>> Hi,
>>>>
>>>> Since every single row which is going to be deleted in the child tables
>>>> has to be found, an index can be of great help here.
>>>>
>>>> Actually, in most (not all!) cases an index on foreign key columns
>>>> makes
>>>> sense.
>>>>
>>>> Regards,
>>>>
>>>> Holger
>>>>
>>>> --
>>>> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>>>>
>>>>
From | Date | Subject | |
---|---|---|---|
Next Message | Holger Jakobs | 2024-03-10 18:32:08 | Re: Index |
Previous Message | Rajesh Kumar | 2024-03-10 18:21:26 | Re: Index |