Search Postgresql Archives

Re: Best Approach for Swapping a Table with its Copy

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

Subject: Re: Best Approach for Swapping a Table with its Copy
From: Greg Sabino Mullane <htamfids@xxxxxxxxx>
Date: Fri, 14 Feb 2025 10:14:45 -0500
Cc: Marcelo Fernandes <marcefern7@xxxxxxxxx>, Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, Dominique Devienne <ddevienne@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <ebdbbe8d0b905e797d4bb10157e44f9fe6ecb389.camel@cybertec.at>
References: <CAM2F1VP9nn0F6fSjbmhJCNSjv-dbAJcAytZ2HkTkZ0dGYZvxrw@mail.gmail.com> <8ac6a1dd-db82-4ea7-8186-0c354d79049f@aklaver.com> <CAM2F1VOOn1izCrtcrDx4YUtCY-H64Vj5yvN5H1Lhk8kCY+_W6Q@mail.gmail.com> <9fa75099-1ee9-43de-ac6e-945841b184eb@aklaver.com> <CAM2F1VONo8M9gcybhmf8-CdmRUC2QrFGZkZLYF-+uLZuhRKaxQ@mail.gmail.com> <22406cdf-83f5-4b98-b07e-7827afe97f93@aklaver.com> <CAM2F1VMdDSxLhccn=0pXriJrR6a7Oe9Kir1DB_0pW1v88bsvCg@mail.gmail.com> <CAKAnmmJ04kH_gWR+cOFWD0h63RDck1k6hqQYH8K30-cfCvtO_Q@mail.gmail.com> <CAFCRh-9xC0CXKM2GTQBfjYY5GQx29Uit+fY5PpBFTvX927YC8w@mail.gmail.com> <94e1205e-8ddf-403b-8477-02d7939f2905@aklaver.com> <CAM2F1VMApyPvdA4ERoF7Fob6CXimgOWMKC1vayO5OQa3TtJAFQ@mail.gmail.com> <ebdbbe8d0b905e797d4bb10157e44f9fe6ecb389.camel@cybertec.at>

On Fri, Feb 14, 2025 at 12:41 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:

Moreover, you have to make sure to send out invalidation messages so that every session that caches statistics or
execution plans for the tables discards them.

Hmm...is that really necessary? Because if so, there is no direct SQL-level way to do that I am aware of, so we are back to a C extension. Or just restarting the cluster :)

Cheers,

Greg

Crunchy Data - https://www.crunchydata.com

Enterprise Postgres Software Products & Tech Support

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

References:
- Best Approach for Swapping a Table with its Copy
  - From: Marcelo Fernandes
- Re: Best Approach for Swapping a Table with its Copy
  - From: Adrian Klaver
- Re: Best Approach for Swapping a Table with its Copy
  - From: Marcelo Fernandes
- Re: Best Approach for Swapping a Table with its Copy
  - From: Adrian Klaver
- Re: Best Approach for Swapping a Table with its Copy
  - From: Marcelo Fernandes
- Re: Best Approach for Swapping a Table with its Copy
  - From: Adrian Klaver
- Re: Best Approach for Swapping a Table with its Copy
  - From: Marcelo Fernandes
- Re: Best Approach for Swapping a Table with its Copy
  - From: Greg Sabino Mullane
- Re: Best Approach for Swapping a Table with its Copy
  - From: Dominique Devienne
- Re: Best Approach for Swapping a Table with its Copy
  - From: Adrian Klaver
- Re: Best Approach for Swapping a Table with its Copy
  - From: Marcelo Fernandes
- Re: Best Approach for Swapping a Table with its Copy
  - From: Laurenz Albe

Prev by Date: Re: Best Approach for Swapping a Table with its Copy
Next by Date: Re: Best Approach for Swapping a Table with its Copy
Previous by thread: Re: Best Approach for Swapping a Table with its Copy
Next by thread: Re: Best Approach for Swapping a Table with its Copy
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]