[Freeswitch-users] PostgreSQL rapid XID incrementation

[Joel White]

I disabled the DB writes.  I would say that it was hitting the DB at ~2
queries per second...  that is just an estimate, but over the course of 30
minutes the XID had got up to 4,000

I was kinda figuring that mod_callcenter was just running select
statements....

I will need to test out mod_fifo

Is there anything to be done with mod_callcenter to correct this behavior
short of rewriting the code?





On Fri, Jun 20, 2014 at 12:55 PM, William King <william.king at quentustech.com
> wrote:

> If you can, try using mod_fifo instead of mod_callcenter. mod_callcenter
> has a inner loop running very rapidly where it is constantly doing
> select statements to the DB looking for new calls into the system.
>
> William King
> Senior Engineer
> Quentus Technologies, INC
> 1037 NE 65th St Suite 273
> Seattle, WA 98115
> Main:   (877) 211-9337
> Office: (206) 388-4772
> Cell:   (253) 686-5518
> william.king at quentustech.com
>
> On 06/20/2014 09:39 AM, Joel White wrote:
> > A bit more information.  When enabling mod_voicemail to write to
> > PostgreSQL the activity is low.  When I enable mod_callcenter to write
> > to PostgreSQL the queries are going berserk.
> >
> > If anyone has any guidance for me it would be greatly appreciated
> >
> >
> > On Fri, Jun 20, 2014 at 12:27 PM, Joel White <joelewhite at gmail.com
> > <mailto:joelewhite at gmail.com>> wrote:
> >
> >     I was wondering why when I enabled PostgreSQL in Freeswitch, the
> >     PostgreSQL XID is incrementing at an extreme pace.  I do not have
> >     hardly any transactions being inserted into the db.  It looks like
> >     most all of the queries are SELECT statements.
> >
> >     Is this normal?  Or is there something that I need to tweak in
> >     freeswitch?
> >
> >
> >
> >
> >
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services:
> > consulting at freeswitch.org
> > http://www.freeswitchsolutions.com
> >
> > 
> > 
> >
> > Official FreeSWITCH Sites
> > http://www.freeswitch.org
> > http://wiki.freeswitch.org
> > http://www.cluecon.com
> >
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users at lists.freeswitch.org
> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> > http://www.freeswitch.org
> >
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140620/02c302f7/attachment.html