Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group