Re: PERFORMANCE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



> "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






[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux