Re: 2 machines, same database, same query, 10 times slower? - Mailing list pgsql-general

On 9.5.2012 22:50, Antonio Goméz Soto wrote:
> Tomas,
>
> running vacuum full cdr brought down the query time to 4 seconds..

Fine. I'd recommend checking the other tables too - if this one was
bloated, it's likely there might be others.

Anyway, you should find out how this happened and fix it. This kind of
bloat is usually caused by either frequent changes (updated / deletes)
without sufficient vacuuming, or batch updates hitting many rows at once
(e.g. during maintenance).

Or maybe the vacuum was not running at all - I do remember there were
frequent issues with free-space map. See this:

  http://www.varlena.com/GeneralBits/Tidbits/perf.html#maxfsmp
  http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

That should give you a good idea.

Tomas