[Freeswitch-users] PostgreSQL - p_key

Thu Nov 6 16:33:01 MSK 2014

Cool, thanks for the feedback :)

On Wed, Nov 5, 2014 at 5:59 PM, Chris Tunbridge <blasterjr at gmail.com> wrote:

> if you had 100 years of calls, having say 4 channels per call, you could
> have 63,173,781,074,347 calls per day
>
> that's 63 trillion calls... i wouldn't worry too much about seeing
> repeat/cycle anytime soon.
>
> You are talking about having 9 quintillion records, it should be safe to
> say that with bigint/serial setup like that you will be fine... you're much
> more likely to have a database server crash than run out of indexes at that
> point.
>
> On Tue, Nov 4, 2014 at 11:03 AM, Joel White <joelewhite at gmail.com> wrote:
>
>> Well here is what I have done, I think that it should work.  The PK is a
>> SERIAL DataType and I went into the sequence properties and set it to
>> CYCLED.  The max value is 9223372036854775807 and will re-cycle once that
>> number is reached.
>>
>> I only added this to the channels table right now.  I have not seen any
>> issues yet.
>>
>> On Mon, Nov 3, 2014 at 4:50 PM, Michael Jerris <mike at jerris.com> wrote:
>>
>>> I've used bigint with a default of a sequence in the past to good
>>> results.  make sure to add the option to not recreate the tables so we
>>> don't mess up your fields when we change scheme and when upgrading review
>>> for schema changes and make them manually
>>>
>>>
>>> On Monday, November 3, 2014, Joel White <joelewhite at gmail.com> wrote:
>>>
>>>> Is there another datatype that would be more suitable.  I plan to have
>>>> massive amounts of traffic.  Would the time datatype be more suitable?
>>>>
>>>>
>>>>
>>>> On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite at gmail.com>
>>>> wrote:
>>>>
>>>>> Thank you Chris
>>>>>
>>>>> On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr at gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Serial is identical to mysql's Auto Increment, so i'm going to say
>>>>>> yes.
>>>>>>
>>>>>> On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite at gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Chris and William,
>>>>>>>
>>>>>>> Can those added PKs have a data type of SERIAL?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Oct 15, 2014 at 11:33 PM, William King <
>>>>>>> william.king at quentustech.com> wrote:
>>>>>>>
>>>>>>>>  Yes, you can add columns to those tables with no issues. Try it
>>>>>>>> and see.
>>>>>>>>
>>>>>>>> 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-5518william.king at quentustech.com
>>>>>>>>
>>>>>>>> On 10/8/14 9:44 AM, Joel White wrote:
>>>>>>>>
>>>>>>>>  Is it feasible to add Primary Keys to all FreeSWITCH tables or
>>>>>>>> would this break some functionality?
>>>>>>>>
>>>>>>>>  I am asking because I am working on a multi-master replication
>>>>>>>> setup
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> _________________________________________________________________________
>>>>>>>> Professional FreeSWITCH Consulting Services: consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>>>>>>>>
>>>>>>>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>>>>>>>>
>>>>>>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
>>>>>>>>
>>>>>>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> _________________________________________________________________________
>>>>>>>> Professional FreeSWITCH Consulting Services:
>>>>>>>> consulting at freeswitch.org
>>>>>>>> http://www.freeswitchsolutions.com
>>>>>>>>
>>>>>>>> Official FreeSWITCH Sites
>>>>>>>> http://www.freeswitch.org
>>>>>>>> http://confluence.freeswitch.org
>>>>>>>> http://www.cluecon.com
>>>>>>>>
>>>>>>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>>>>>>> http://www.cudatel.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://confluence.freeswitch.org
>>>>>>> http://www.cluecon.com
>>>>>>>
>>>>>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>>>>>> http://www.cudatel.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://confluence.freeswitch.org
>>>>>> http://www.cluecon.com
>>>>>>
>>>>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>>>>> http://www.cudatel.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://confluence.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://confluence.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://confluence.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/20141106/4e697670/attachment.html 