Why Does a Postgresql Update Query Increase Table Size?
Posted3 months agoActive3 months ago
happy-bardeen-m0xy9ga77q.liara.runTechstory
calmneutral
Debate
0/100
PostgresqlDatabase ManagementQuery Optimization
Key topics
Postgresql
Database Management
Query Optimization
The article discusses why an UPDATE query in PostgreSQL can increase the table size, with the discussion touching on the underlying database mechanics and potential implications.
Snapshot generated from the HN discussion
Discussion Activity
Light discussionFirst comment
2m
Peak period
1
0-1h
Avg / period
1
Key moments
- 01Story posted
Sep 20, 2025 at 4:25 PM EDT
3 months ago
Step 01 - 02First comment
Sep 20, 2025 at 4:28 PM EDT
2m after posting
Step 02 - 03Peak activity
1 comments in 0-1h
Hottest window of the conversation
Step 03 - 04Latest activity
Sep 20, 2025 at 4:28 PM EDT
3 months ago
Step 04
Generating AI Summary...
Analyzing up to 500 comments to identify key contributors and discussion patterns
Discussion (1 comments)
Showing 1 comments
tuatoru
3 months ago
How is this a question? Do people not read the documentation anymore? Postgresql is, with OpenBSD, the type specimen of how open-source documentation should be done. Use the documentation.
View full discussion on Hacker News
ID: 45317122Type: storyLast synced: 11/17/2025, 1:04:01 PM
Want the full context?
Jump to the original sources
Read the primary article or dive into the live Hacker News thread when you're ready.