Question
Pages are sizes of a database table read from disk and placed into memory (either virtual memory or into RAM). Is a page always 8 KB in a SQL database?
Answer
No. But they are often 8 KB in size.
- PostgreSQL has pages that are 8 KB in size (according to this page).
- MySQL pages vary in size from 8 KB to 64 KB (according to this page).
- Oracle pages are 4K in size, but Oracle supports HugePages which are bigger. To read more see this page.
- SQL Server has pages that are 8 KB in size (according to this page).