Search Postgresql Archives

Re: Using CTID system column as a "temporary" primary key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Using CTID system column as a "temporary" primary key
From: Maciek Sakrejda <m.sakrejda@xxxxxxxxx>
Date: Tue, 28 Mar 2023 09:45:48 -0700
Cc: Christophe Pettus <xof@xxxxxxxxxxxx>, Geoff Winkless <pgsqladmin@xxxxxxxx>, pgsql-general <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <DBAP191MB128940FF558474BC6DA80CB7B0889@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
References: <DBAP191MB12891F47802C3674F77BF751B0889@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <CAEzk6feEGHzS_TexvevFmWhsYt7MYhUUEUE54stO7SPNbL_Ypg@mail.gmail.com> <DBAP191MB1289536BFF22FD8BD5FFEC61B0889@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <BDED177C-F85C-4667-A67C-C083DD76A9E2@thebuild.com> <DBAP191MB128940FF558474BC6DA80CB7B0889@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>

Note that VACUUM FULL and CLUSTER can update ctids. I don't believe regular VACUUM can, so you should be safe from autovacuum interfering in this scheme, but the ctid colum documentation [1] states "A primary key should be used to identify logical rows," so this is not exactly intended usage.

Thanks,

Maciek

[1]: https://www.postgresql.org/docs/current/ddl-system-columns.html

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Using CTID system column as a "temporary" primary key
  - From: Sebastien Flaesch
- Re: Using CTID system column as a "temporary" primary key
  - From: Geoff Winkless
- Re: Using CTID system column as a "temporary" primary key
  - From: Sebastien Flaesch
- Re: Using CTID system column as a "temporary" primary key
  - From: Christophe Pettus
- Re: Using CTID system column as a "temporary" primary key
  - From: Sebastien Flaesch

Prev by Date: Re: Cluster table based on grand parent?
Next by Date: Re: Cluster table based on grand parent?
Previous by thread: Re: Using CTID system column as a "temporary" primary key
Next by thread: Re: Using CTID system column as a "temporary" primary key
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]