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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group