Re: splitting a table? - Mailing list pgsql-general

From Johnson, Shaunn
Subject Re: splitting a table?
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FED483@snt452.corp.bcbsm.com
Whole thread Raw
In response to splitting a table?  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
List pgsql-general

--i know!  i'm having problems doing pg_dumps now
--... i'm getting 'corrupt memory' errors more and
--more when i dump the tables ... and the ones
--where it can't find the index and aborts the
--dump.

--that and the fact that i don't have much
--disk space to work with ... (i know ... no
--excuse!)

--guilty.

-X

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, June 20, 2003 11:05 AM
To: Johnson, Shaunn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] splitting a table?

"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> --haven't done a vaccumdb / analyze
> --on the entire db lately because of
> --the errors i get

> FATAL 2:  open of /var/lib/pgsql/data/pg_clog/0003 failed: No such file or
> directory

You need to be dealing with that, not ignoring it.  An update to 7.2.4
might help.

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: splitting a table?
Next
From: Andrew Sullivan
Date:
Subject: Re: [pgsql-advocacy] MySQL gets $19.5 MM