Home / Questions / 151980
Accepted
Shassain
Asked: 2020-04-01 14:54:08 +0800 CST 2020-04-01 14:54:08 +0800 CST

what is the limit of an id, in database?

  • 772

I have a database Postgresthat has been working for a week and the amount of data entered is 3788, this number reflects that idof my table, they also inform me that this amount is similar per week.

I create idthe following way:

id integer NOT NULL DEFAULT nextval('memoria_id_seq'),

So, what worries me and wanted to know is:

What is the limit of this id?
Is it convenient for me to change the database to extend this id?
Or maybe I would just have to change the data type? What would this data type be?

sql

1 Answers

  1. Best Answer

    The field being of type INT; has the following characteristics

    int (integer): Range is from -2,000,000,000 to 2,000,000,000 or so.

    Although you can perfectly occupyBIGINT

    bigint (big integer): calculating it would be approx.2^64

    what should concern you in any manager is the quality and logic of your queries to extract data

    Below you can see the tables with the data types in both PostgreSQL and MySQL to have a clear idea

    Look at this table and check the source (PostgreSQL)

    enter image description here

    Type of data

    What you should check as your system grows are: bandwidth available to the web server, RAM memory, quality of SQL queries, etc etc

    In the following table I show you the data lengths for MySQL so you can check that it does not depend on the database manager

    enter image description here

    • 4