query performance after database rename

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

To: "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: query performance after database rename
From: "Zwettler Markus (OIZ)" <Markus.Zwettler@xxxxxxxxxx>
Date: Wed, 21 Nov 2018 09:20:31 +0000

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

Follow-Ups:
- Re: query performance after database rename
  - From: srinivas oguri

Prev by Date: RE: Oracle to Postgres-Licensed GUI tool
Next by Date: Error while upgrading from 9.5 to 10
Previous by thread: Trigger to create automated range partition table
Next by thread: Re: query performance after database rename
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux