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. -- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
