Re: [GENERAL] Query re disk usage

2007-11-22 Thread Paul Lambert
Magnus Hagander wrote: On Thu, 2007-11-22 at 17:04 +0900, Paul Lambert wrote: OK, W2K3 supports a thing it calls Junctions, which are similar to symlinks - and PG appears to be using that in this case. Crisis averted. I was just going to suggest that. It's a pretty neat feature, but the supp

Re: [GENERAL] Query re disk usage

2007-11-22 Thread Magnus Hagander
On Thu, 2007-11-22 at 17:04 +0900, Paul Lambert wrote: > Paul Lambert wrote: > > 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. > > > > OK, W2K3 supports

Re: [GENERAL] Query re disk usage

2007-11-22 Thread Paul Lambert
Paul Lambert wrote: 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. OK, W2K3 supports a thing it calls Junctions, which are similar to symlinks - and PG appear

Re: [GENERAL] Query re disk usage

2007-11-21 Thread Paul Lambert
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 ar

Re: [GENERAL] Query re disk usage

2007-11-21 Thread Magnus Hagander
On Thu, 2007-11-22 at 15:26 +0900, Paul Lambert wrote: > I'm running PG 8.3beta3 on a W2K3 server. > > I've set up a tablespace on D drive, with PG itself on C drive and > loaded a bunch of data into a database to test. The directory I've > created the tablespace in on D drive grows to 116Mb -

Re: [GENERAL] Query re disk usage

2007-11-21 Thread Paul Lambert
Paul Lambert wrote: I note however, that the pg_database directory on C drive also grows at the same time to 116MB. That was meant to say the pg_tblspc directory. Both directories (my tablespace and pg_tablespace) contain the same set of files - same names and sizes, eg both contain a file

[GENERAL] Query re disk usage

2007-11-21 Thread Paul Lambert
I'm running PG 8.3beta3 on a W2K3 server. I've set up a tablespace on D drive, with PG itself on C drive and loaded a bunch of data into a database to test. The directory I've created the tablespace in on D drive grows to 116Mb - which would be about right for the amount of data I've plugged i