Magnus Hagander wrote:
Sounds like the WAL log. It's in the pg_xlog directory - verify that that's where the data is increasing. The WAL log is global and not per-tablespace, so it doesn't follow your tablespaces location.
Nope, it's the files in the pg_tblspc directory on my C drive, they are named identically to the files in my tablespace directory on D drive and have identical sizes. When I add data to a table in this tablespace, I see concurrent increases in file size in both my own tablespace directory and the pg_tblspc directory tree.
Eg within this directory tree I have a file 17177 which represents my job_classification table, if I insert a bunch of records, the 17177 file on my D drive increases in size as does the 17177 file in the pg_tblspc subdirectory.
I can see the pg_xlog files, which aren't an issue as they are archived off to E drive.
I've just noticed in the tablespace documentation (Ch 19.6) that PG makes use of symbolic links that point to any user-defined tablespaces but AFAIK W2K3 doesn't support symlinks.
-- Paul Lambert Database Administrator AutoLedgers - A Reynolds & Reynolds Company ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
