Hi all,
I have installed postgresql(8.1.4) data dir on a partition (/data) which rests on a separate disk from OS disk. The
installdir is default (usr/local/pgsql).
Now when i use use pgbench with scaling factor of 1000 it creates a whooping 15 GB database. but i see /var partition
usedspace increases considerably - why is this happening ? i expected more free disk space to be used in /data !
does it mean that the actual database created lies in /var instead of /data ?
how do i fix it ?
regards,
KM