| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brendan Duddridge <brendan(at)clickspace(dot)com> |
| Cc: | PostgreSQL-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: page is uninitialized? |
| Date: | 2006-04-19 15:02:11 |
| Message-ID: | 26215.1145458931@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Brendan Duddridge <brendan(at)clickspace(dot)com> writes:
> I was doing a vacuum analyze verbose on my database today and I
> noticed the following message printed out:
> WARNING: relation "category_product" page 128979 is uninitialized
> --- fixing
> WARNING: relation "category_product" page 128980 is uninitialized
> --- fixing
> ...
There are some situations in which this is expected, which is why
VACUUM deals with it, but none of them are very good: they involve
backends adding a page to a table and then failing before they can
write a WAL record about initializing the page. Have you had any
crashes recently?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2006-04-19 15:02:25 | Re: Categories and Sub Categories (Nested) |
| Previous Message | Tom Lane | 2006-04-19 15:00:05 | Re: page is uninitialized? |