Re: pg_total_relation_size accuracy guarantee

2017-11-24 Thread Nikita
Source is good enough in my case and I planned to grep it anyway, so thanks for saving my time! 2017-11-24 10:15 GMT+03:00 Laurenz Albe : > Nikita wrote: > > 1. pg_total_relation_size return predictable approximately correct table > size (apart from some preallocation) withou

pg_total_relation_size accuracy guarantee

2017-11-23 Thread Nikita
Hello, I'am currently trying to implement some simple disc space limitation mechanism for my database. Database is partition based and insert-only - I insert new rows to the current partition and drop oldest partition when disc space limit exceeded. Algorithm is quite simple and it seems it works