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