Re: db size
| От | PFC |
|---|---|
| Тема | Re: db size |
| Дата | |
| Msg-id | op.t9lh5em8cigqcu@apollo13.peufeu.com обсуждение исходный текст |
| Ответ на | Re: db size (Adrian Moisey <adrian@careerjunction.co.za>) |
| Ответы |
Re: db size
|
| Список | pgsql-performance |
> Will this help with performance ?
Depends if the bloat is in part of your working set. If debloating can
make the working set fit in RAM, or lower your IOs, you'll get a boost.
>> Now, is the bloat in the tables (which tables ?) or in the indexes
>> (which indexes ?), or in the toast tables perhaps, or in the system
>> catalogs or all of the above ? Or perhaps there is a long-forgotten
>> process that got zombified while holding a huge temp table ? (not very
>> likely, but who knows).
>> Use pg_relation_size() and its friends to get an idea of the size
>> of stuff.
>
> I'll look into that, thanks
>
В списке pgsql-performance по дате отправления: