Re: PERFORMANCE - Mailing list pgsql-php

From Jean-Michel POURE
Subject Re: PERFORMANCE
Date
Msg-id 200204200907.41783.jmpoure@translationforge.com
Whole thread Raw
In response to PERFORMANCE  (<valeria@saolucas-se.com.br>)
List pgsql-php
> "IS THERE ANYONE THAT CANT GIVE US SOME HOPE TO PERSIST ON POSTGRES OR IS
> THIS A LOST BATLE?"

I figured out the only way to "crash" PostgreSQL was entering an endless loop.

This happened to me sereval times (a trigger was spreading to another trigger,
which in turned called back the first trigger; or simply an endless loop in a
PLpgSQL function). When entering an endless loop, PostgreSQL activity climbs
up, untill it reaches 100% user activity and dramaticaly slows down Linux.
Isn't what happens to you? Turn on debuging to notice where the endless loop
happens.

This will be probably fixed in the future with an "endless loop protection"
feature.

Feel free to give us your feedback as soon as you discovers what is going on.

Cheers,
Jean-Michel





pgsql-php by date:

Previous
From: "Dave"
Date:
Subject: Re: Security - local(TRUST) and php/perl access
Next
From: Jean-Michel POURE
Date:
Subject: Re: PERFORMANCE