Hi all
Ah... \d tablename should return before you can get your finger off the
enter key, as it (I would think) queries a small house keeping table that
contains the database structure, NO? So \d tablename should be totally
independent of the amount of data in that table.
I have never had a table that big, but the times you are talking about
sound totally absurd.
I subjest that some thing is majorly botched and a full dump / full
rebuild / restore may be in order here.
Of course I am assumming here that the box this runs on is up to the task,
massive amount of memory, massive massive amount of swap space, late
module high speed CPU with lots of cache on a top end mother board ...
etc.
Note, with a table that big your swap space should be on a physically
differant hard drive (from the db) so that the db and the swap are not
always fighting for the use of the drive heads.
You probably know all this, I just mention it "just in case", as I know
nothing of how much you do or don't know about any thing.
On Wed, 4 Nov 1998, Roger Books wrote:
> 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
>
Terry Mackintosh <terry@terrym.com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.
Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!
