Re: Maintenance question / DB size anomaly...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Kurt Overberg wrote:
> OOooooookaaaaaaaaay. Since the discussion has wandered a bit I just
> wanted to restate things in an effort to clear the problem in my head.
>
> Okay, so the sl_log_1 TABLE looks okay. Its the indexes that seem to be
> messed up, specifically sl_log_1_idx1 seems to think that there's
>> 300,000 rows in the table its associated with. I just want to fix the
> index, really. So my question remains:
>
> Its it okay to dump and recreate that index (or reindex it) while the
> servers are down and the database is not being accessed?

Well, I would probably stop the slon daemons => dropping needed indexes
which slony needs can lead to quite a slowdown, and worse, the slowdown
happens because the database server is doing things the wrong way. But
that's mostly what you need to do.

OTOH, depending upon the size of your database, you might consider
starting out from a scratch database.

Andreas

>
> Tom, Bill, Chris and Richard, thank you so much for your thoughts on
> this matter so far. It helps to not feel "so alone" when dealing
> with difficult issues (for me anyway) on a system I don't know so much
> about.

#slony(at)Freenode(dot)net, #postgresql(at)freenode(dot)net are quite helpful, and
sometimes faster than mail.

Andreas

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGeTFtHJdudm4KnO0RAqDaAKDB1/eGqdwtLQdpTJzrChcp4J5M5wCglphW
ljxag882h33fDWXX1ILiUU8=
=jzBw
-----END PGP SIGNATURE-----