| From: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: cannot open segment 1 of relation... |
| Date: | 2002-10-16 13:43:46 |
| Message-ID: | aojqcb$2jki$2@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Siegel | 2002-10-16 14:01:04 | pg_dump on large columns |
| Previous Message | Doug McNaught | 2002-10-16 13:39:34 | Re: Queries take forever on ported database from MSSQL -> Postgresql |