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

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

pgsql-performance by date

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

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