postgresql system file size

Started by Nonameover 22 years ago2 messages
#1Noname
waldo.lacanlale@qualservcentral.com

Hi,

Is there a compile option or any other tweak to restrict postgresql
data files size (the files that are usually under /usr/local/pgsql/data
directory) to a certain limit, for example no file should be bigger
that 10Mb. Thanks in advance

Wally

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Noname (#1)
Re: postgresql system file size

waldo.lacanlale@qualservcentral.com writes:

Is there a compile option or any other tweak to restrict postgresql
data files size (the files that are usually under /usr/local/pgsql/data
directory) to a certain limit, for example no file should be bigger
that 10Mb. Thanks in advance

Check out RELSEG_SIZE in src/include/pg_config.h. The default is 1GB.

--
Peter Eisentraut peter_e@gmx.net