Postgres Pro
Downloads
Home   >   mailing lists

Above 2G on a 32 bit architecture - Mailing list pgsql-ports

From MESZAROS Attila
Subject Above 2G on a 32 bit architecture
Date
Msg-id Pine.LNX.3.96.990709162204.26528C-100000@chiara.csoma.elte.hu
Whole thread Raw
Responses Re: [PORTS] Above 2G on a 32 bit architecture
List pgsql-ports
Tree view 
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

pgsql-ports by date:

Previous
From: Unprivileged user
Date:
Subject: Port Bug Report: Error in errors.properties in JDBC interface
Next
From: Bruce Momjian
Date:
Subject: Re: [PORTS] Above 2G on a 32 bit architecture