pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ruben Rubio <ruben@rentalia.com>
To: pgsql-performance@postgresql.org
Subject: [Again] Postgres performance problem
Date: Tue, 11 Sep 2007 08:33:47 +0200
Message-ID: <46E636CB.8080008@rentalia.com> (raw)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

I having the same problem I told here a few weeks before. Database is
using too much resources again.

I do a vacumm full each day, but seems it is not working. I am preparing
an update to postgres 8.2.4 (actually I am using at 8.1.3, and tests for
update will need several days)

Last time I had this problem i solved it stopping website,  restarting
database, vacuumm it, run again website. But I guess this is going to
happen again.

I would like to detect and solve the problem. Any ideas to detect it?

Thanks in advance,



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG5jbLIo1XmbAXRboRArcpAJ0YvoCT6KWv2fafVAtapu6nwFmKoACcD0uA
zFTx9Wq+2NSxijIf/R8E5f8=
=u0k5
-----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

view thread (36+ messages)  latest in thread

Message-ID: <46E636CB.8080008@rentalia.com>
Permalink:  ../46E636CB.8080008@rentalia.com/
Also on:    postgresql.org/message-id/46E636CB.8080008@rentalia.com

 · 

reply

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: [Again] Postgres performance problem
  In-Reply-To: <46E636CB.8080008@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