Postgres Pro
Downloads
Home   >   mailing lists

Re: cannot open segment 1 of relation... - Mailing list pgsql-general

From Jeff Boes
Subject Re: cannot open segment 1 of relation...
Date
Msg-id aojqcb$2jki$2@news.hub.org
Whole thread Raw
In response to cannot open segment 1 of relation...  ("Rick Eicher II" <rick@pbol.net>)
List pgsql-general
Tree view 
On Tue, 15 Oct 2002 15:39:22 -0400, Rick Eicher II wrote:

> I have started getting cannot open segment 1 of table name errors. This
> problem seems to come and go.
>
> What causes these errors and how so I fix them?
>


Don't know what causes it, but our recent troubles with this error were
cleared up (at least for now!  Knock, knock!) by doing:

REINDEX TABLE tablename;
VACUUM FULL tablename;

--
Jeff Boes                                      vox 616.226.9550 ext 24
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
           ...Nexcerpt... Extend your Expertise

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Queries take forever on ported database from MSSQL -> Postgresql
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Queries take forever on ported database from MSSQL -> Postgresql