Re: Improving performance of select query

2020-12-14 Thread Muhammad Bilal Jamil
I think you can also increase the query performance by creating indexes? On Mon, 14 Dec 2020 at 11:36, Rob Sargent wrote: > > > > On Dec 14, 2020, at 4:47 AM, Thomas Kellerer wrote: > > > > Karthik Shivashankar schrieb am 14.12.2020 um 12:38: > >> I have a postgres(v9.5) table named customer ho

Database trigger (one server to another)

2022-05-31 Thread Muhammad Bilal Jamil
Hi fellow database engineers, I am currently on a project where i have read only access to a production system (replicated) from where i want to copy data into another schema. Ideally what i want to do is that if for an event happens in the replicated schema (server#1) like something updates, then