577 reputation
1315
bio website
location
age
visits member for 3 years, 3 months
seen 3 hours ago

Jul
4
awarded  Popular Question
Jul
2
awarded  Curious
Jun
25
answered Return a default value in group by if selected column is null
Jun
25
asked Efficiently joining two irregular series representing changes
Feb
3
awarded  Informed
Jan
17
awarded  Popular Question
Nov
28
asked Limiting PostgreSQL logging
Jul
26
accepted PostgreSQL strategies to deal with disk filling up
Jul
26
comment PostgreSQL strategies to deal with disk filling up
Interesting, pg_freespace doesn't quite return as much as VACUUM FULL is able to reclaim aferwards, but I guess it's close enough. Thank you.
Jul
25
comment PostgreSQL strategies to deal with disk filling up
Sorry, I meant I'd like to know how much space belonging to the tables (and used on disk) is actually unused and re-usable. As far as I can tell, pg_database_size returns the size on disk.
Jul
25
awarded  Popular Question
Jul
25
comment PostgreSQL strategies to deal with disk filling up
This sounds like a good approach. Do you know if there would be a way to do this based on the space available on the partition? I don't know whether there is a way to know the actual space used (by the data that's not deleted) or what could potentially be available. (I could certainly put the pg_xlog on a different partition too.)
Jul
23
asked PostgreSQL strategies to deal with disk filling up
Jun
14
awarded  Yearling
Apr
9
accepted pg_dump and ERROR: missing chunk number 0 for toast value
Jan
8
awarded  Fanatic
Dec
24
asked pg_dump and ERROR: missing chunk number 0 for toast value
Nov
28
awarded  Popular Question
Oct
9
comment Optimising query on view that merges similar tables with a clear discriminator
You're absolutely right, UNION ALL made a huge difference.
Oct
9
accepted Optimising query on view that merges similar tables with a clear discriminator