| From: | Roger Books <books(at)mail(dot)state(dot)fl(dot)us> |
|---|---|
| To: | pgsql-admin(at)hub(dot)org |
| Subject: | Re: [ADMIN] Speed problem |
| Date: | 1998-11-04 13:31:49 |
| Message-ID: | ML-2.2.910186309.1541.books@booksr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Mackintosh | 1998-11-04 15:05:24 | Re: [ADMIN] Speed problem |
| Previous Message | Tony Reina | 1998-11-04 09:32:12 | Re: [ADMIN] Speed problem |