From: Ruben Rubio <ruben@rentalia.com>
To: pgsql-performance@postgresql.org
Subject: Postgres performance problem
Date: Mon, 27 Aug 2007 13:41:45 +0200
Message-ID: <46D2B879.6010308@rentalia.com> (raw)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
Note: I have already vacumm full. It does not solve the problem.
I have a postgres 8.1 database. In the last days I have half traffic
than 4 weeks ago, and resources usage is twice. The resource monitor
graphs also shows hight peaks (usually there is not peaks)
The performarce is getting poor with the time.
Im not able to find the problem, seems there is not slow querys ( I have
log_min_duration_statement = 5000 right now, tomorrow I ll decrease it )
Server is HP, and seems there is not hardware problems detected.
Any ideas to debug it?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG0rh5Io1XmbAXRboRAuaTAJ4tDVHUMN5YRBdWxT//kPAfBvYqRACgvLst
rJF3dmxzWHDOWB8yQwTyvpw=
=2ic9
-----END PGP SIGNATURE-----
Attachments:ruben.vcf (text/x-vcard, 244B) download
begin:vcard
fn:Ruben Rubio
n:Rubio;Ruben
org:Rentalia Holidays S.L
adr;quoted-printable:;;Gran v=C3=ADa 31, 9=C2=BA-1=C2=BA;Madrid;;;Spain
email;internet:ruben@rentalia.com
tel;work:+34915233104
url:http://www.rentalia.com
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ruben@rentalia.com
Subject: Re: Postgres performance problem
In-Reply-To: <46D2B879.6010308@rentalia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox