Re: Really slow even after vacuum

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Jeroen Baekelandt <jbaekelandt(at)kiala(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Really slow even after vacuum
Date: 2004-01-21 10:42:01
Message-ID: Pine.LNX.4.44.0401211141230.17713-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 21 Jan 2004, Jeroen Baekelandt wrote:

> jms_messages again. It takes 80 seconds!?! While before, with 1000
> records, it took only a fraction of a second.

run: VACUUM FULL ANALYZE;

--
/Dennis Björklund

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Harald Fuchs 2004-01-21 13:50:26 Re: Trigger question
Previous Message Thierry Missimilly 2004-01-21 09:59:46 Re: PostgreSQL vs. Oracle disk space usage