Re: [ADMIN] Speed problem

On Tue, 3 Nov 1998 The Hermit Hacker wrote:
> On Tue, 3 Nov 1998, Roger Books wrote:
>
> > I have a database that I need to pull the schema off of.  When
> > I run pg_dump -s the machine rolls over and dies.  To the tune
> > of I left it running over the weekend and still had 98% cpu
> > usage by postgress monday.  I managed to do a 'delete from statistics'
> > and it accomplished this overnight, but when I then ran a vacuum to
> > actually remove the garbage it still hadn't finished after 48 hours.
> > Anyone have any suggestions?  (Other than kicking myself for not
> > writing them down as I created them).
>
>      \d tablename
>

Tried that, I let that one run for 30 hours with no results.  I wouldn't
mind waiting a few days for the results, but 95+% CPU usage is kind
of hard on the other (minor) purpose this machine is used for.


Roger