| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | A Palmblad <adampalmblad(at)yahoo(dot)ca> |
| Cc: | General Postgres <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: root page error |
| Date: | 2004-08-04 00:20:21 |
| Message-ID: | 20040804002021.GB28318@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dunno about the problem, but "reindex primary_index_name" will probably
fix it...
On Tue, Aug 03, 2004 at 01:04:43PM -0700, A Palmblad wrote:
> Today, queries to one of our tables started giving the following error:
> ERROR: root page xxxx of "primary_index_name" has level 0, expected 3.
>
> What would cause that? We did have a earlier today, methinks they are probably related. It's a big table, in the neighbourhood of 45 million rows.
>
> How can I fix the problem?
>
> -Adam Palmblad
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2004-08-04 00:25:57 | Re: trash talk |
| Previous Message | A Palmblad | 2004-08-03 20:04:43 | root page error |