Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
5
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Aug
27
awarded  Popular Question
Jun
9
comment Postgresql 9 database size swelling after daily bulk updates
Thanks for the tip about pgAdmin. I've updated my question with some info from the statistics tab.
Jun
9
revised Postgresql 9 database size swelling after daily bulk updates
added an update
Jun
9
comment Postgresql 9 database size swelling after daily bulk updates
Hmm, interesting. The app_prices table is the table with the most rows (just over 35 million). It has 5 columns and (you're right) three indices. I guess I'll look into index bloat and see if anything can be done there. Thanks!
Jun
9
awarded  Student
Jun
9
comment Postgresql 9 database size swelling after daily bulk updates
Yeah, I had come across that document earlier, but I'm inclined to think something other than the normal MVCC operations is happening here. If my data is only 4-5GB and, let's say every row is hit on an update, then I can see the db doubling its size, but tripling the data (15GB!) seems like a bit much no?
Jun
9
asked Postgresql 9 database size swelling after daily bulk updates
Apr
28
awarded  Editor
Apr
28
revised Where does Varnish usually go in a Rails web stack?
added 269 characters in body
Apr
24
awarded  Teacher
Apr
23
answered Where does Varnish usually go in a Rails web stack?
Apr
23
awarded  Autobiographer