Storage pricing(?)
Hey, noticed my database is taking a bunch of storage, and I deleted the data.
Now, the index was stil huge, so I ran VACUUM FULL on few tables that had huge indexes.
What I am noticing is that there is actually an increase in storage.
Will I get billed by the peak storage size?
I am on Scale plan if that matters.
4 Replies
stormy-goldOP•2mo ago
Not sure if it's better to open a support ticket for this
stormy-goldOP•2mo ago
Probably I should have done pg_repack: https://neon.com/docs/extensions/pg_repack
Neon
The pg_repack extension - Neon Docs
Postgres, like any database system, can accumulate bloat over time due to frequent updates and deletes. Bloat refers to wasted space within your tables and indexes, which can lead to decreased query p...
national-gold•2mo ago
Hi, this is how you are billed for extra storage on the Scale plan:
Extra Storage: If you exceed 50 GB, extra storage is $1.50 per GB-month.
Deleting data can add to storage temporarily. Neon keeps a history of writes (inserts, updates, deletes) to support point-in-time restore.
You can reduce your restore window to keep less history at the cost of a shortened restore window.
Where you are on the Scale plan, I recommend reaching out to Support for additional guidance.
https://console.neon.tech/app/projects?modal=support
stormy-goldOP•2mo ago
Gotcha, thanks Daniel, will reach out