This article deep dives into what is the difference in indexing in MySQL vs PostgreSQL
I have a concern as When we update.delete the row data from postgreSQL . AS data is stored in heap doesn't the heap would overflow.
The data in the heap is also persisted in the disk.
I have a concern as When we update.delete the row data from postgreSQL . AS data is stored in heap doesn't the heap would overflow.
The data in the heap is also persisted in the disk.