
Again, I'm not sure this doesn't belong on -general but have left the -hackers
in the distribution list so it can be seen there.


On Fri, 9 Aug 2002, Oleg Bartunov wrote:

> I see files truncated at 1Gb on my Linux server:
> 
> -rw-------    1 postgres users    855490560 Aug  6 20:53 795261707.2
> -rw-------    1 postgres users    943259648 Aug  8 23:34 823049708
> -rw-------    1 postgres users    1073741824 Aug  6 20:53 795261707.1
> -rw-------    1 postgres users    1073741824 Aug  6 20:53 795261707
> 
> I'm wondering if postgresql doesn't have LARGE_FILES support ?

Those look like PostgreSQL's data files (from the context of the email) is that
so? And if so, have you got a requirement for having large data files? It seems
an odd requirement especially as I'd say you have approaching 3GB in one table
so you're not too far off getting to 4GB and can the host system handle such
files?


-- 
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants


Thu, 8 Aug 2002 22:42:34 +0100 (BST)
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: [HACKERS] postgresql performance tuning document ?
I see files truncated at 1Gb on my Linux server:

-rw-------    1 postgres users    855490560 Aug  6 20:53 795261707.2
-rw-------    1 postgres users    943259648 Aug  8 23:34 823049708
-rw-------    1 postgres users    1073741824 Aug  6 20:53 795261707.1
-rw-------    1 postgres users    1073741824 Aug  6 20:53 795261707

I'm wondering if postgresql doesn't have LARGE_FILES support ?

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Fri, 9 Aug 2002 01:11:06 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
postgresql performance tuning document ?
On Thu, 8 Aug 2002, Nigel J. Andrews wrote:

> > I see files truncated at 1Gb on my Linux server:
> > 
> > -rw-------    1 postgres users    855490560 Aug  6 20:53 795261707.2
> > -rw-------    1 postgres users    943259648 Aug  8 23:34 823049708
> > -rw-------    1 postgres users    1073741824 Aug  6 20:53 795261707.1
> > -rw-------    1 postgres users    1073741824 Aug  6 20:53 795261707
> > 
> > I'm wondering if postgresql doesn't have LARGE_FILES support ?

I'm a user not a hacker but I seem to remember a discussion on this 
before.  Part of the design was to break the files at approx. 1GByte 
partly or wholly to avoid any OS file size limitation.


Rod
-- 
  "Open Source Software - Sometimes you get more than you paid for..."


Thu, 8 Aug 2002 15:32:58 -0700 (PDT)
"Roderick A. Anderson" <raanders@acm.org>
Re: [HACKERS] postgresql performance tuning document ?