Re: db size - Mailing list pgsql-performance

From PFC
Subject Re: db size
Date
Msg-id op.t9lh5em8cigqcu@apollo13.peufeu.com
Whole thread Raw
In response to Re: db size  (Adrian Moisey <adrian@careerjunction.co.za>)
Responses Re: db size
List 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 by date:

Previous
From: Adrian Moisey
Date:
Subject: Re: db size
Next
From: Gregory Stark
Date:
Subject: Re: shared_buffers performance