Postgres Terminology :
Common Database Object Names
Relation : Table or Index
Tuple : Row
Attribute : Column
Storage Object Names
Page : Data Block (when block is on disk)
Buffer : Page (when block is in memory)
Database Limitations :
Maximum Indexes / Table : Unlimited
Maximum Columns / Table : 250-1600
Maximum Rows / Table : Unlimited
Maximum Field Size : 1 GB
Maximum Row Size : 1.6 TB
Maximum Table Size : 32 TB
Maximum Database Size : Unlimited
No comments:
Post a Comment