Re: [ADMIN] Speed problem - Mailing list pgsql-admin

From The Hermit Hacker
Subject Re: [ADMIN] Speed problem
Date
Msg-id Pine.BSF.4.05.9811031838250.2139-100000@thelab.hub.org
Whole thread Raw
In response to Speed problem  (Roger Books <books@mail.state.fl.us>)
List pgsql-admin
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

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


pgsql-admin by date:

Previous
From: Lorenzo Huerta
Date:
Subject: extensions to pg_user
Next
From: Roger Books
Date:
Subject: Re: [ADMIN] Speed problem