Re: Query times change by orders of magnitude as DB ages - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Query times change by orders of magnitude as DB ages
Date
Msg-id 4B0D0647020000250002CCC7@gw.wicourts.gov
Whole thread Raw
In response to Re: Query times change by orders of magnitude as DB ages  (Richard Neill <rn214@cam.ac.uk>)
Responses Re: Query times change by orders of magnitude as DB ages  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
Richard Neill <rn214@cam.ac.uk> 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.)

-Kevin

pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: DELETE performance problem
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Query times change by orders of magnitude as DB ages