Postgres Pro
Downloads
Home   >   mailing lists

query performance after database rename - Mailing list pgsql-admin

From Zwettler Markus (OIZ)
Subject query performance after database rename
Date
Msg-id 441f8b8943b44771b05fa808dbda4eb0@zuerich.ch
Whole thread Raw
Responses Re: query performance after database rename  (srinivas oguri <srinivasoguri7@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Oracle to Postgres-Licensed GUI tool
Next
From: Achilleas Mantzios
Date:
Subject: Re: Error while upgrading from 9.5 to 10