Craig Ringer writes:
> If the bloat issue were with relations rather than indexes I'd suspect
> free space map issues as you're on 8.3.
> http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html
> My (poor) understanding is that index-only bloat probably won't be an
> FSM is
On 20/09/2010 7:59 PM, Daniele Varrazzo wrote:
Does anybody have some information about where the bloat is coming
from and what is the best way to get rid of it? Would a vacuum full
fix this kind of problem? Is there a way to fix it without taking the
system offline?
It's hard to know where th
Hello,
we are experiencing some performance degradation on a database where
the main table is running towards the 100M record. Together with the
slowness of the queries I notice these symptoms:
- size bloat of partial indexes
- very bad planning estimates
I'd appreciate any hint to get a better
