Postgres Pro
Downloads
Home   >   mailing lists

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 4B0D0DCC020000250002CCCE@gw.wicourts.gov
Whole thread Raw
In response to Re: Query times change by orders of magnitude as DB ages  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: Query times change by orders of magnitude as DB ages  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
Tree view 
Grzegorz Jaœkiewicz<gryzman@gmail.com> wrote:

> Other way, is to perform regular cluster && reindex

If you CLUSTER there is no reason to REINDEX; indexes are rebuilt by
the CLUSTER command.

Also, if you do a good job with regular VACUUMs, there isn't any bloat
to fix.  In that case a regular CLUSTER would only be needed if it was
worth the cost to keep data physically organized in the index
sequence.

-Kevin

pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: RAID card recommendation
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Query times change by orders of magnitude as DB ages