| 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: | Whole Thread | Raw Message | 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
| 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 |