Re: slow database - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: slow database
Date
Msg-id Pine.LNX.4.44.0402111525070.30205-100000@zigo.dhs.org
Whole thread Raw
In response to slow database  (alemon@tiago.hazor.com.br)
List pgsql-performance
On Wed, 11 Feb 2004 alemon@tiago.hazor.com.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


pgsql-performance by date:

Previous
From: alemon@tiago.hazor.com.br
Date:
Subject: slow database
Next
From: PC Drew
Date:
Subject: Re: slow database