On Jun 13, 2:35 pm, [EMAIL PROTECTED] wrote:
> On Jun 8, 3:23 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
>
>
>
> > Gunther Mayer wrote:
> > > Hi there,
>
> > > I just found the following message in my logs:
>
> > > Jun 8 10:38:38 caligula postgres[56868]: [1-1] : LOG: could not
> > > truncate directory "pg_subtrans": apparent wraparound
>
> > > Should I be worried or can I just ignore this one? My database is still
> > > small (a pg_dumpall bzippe'd is still around 500KB) so I doubt that I'm
> > > affected by any transaction id wraparound problems. I also vacuum
> > > analyze once a day and have pg_autovacuum turned on.
>
> > What version are you running? This seems to match the description of a
> > bug fixed for 8.2 and 8.1.5:
>
> I noticed the same message in my logfiles (once on each of two
> servers). I'm running 8.1.8, and the server's been running flawless
> for about 2 months.
>
> Gerhard
Can someone tell me if I should be concerned about this log entry ? My
database is quite large (~ 2G in PGDATA)
regards
Gerhard
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
