On Fri, Mar 05, 1999 at 01:08:21PM -0700, hal Lynch wrote:
> I have a tabel I am trying to use but it won't work. Here are the
> particulars:
>
> Digital Unix 4.0E
> Postgres 6.3
> DEC 3000 400s
> 100M+ memory
> 500M swap
> 8 gig drive reserved for postgres
> With the full 22M records it stops working. The load/copy was done
> over night and two not one files were created.
>
> -rw------- 1 postgres database 26697728 Mar 3 23:20 /u2/pgsql/base/sis/trns
> cpt.1
> -rw------- 1 postgres database 2147483648 Mar 3 23:16 /u2/pgsql/base/sis/trns
> cpt
This file size of 2147483648 equals 2^31 -- it seems you have hit some
border here. This could either be something within PostgreSQL or a limit
of your operating system. If your OS is DEC OSF1 V4.0, I'd guess it must
be a PostgreSQL limit.
Greetinx, Jan
--
+- Jan T. Kim -------------------------------------------------------+
| email: [EMAIL PROTECTED] |
| WWW: http://www.mpiz-koeln.mpg.de/~kim/ |
*-----=< hierarchical systems are for files, not for humans >=-----*
