Performance failure / automatic restart / cron ?

**Martijn van Oosterhout** · Nov 12 '05, 12:24 AM

Re: Performance failure / automatic restart / cron ?

Question? Why are you restarting the postmaster? If you're getting a lot of
PIDs that means you have a lot of connections open. What are you doing to
use so many connections? Did you increase the max_connections variable?

Please supply more details of your actual problem. Perhaps a 'ps aux'
output.

Hope this helps,

On Sat, Oct 25, 2003 at 04:57:30PM +0200, Piotr Trawi?ski wrote:[color=blue]
>
> I have this notorious problem: at some point pgsql simply hangs up and
> requires a restart.
>
> ---------------------------------------------------------------------------
> -------
> homer:/usr/share/doc/postgresql-contrib# /etc/init.d/postgresql restart
> Restarting PostgreSQL database: postmaster
> Stopped /usr/lib/postgresql/bin/postmaster (pid 14243 14245 14247 14750
> 14811 1489 15569 15570 15573 15584 15643 15644 15665 15800 15801
> 15804 15817 15874 16072 20473 20474 20549 20763).
> Starting PostgreSQL postmaster.
> postmaster successfully started
> ...
> homer:/usr/share/doc/postgresql-contrib#
> ---------------------------------------------------------------------------
> -------
>
> Whenever i restart the server i get a long list of pid's - sometimes its many
> lines.
>
> I wrote a little script to restart, vacuum and analyze the database. And
> although the script runs, there are no results. i have to restart the db
> manualy...
> ive seen a post about vacuum an analyze not working from the cron,
> unfortunately there was no solution.
>
> Ill be happy with any ideas - in the last week the db required me to haveit
> restarted once a day which is not very convenient.
>
> I realize my app is very resource hungry but the thing is that it works great
> with mysql. The problem occurs only with pgsql which i realy need.
>
> Best regards,
> Piotr
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org[/color]

--
Martijn van Oosterhout <kleptog@svana. org> http://svana.org/kleptog/[color=blue]
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato[/color]

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/mpclY5Twig3Ge+Y RAiI9AJ98HGe9LY 2osNblZ/CljrVN7n0WQQCeI pGB
uLWoQO6XsbENa1W zCG+mIPQ=
=qzHj
-----END PGP SIGNATURE-----