Re: [GENERAL] 2 gig file size limit

2001-07-12 Thread markMLl . pgsql-general
Martijn van Oosterhout wrote: > What the limit on NT? I'm told 2^64 bytes. Frankly, I'd be surprised if MS has tested it :-) -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] ---(end of

Re: [GENERAL] 2 gig file size limit

2001-07-12 Thread markMLl . pgsql-general
Marco Colombo wrote: > BTW, the document contains some limits. FS size limit is reported to be > 2TB (block-device size limit). I don't know if it applies to LVM logical > volumes. Ext2 FS size limit is 16TB (for 4kB blocks FS). You need to put > some effort to place 16TB on a single FS. Thanks

Re: [GENERAL] 2 gig file size limit

2001-07-11 Thread Martijn van Oosterhout
On Wed, Jul 11, 2001 at 12:06:05PM +, [EMAIL PROTECTED] wrote: > > Linus no longer has a filesystem file size limit ( or at least on > > that you'll hit easily) > > I'm not concerned with "easily". Telling one of our customers that we > chose a particular server becuase they won't easily hit

Re: [GENERAL] 2 gig file size limit

2001-07-11 Thread markMLl . pgsql-general
Ian Willis wrote: > > Postgresql transparently breaks the db into 1G chunks. Yes, but presumably these are still in the directory tree that was created by initdb, i.e. normally on a single filesystem. > The main concern is during dumps. A 10G db can't be dumped if the > filesustem has a 2G limi

Re: [GENERAL] 2 gig file size limit

2001-07-11 Thread markMLl . pgsql-general
Can a single database be split over multiple filesystems, or does the filesystem size under e.g. Linux (whatever it is these days) constrain the database size? -- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] --

[GENERAL] 2 gig file size limit

2001-07-10 Thread Naomi Walker
If PostgreSQL is run on a system that has a file size limit (2 gig?), where might cause us to hit the limit? -- Naomi Walker Chief Information Officer Eldorado Computing, Inc. 602-604-3100 ext 242 ---(end of broadcast)--- TIP 3: if posting/readi