Greg Smith, 10.07.2010 14:44:
Is there a difference in how much data could potentially be lost in
case of a failover? E.g. because 9.0 replicates the changes quicker than 8.4?
There's nothing that 9.0 does that you can' t do with 8.4 and the right
software to aggressively ship partial files aro
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
"Neuber, Dirk" writes:
> One last question. After using vacuumlo the file size of 16385/2613 is
> still the same as before.
> It seems the content has been removed but the file itself hasn't been
> compacted.
> Is there an option or tool which can do this as well ?
Yeah, you still need to apply V
> >> It is : postgres/8.3/main/base/16385/2613
>
> > This is a system catalog, pg_largeobject, which holds
> binary objects. If
> > you use Large Objects, no wonder this table could be really big.
>
> Also worth noting is that there's no automatic deletion mechanism for
> large objects. It coul
