How many rows can postgres handle?



How many rows can postgres handle?..

Answer / Ran Bahadur Singh

PostgreSQL doesn't have a strict limit on the number of rows that can be stored in a table, but it's best practice to keep tables under 2GB for optimal performance. If you need to store more data, consider partitioning or using external tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

Who invented postgresql?

1 Answers  


How do you add a column?

1 Answers  


Is primary key indexed by default?

1 Answers  


What is schema in reading comprehension?

1 Answers  


What is catalog in postgresql?

1 Answers  


what is the advantage of RAID

4 Answers   Wipro,


Explain about indices of PostgreSQL?

1 Answers  


what is software?

1 Answers  


What is the port 5432?

1 Answers  


Are foreign key constraints necessary?

1 Answers  


What is logical replication in postgresql?

1 Answers  


What does mvcc mean?

1 Answers  


Categories