Thread: postgresql system file size

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

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