Обсуждение: 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
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
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..."