517 reputation
1313
bio website
location
age
visits member for 2 years, 10 months
seen Apr 8 at 13:01

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
Oct
8
comment Optimising query on view that merges similar tables with a clear discriminator
@dezso sorry, just edited with real data (I'm in fact using 5 similar tables, A to E.)
Oct
8
revised Optimising query on view that merges similar tables with a clear discriminator
Added details using actual query
Oct
8
awarded  Custodian
Oct
8
reviewed Approve suggested edit on Optimising query on view that merges similar tables with a clear discriminator