All Questions
Tagged with disk-structures postgresql
5 questions
0
votes
1
answer
106
views
Database systems - data type alignment padding and record size (C/C++ related)
In PostgreSQL there is alignment padding of various datatypes which can increase (or decrease) the size of records (as stored on disk) in varying ways (see these links, 1, 2, 3):
I searched for "...
- 31k
2
votes
1
answer
314
views
Is postgres vacuum secure
Postgres delete doesn't actually remove the record from the table file.
Once the delete is committed and the last transaction is closed, no postgres process can see the record any more, the deleted ...
- 3,656
2
votes
1
answer
124
views
How Database Formats Files for Disk
This SO answer outlines how MySQL organizes its database into files, but doesn't describe the structure of the files themselves.
I am wondering, at the physical level, how relational database ...
- 221
1
vote
1
answer
1k
views
Which hard disks for PostgreSQL? [closed]
The size of the our PostgreSQL data directory is 100 GByte.
Up to now we use traditional hard disk drives and hardware RAID 10.
Which hard disk drives and RAID setup would give us maximum ...
- 1,621
3
votes
1
answer
1k
views
How un-clustered is a CLUSTER USING table in PostgreSQL
I have some tables which benefit greatly from CLUSTER ON/CLUSTER USING in Postgres SQL:
# CLUSTER table USING index_name;
# ANALYZE VERBOSE table;
# CLUSTER VERBOSE;
A maintenance task periodically ...
- 135