Lists: | pgsql-hackers |
---|
From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | what's stored in pg_tblspc |
Date: | 2006-02-13 12:10:42 |
Message-ID: | 5F86E82A-EDD4-4526-B5E0-E5A94F5FED12@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
I am confused, I thought that there were only supposed to be links to
the actual data in pg_tblspc ?
I have a db defined in a tablspace, but in pg_tblspc there is 1.2G of
data corrresponding to it?
Dave
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: what's stored in pg_tblspc |
Date: | 2006-02-13 14:26:59 |
Message-ID: | 28212.1139840819@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> I am confused, I thought that there were only supposed to be links to
> the actual data in pg_tblspc ?
> I have a db defined in a tablspace, but in pg_tblspc there is 1.2G of
> data corrresponding to it?
Are you on a system that has symlinks? Are you sure that whatever tool
you're using to count the space doesn't traverse symlinks?
IIRC, there is a corner case during replay-from-WAL where we'll create
a plain directory under pg_tblspc to substitute for a symlink (if the
symlink isn't there and we don't have the information to recreate it).
I don't believe it's easy to get into that state though.
regards, tom lane
From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: what's stored in pg_tblspc |
Date: | 2006-02-13 16:10:41 |
Message-ID: | 9059C725-CF7C-4D59-B1A6-7EA31F2AB17F@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Tom,
Thanks, this was driver error....
Dave
On 13-Feb-06, at 9:26 AM, Tom Lane wrote:
> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
>> I am confused, I thought that there were only supposed to be links to
>> the actual data in pg_tblspc ?
>
>> I have a db defined in a tablspace, but in pg_tblspc there is 1.2G of
>> data corrresponding to it?
>
> Are you on a system that has symlinks? Are you sure that whatever
> tool
> you're using to count the space doesn't traverse symlinks?
>
> IIRC, there is a corner case during replay-from-WAL where we'll create
> a plain directory under pg_tblspc to substitute for a symlink (if the
> symlink isn't there and we don't have the information to recreate it).
> I don't believe it's easy to get into that state though.
>
> regards, tom lane
>