[Freeswitch-users] PostgreSQL - p_key

[Chris Tunbridge]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141105/e746424b/attachment-0001.html