Re: Need to find the no. of connections for a database

From: Ravi Krishna <srkrishna(at)gmx(dot)com>
To: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
Cc: Pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need to find the no. of connections for a database
Date: 2020-02-27 12:40:30
Message-ID: D857CD94-CF6E-46F0-A4FA-F820C71AB923@gmx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"If they enter any data, those data also need to be taken into account in this report. "

Pls read on PG's MVCC architecture. In SQLServer, unless you enabled its bad implementation of Snapshot isolation,
you can't achieve the same. So it makes sense there. In PG it is easy to ensure that your report gets a point in time
consistent view of the data.

Trying to mimic one database in another is not a smart way.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ireneusz Pluta/wp.pl 2020-02-27 12:58:34 Re: Need to find the no. of connections for a database
Previous Message sivapostgres@yahoo.com 2020-02-27 11:35:51 Re: Need to find the no. of connections for a database