181 reputation
4
bio website mirthlab.com
location Honolulu, HI
age 30
visits member for 3 years, 4 months
seen Aug 12 '11 at 0:28

I hear I'm big in Japan.


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