[KLUG Members] Postgres questions.

[Adam Bultman]

Don't know if there are a lot of postgres gurus out there, but hoo boy, I
need some help.

I'm in charge of a rather busy postgres server.  It's been running 7 point
something for  a while now, and it's running smoothly.  Well, except for
postgres seems to be slowing down bit by bit every day.  I've made some
changes in the past to try to speed things up, but to no avail.  Here's
how I run it, pretty much:

postmaster -i -N 128 -B 256 -D/[data]

This is upgraded from the standard N of 32, and B of 64 (I think?  Number
of connections and Buffers, for the un-initiated) because I was getting
'too many connections' errors.

So anyway, every night, I Vaccuum (or try, I get the errors like
"transaction in progress, can't shrink relation, but I haven't found a
solution to that) and do other items related to the database itself that
allegedly will help speed things up.

However, it just gets slower.  My users (who are snippy to begin with) and
now becoming brutal, and I really have no recourse but to just say, "Shut
your pie hole, it's your own damn fault".  The person who set up this
system is gone, and not entirely available, and I really don't want to
kludge stuff here.

If you have any general pointers, I'd be glad to hear them, but I don't
have much to say or do here...

Adam

-- 
Adam Bultman
adam@glaven.org
[ http://www.glaven.org ]