Re: Query times change by orders of magnitude as DB ages
| От | Grzegorz Jaśkiewicz |
|---|---|
| Тема | Re: Query times change by orders of magnitude as DB ages |
| Дата | |
| Msg-id | 2f4958ff0911250833s22b92dcah9cf3ccac0421b4bc@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Query times change by orders of magnitude as DB ages ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Ответы |
Re: Query times change by orders of magnitude as DB
ages
|
| Список | pgsql-performance |
On Wed, Nov 25, 2009 at 4:26 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
> In terms of just index bloat, does a regular vacuum help?You might want to use the REINDEX command to correct serious index
bloat. A regular vacuum will make dead space available for re-use,
but won't eliminate bloat directly. (If run regularly, it will
prevent bloat.)
for that reason, it makes sense to actually partition your data - even tho you don't see performance degradation because of data size, but purely because of nature of data.
Other way, is to perform regular cluster && reindex - but this blocks relations you are clustering..
Other way, is to perform regular cluster && reindex - but this blocks relations you are clustering..
--
GJ
В списке pgsql-performance по дате отправления: