On 2/24/20 11:50 AM, Mani Sankar wrote:
Hi All,
We have recently upgraded our postgres servers from 9.4 version to 11.5
version. Post upgrade we are see delay in authentication.
Issue is when we are using ldaptls=1 the authentication takes 1 second
or greater than that. But if I disable ldap
Hi All,
We have recently upgraded our postgres servers from 9.4 version to 11.5
version. Post upgrade we are see delay in authentication.
Issue is when we are using ldaptls=1 the authentication takes 1 second or
greater than that. But if I disable ldaptls it's getting authenticated
within millise
> IF txnid is real UUID , then you can test the
> https://www.postgresql.org/docs/11/datatype-uuid.html performance> see
> https://stackoverflow.com/questions/29880083/postgresql-uuid-type-performance>
> imho: it should be better.
Sure, thanks Imre
Thanks and Regards,
Ravi Garg
On Sunday,
Hi Justin,
>I didn't hear how large the tables and indexes
>are.+---+--++|
> table_name | pg_relation_size |
>pg_total_relation_size - pg_relation_size
>|+-
On Tue, Feb 18, 2020 at 1:10 PM Nagaraj Raj wrote:
>
> Hi Merlin,
>
> Its configured high value for max_conn, but active and idle session have
> never crossed the count 50.
>
> DB Size: 20 GB
> Table size: 30MB
> RAM: 16GB
> vC: 4
>
>
> yes, its view earlier I posted and here is there query plann
