Re: index question - Mailing list pgsql-general

From drum.lucas@gmail.com
Subject Re: index question
Date
Msg-id CAE_gQfVqkhjZjG=Txc3qmTo5cdH7f4ASVGvrvGbS0hYYK3vsiw@mail.gmail.com
Whole thread Raw
In response to Re: index question  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: index question  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general


​Index size and index usage are unrelated.  Modifications to the index to keep it in sync with the table do not count as "usage" - only reading it for where clause use counts.​

​David J.



So only those with 0 size, should be deleted? Is that you're saying?
Can you be more clear please?

Lucas

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: index question
Next
From: "David G. Johnston"
Date:
Subject: Re: index question