| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Wiwwo Staff <wiwwo(at)wiwwo(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Tablespace OID, database OID, relfilenode |
| Date: | 2023-01-17 15:01:30 |
| Message-ID: | 1505292e2bedcfcf13e9334f686946742b9db7f2.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2023-01-17 at 15:48 +0100, Wiwwo Staff wrote:
> Quick and to the point:
>
> If i execute
> select pg_relation_filepath('pgbench_accounts');
>
> I get
> pg_relation_filepath
> ----------------------
> base/5/16398
>
> where "base" is tablespace, but not tablespace OID, nor tablespace name.
> How do I link it to get from "base" the tablespace OID?
>
> Or, in other words, given table pgbench_accounts, how do I get tablespace OID,
> database OID and relfilenode so that I can use this info to filter output of pg_waldump?
The tablespace OID is 1663, since "base" is the default tablespace "pg_default".
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | HECTOR INGERTO | 2023-01-17 15:22:02 | RE: Are ZFS snapshots unsafe when PGSQL is spreading through multiple zpools? |
| Previous Message | Wiwwo Staff | 2023-01-17 14:48:58 | Tablespace OID, database OID, relfilenode |