I took a pg_dump -Fc from a Pg 8.0.1 installation on (Solaris / Sun)
with Slony installed and attempted to restore to 8.0.2 on Linux / x86
without Slony installed.
pg_restore skipped all of the Slony related items, but then it
immediately jumped up to 700MB of memory usage and 99% CPU, but the DB
connection was idle. Two hours later, memory usage had gradually dropped
to 500MB, but CPU was still going full still with an idle database
connection.
I eventually clued in and made a TOC and removed all of the Slony items,
but I'm still curious to know what exactly pg_restore had been doing for
the last hour or so.
--