'What's the difference between a tuple and a row in Postgres?
My general understanding is that a tuple is a row. However, I'm using the Postgres dev plan in Heroku. It has a limit of 10,000 rows. I have over 100,000 entries for n_live_tup. How can this be?
Solution 1:[1]
"Tuple" is the abstract term, "row" is for the concrete implementation.
Just like "relation" versus "table".
Otherwise the terms are often used meaning the same. You can find more for each of them in Wikipedia.
No idea what's behind the Heroku policies. But the numbers for n_live_tup in pg_stat_user_tables or pgstattuple represents the number of live rows in your table.
See:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |