[PERFORM] Lots of postmaster processes (fwd)

2005-12-13 Thread Ameet Kini
Resending it here as it may be more relevant here... Ameet -- Forwarded message -- Date: Tue, 13 Dec 2005 11:24:26 -0600 (CST) From: Ameet Kini <[EMAIL PROTECTED]> To: pgsql-admin@postgresql.org Subject: Lots of postmaster processes In our installation of the postgres

Re: [PERFORM] postgresql performance tuning

2005-12-06 Thread Ameet Kini
> what evidence do you have that you are suffering index bloat? or are > you just looking for solutions to problems that don't exist as an > academic exercise? :-) Well, firstly, its not an academic exercise - Its very much of a real problem that needs a real solution :) I'm running postgresql

[PERFORM] postgresql performance tuning

2005-12-06 Thread Ameet Kini
Hello, I have a question on postgres's performance tuning, in particular, the vacuum and reindex commands. Currently I do a vacuum (without full) on all of my tables. However, its noted in the docs (e.g. http://developer.postgresql.org/docs/postgres/routine-reindex.html) and on the lists here t

[PERFORM] postgresql performance tuning

2005-12-06 Thread Ameet Kini
This didn't get through the first time around, so resending it again. Sorry for any duplicate entries. Hello, I have a question on postgres's performance tuning, in particular, the vacuum and reindex commands. Currently I do a vacuum (without full) on all of my tables. However, its noted in th