Re: [PORTS] Above 2G on a 32 bit architecture

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: MESZAROS Attila <tilla(at)chiara(dot)csoma(dot)elte(dot)hu>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] Above 2G on a 32 bit architecture
Date: 1999-07-09 16:57:26
Message-ID: 199907091657.MAA01723@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Please upgrade to 6.5. We have problems in earlier releases on this.

> Hi,
>
> I have a table exceeding the size of 2GB in version 6.4 on Linux x86.
> When I try to do a select I just receive:
> ERROR: cannot open segment 1 of relation entry
>
> According to the 6th point in the postgresql-howto postgresql supports
> larger, much larger databases than this size on even 32 bit architectures
> with some performance penalty.
>
> What have I missed?
> (a fear that certain tables must be smaller than 2G...)
> If this is true, is the only solution to buy a 64 bit architecture (sparc
> or alfa?)
>
> Attila
>
>
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-ports by date

  From Date Subject
Next Message Rüdiger Martin 1999-07-09 21:05:38 Problems with postgresql and Win NT
Previous Message Bruce Momjian 1999-07-09 16:49:39 Re: [PORTS] Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250