query performance after database rename

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: query performance after database rename
Date: 2018-11-21 09:20:31
Message-ID: 441f8b8943b44771b05fa808dbda4eb0@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We have a postgresql cluster with two databases.
We rename (switch) the databases daily (alter database x rename to y;)
The query performance slows down after each renaming.
Question: Why? Does postgresql flush the db-cache?

Thanks,
Markus

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-21 10:00:23 Re: Error while upgrading from 9.5 to 10
Previous Message soumik.bhattacharjee 2018-11-21 09:10:15 RE: Oracle to Postgres-Licensed GUI tool