Hello,
I'm having a performance issue with
postgresql. I'm using it with JBoss BPM api and when I use the api to
delete a process instance from the database, it seems like the delete requests
are taking quite a long time to delete. I've also noticed that when I
execute the delete, the c
4
max_fsm_relations = 2000
bgwriter_lru_percent = 50.0
bgwriter_lru_maxpages = 50
wal_buffers = 64
I hope you can all help.
Thank you,
Steve.
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 29, 2006 11:01 AM
To: Schwenker, Stephen
Cc: pgsql-
really is
unindexed foreign keys, but from first glance it looks like they're all
indexed.
Thanks for your suggestion.
Steve.
From: Reece Hart [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 02, 2006 2:53 PMTo: Tom
LaneCc: Schwenker, Stephen; Michael Fuhr;
pgsql-general@postgr
Hello,
I'm having a major Vacuuming problem. I used to do a full vacuum every
morning on my postgres database to clean up empty space on a table but
because of it's size, the locking of the database causes my application
server to max out the database connections and causes database errors.
To f
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 05, 2006 4:09 PM
To: Glen Parker
Cc: Schwenker, Stephen; pgsql general
Subject: Re: [GENERAL] HELP: Urgent, Vacuum problem
On Tue, 2006-12-05 at 14:56, Glen Parker wrote:
> Scott Marlowe wrote:
> > On Mon, 2006-12-04
Hello,
I've just compiled an instance of Postgresql 8.2.3 on a new linux box
and have added some databases to it. I've noticed however that the
autovacuum is not running. I have turned on the autovacuum,
stats_start_collector, and stats_row_level and still the autovacuum is
not running.
Can a
autovacuum is not working?
:)
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Fri 06/04/2007 1:21 PM
To: Schwenker, Stephen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running
"Schwenker, Stephen" <[EMAIL PROTE
I'm sure. That column is null for all tables in my databases accept for the
few tables that I've vacuumed manually.
Any other suggestions? :)
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Fri 06/04/2007 1:21 PM
To: Schwenker, Stephen
Cc: pgs
t.
Thank you,
Steve.
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Fri 06/04/2007 1:21 PM
To: Schwenker, Stephen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running
"Schwenker, Stephen" <[EMAIL PROTECTED]> writes:
> I've just
It says it's on and I have also turned on all stats collecting.
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL PROTECTED]
Sent: Monday, April 09, 2007 3:06 PM
To: Schwenker, Stephen
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not ru
10 matches
Mail list logo
