Re: Query times change by orders of magnitude as DB ages

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: Grzegorz Ja*kiewicz <gryzman(at)gmail(dot)com>
Cc: "Richard Neill" <rn214(at)cam(dot)ac(dot)uk>, "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query times change by orders of magnitude as DB ages
Date: 2009-11-25 16:58:20
Message-ID: 4B0D0DCC020000250002CCCE@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Grzegorz Jaœkiewicz<gryzman(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-11-25 17:05:04 Re: Query times change by orders of magnitude as DB ages
Previous Message Steve Crawford 2009-11-25 16:45:46 Re: RAID card recommendation