Обсуждение: Above 2G on a 32 bit architecture

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

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@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026