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

Re: 7.1 performance

From: Anuradha Ratnaweera <anuradha(at)gnu(dot)org>
To: Thomas Heller <maniax(at)comtron(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 7.1 performance
Date: 2001-04-28 12:34:00
Message-ID: Pine.LNX.4.21.0104281830580.233-100000@presario (view raw or flat)
Thread:
Lists: pgsql-admin
I had to run a script which did few thousand queries on 7.1 few times and
after that even the queries that are done entirely based on indexes were
also _VERY_ slow. But I did a "vacuumdb dbname" as postgres user and after
that thigs were back to normal - very fast.

But I could _NOT_ reproduce this.

Does the number of WAL files have to do anything with this?

Anuradha

On Wed, 25 Apr 2001, Thomas Heller wrote:

> Hi there,
> 
> i just upgraded my database system from 7.0.3 to 7.1 ... i did a
> dumpall and psql -f dump.sql to the new db. the data is in place
> correctly and its running fine. but as soon as i put the connections
> back on to the db the load raised to 6. prior to the upgrade the
> system load was an 0.3 ... now it is at 6.
> 
> is this normal for 7.1 to need so much more hardware? i use the same
> settings for sort_mem, buffers, etc. just no fsync. I thought 7.1
> wouldn't need that anymore.
> 
> Any suggestions that i should do? the performance is really bad now :(
> 
> btw: the db is a dedicated p3-800 + 1gig ram + uw scsi drives running
> redhat6.2
> 
> thanks cu,
> thomas
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 


In response to

pgsql-admin by date

Next:From: Anuradha RatnaweeraDate: 2001-04-28 12:41:15
Subject: Re: Reason to not upgrade from 6.5 to 7.0 or above
Previous:From: Christian MarschalekDate: 2001-04-27 17:38:39
Subject: RE: ODBC connection to PostgreSQL

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