Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How often do I need to reindex tables?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
- Cc: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>, "Jim C. Nasby" <jim(at)nasby(dot)net>, "Dhaval Shah" <dhaval(dot)shah(dot)m(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
- Subject: Re: How often do I need to reindex tables?
- Date: Wed, 28 Feb 2007 12:22:58 -0500
Bill Moran <wmoran(at)collaborativefusion(dot)com> writes: > I don't agree. I think that regular indexing is mandatory under some > workloads. Example: > ... > There are some additional indexes that I've snipped from the output that also > saw some benefit from reindexing, but let's just focus on file_fp_idx. Can you describe the usage pattern of that index? I'm curious why it doesn't maintain reasonably static size. How often is the underlying table vacuumed? regards, tom lane
- Follow-Ups:
- Re: How often do I need to reindex tables?
- From: Bill Moran
- Re: How often do I need to reindex tables?
- References:
- How often do I need to reindex tables?
- From: Dhaval Shah
- Re: How often do I need to reindex tables?
- From: Jim C. Nasby
- Re: How often do I need to reindex tables?
- From: Ezequias Rodrigues da Rocha
- Re: How often do I need to reindex tables?
- From: Bill Moran
- How often do I need to reindex tables?
- Prev by Date: Re: How often do I need to reindex tables?
- Next by Date: Re: Difference between UNIQUE constraint vs index
- Previous by thread: About PostgreSQL Block Size
- Next by thread: Re: How often do I need to reindex tables?
- Indexes: