Re: slow database

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: alemon(at)tiago(dot)hazor(dot)com(dot)br
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow database
Date: 2004-02-11 14:27:09
Message-ID: Pine.LNX.4.44.0402111525070.30205-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 11 Feb 2004 alemon(at)tiago(dot)hazor(dot)com(dot)br wrote:

> somebody please knows to give tips to me to increase the
> performance

Run VACUUM ANALYZE. Find one query that is slow. Run EXPLAIN ANALYZE on
that query. Read the plan and figure out why it is slow. Fix it.

--
/Dennis Björklund

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PC Drew 2004-02-11 14:28:15 Re: slow database
Previous Message alemon 2004-02-11 14:23:31 slow database