"Sorry too many clients" error and vacuum command

From: "Gyula Toth" <kondorb(at)westel900(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: "Sorry too many clients" error and vacuum command
Date: 2001-02-02 15:11:19
Message-ID: 95eira$1dv2$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


1. Postgres in default does not delete the expired/unnecessary lines from
the tables, therefore we have to run vacuum regularly to delete these lines
in order to prevent the database from becoming too large. Is there any way
to change the default, so that the updated lines do not duplicate and the
unnecessary lines are deleted completly from the table ? Actually can we
forget about vacuum completely?
2. The vacuum runs for hours in our database server, sometimes it even kills
Postgres, we do not know why. Is there any way to implement any other
method/command instead of using vacuum or, if not, how can we speed up this
process?
3. What can be the reason for the error message "Sorry, too many clients
already!" Can we avoid this error in any other way than switching the number
of backends with -N and -B to a higher level?

If anybody can help with these problems we would be willing to pay for the
help as we have run out of ideas,

thanks for any help,

Gyula Toth

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2001-02-02 15:22:06 Re: Dumb Question
Previous Message David D 2001-02-02 14:44:04 ERROR:cannot read block 9053 of mots