Re: Need for speed - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: Need for speed
Date
Msg-id Pine.LNX.4.44.0508162045480.2995-100000@zigo.dhs.org
Whole thread Raw
In response to Need for speed  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
Responses Re: Need for speed
List pgsql-performance
On Tue, 16 Aug 2005, Ulrich Wisser wrote:

> Still when several users are on line the reporting gets very slow.
> Queries can take more then 2 min.

Could you show an exampleof such a query and the output of EXPLAIN ANALYZE
on that query (preferably done when the database is slow).

It's hard to say what is wrong without more information.

--
/Dennis Björklund


pgsql-performance by date:

Previous
From: "Anjan Dave"
Date:
Subject: Re: choosing RAID level for xlogs
Next
From: John A Meinel
Date:
Subject: Re: choosing RAID level for xlogs