Re: Need for speed

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Need for speed
Date: 2005-08-16 18:47:50
Message-ID: Pine.LNX.4.44.0508162045480.2995-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-08-16 19:04:05 Re: choosing RAID level for xlogs
Previous Message Anjan Dave 2005-08-16 18:37:38 Re: choosing RAID level for xlogs