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
