Would be nice if you can attach explain plan of course, explain analyze is not
going to work if server is crashing.
Regards,
Virendra
From: Cory Tucker [mailto:cory.tuc...@gmail.com]
Sent: Wednesday, March 28, 2018 5:49 PM
To: pgsql-gene...@postgresql.org
Subject: Query Crashes PG 10.3 using pa
.
From: Kumar, Virendra
Sent: Wednesday, March 28, 2018 5:57 PM
To: Cory Tucker; pgsql-gene...@postgresql.org
Subject: RE: Query Crashes PG 10.3 using partitions, works on 9.6
Would be nice if you can attach explain plan of course, explain analyze is not
going to work if server is crashing.
Regards
Hi There,
Is anybody aware of how to encrypt bind password for ldap authentication in
pg_hba.conf. Anonymous bind is disabled in our organization so we have to use
bind ID and password but to keep them as plaintext in pg_hba.conf defeat
security purposes. We want to either encrypt it or authent
Thank you Peter!
I figured that out.
Regards,
Virendra
-Original Message-
From: Peter Eisentraut [mailto:peter.eisentr...@2ndquadrant.com]
Sent: Wednesday, April 04, 2018 8:41 PM
To: Kumar, Virendra; pgsql-gene...@postgresql.org
Subject: Re: LDAP Bind Password
On 4/3/18 16:12, Kumar
Does this apply to SELECT calls as well or only for DMLs.
I am planning to use postgres_fdw but if it is going by one row at a time there
will be a lot of round trip and defeat the purpose.
Regards,
Virendra.
From: Don Seiler [mailto:d...@seiler.us]
Sent: Wednesday, April 11, 2018 2:53 PM
To: Ad
Hi,
I have as scenario where one of our developer created a table loaded huge
amount of data and since then auto vacuum is not letting us do alter table for
disabling it, even truncate and drop are locked. Is there anything we can do to
prevent this and disable autovacuum at least.
Regards,
V
Hi Community,
We are facing some problem with using psqlODBC driver connecting to
postgres-xl. Whom should we redirect our queries?
Basically, when using load balancing across cluster we are seeing below error
and the process is failing:
--
"AutomationException: Underlying DBMS error[ERROR: prep
Thank you Adrian!
Hi ODBC Project Team,
Would you mind looking into this please?
Regards,
Virendra.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Tuesday, September 04, 2018 9:47 AM
To: Kumar, Virendra; pgsql-general@lists.postgresql.org
Subject: Re
You can consider outside DB encryption which is less of worry for performance
and data at rest will be encrypted.
Regards,
Virendra
-Original Message-
From: ROS Didier [mailto:didier@edf.fr]
Sent: Sunday, October 07, 2018 2:33 PM
To: fola...@peoplecall.com
Cc: pavel.steh...@gmail.com;
Hello Team,
Can somebody redirect me to document which lists all possible value of command
tag in instance log of PostgreSQL instance.
Regards,
Virendra
This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AN
:55 PM
To: Kumar, Virendra; pgsql-general@lists.postgresql.org
Subject: Re: Possible Values of Command Tag in PG Log file
On 7/18/19 12:58 PM, Kumar, Virendra wrote:
> Hello Team,
>
> Can somebody redirect me to document which lists all possible value of
> command tag in instance log o
Here is simple query, I am running via function call. This statement runs fine
as SQL but when put in function as plpgsql it failes with error below, when I
ran second times in same session it succeeds:
--
product_master_fdw=> \set VERBOSITY verbose
product_master_fdw=>
select sddf_update.tps_upd
| typacl
-+--+--++--+-+-++--+--+--+-+--+--+---++--
---+--+---++--+++-+---+--+--+---++
(0 rows)
Regards,
Virendra
From: Kumar, Virendra
Sent:
On 9/3/19 1:56 PM, Kumar, Virendra wrote:
>>> Here is simple query, I am running via function call. This statement
>>> runs fine as SQL but when put in function as plpgsql it failes with
>>> error below, when I ran second times in same session it succeeds:
>
>>
er.ext_class_prod_class_map_prcm" CONSTRAINT
"prcm_fk_pres_class_code" FOREIGN KEY (pres_id) REFERENCES
product_owner.external_sys_class_code_pres(pres_id) DEFERRABLE NOT VALID
TABLE "product_owner.ext_class_prod_cvg_map_prcv" CONSTRAINT
"prcv_fk_pre
I concord.
Why VACUUM when there is no update or deletes.
Regards,
Virendra
From: Ron [mailto:ronljohnso...@gmail.com]
Sent: Tuesday, November 06, 2018 12:20 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: why select count(*) consumes wal logs
On 11/06/2018 11:12 AM, Michael Nolan wrote:
We are using Postgers-XL based on PostgreSQL 10.5 on RHEL7. We have an extreme
case of one query which running in 4 hour 45 mins and 33 seconds with Nested
Loops Join vs 2.5 seconds when we disable enable_nestloop. The query is given
below. I would be happy to share more information if required.
02 PM
To: Kumar, Virendra
Cc: pgsql-general@lists.postgresql.org
Subject: Re: NL Join vs Merge Join - 5 hours vs 2 seconds
"Kumar, Virendra" writes:
> We are using Postgers-XL based on PostgreSQL 10.5 on RHEL7. We have an
> extreme case of one query which running in 4 hour 45 min
Hi,
I am going through ldap authentication documents in PostgreSQL and found that
we can specify multiple ldap servers but sure how. I have put two entries in
double quotes like below:
--
hostall all0.0.0.0/0 ldap
ldapserver="server1.com server2
=> /lib64/libkeyutils.so.1 (0x7f9a7b309000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x7f9a7b0e2000)
libpcre.so.1 => /lib64/libpcre.so.1 (0x7f9a7ae8)
Regards,
Virendra
-Original Message-
From: Alvaro Herrera [mailto:alvhe...@2ndqua
Comman separated doesn't work as well.
Regards,
Virendra
-Original Message-
From: Alvaro Herrera [mailto:alvhe...@2ndquadrant.com]
Sent: Thursday, December 20, 2018 2:21 PM
To: Kumar, Virendra
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Multiple LDAP Servers for
[postgres@xxx ~]$ rpm -qf /lib64/libldap-2.4.so.2
openldap-2.4.44-20.el7.x86_64
Regards,
Virendra
-Original Message-
From: Alvaro Herrera [mailto:alvhe...@2ndquadrant.com]
Sent: Thursday, December 20, 2018 2:01 PM
To: Kumar, Virendra
Cc: pgsql-general@lists.postgresql.org
Subject: Re
,
Virendra
-Original Message-
From: Alvaro Herrera [mailto:alvhe...@2ndquadrant.com]
Sent: Thursday, December 20, 2018 3:25 PM
To: Kumar, Virendra
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Multiple LDAP Servers for ldap Authentication
On 2018-Dec-20, Kumar, Virendra wrote:
> Com
[mailto:alvhe...@2ndquadrant.com]
Sent: Thursday, December 20, 2018 3:25 PM
To: Kumar, Virendra
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Multiple LDAP Servers for ldap Authentication
On 2018-Dec-20, Kumar, Virendra wrote:
> Comman separated doesn't work as well.
Please separate by a com
Hi Chris,
It is better explained if we include an example in the documentation. That will
be self explainatory.
Regards,
Virendra
-Original Message-
From: Christopher Browne [mailto:cbbro...@gmail.com]
Sent: Thursday, December 20, 2018 6:16 PM
To: Kumar, Virendra
Cc: Alvaro
Hi Mark,
Can you try setting up stats target for school_id column and analyze table and
see where it takes, something like:
--
ALTER table common_student ALTER COLUMN school_id SET STATISTICS 1;
ANALYZE common_stundent;
Regards,
Virendra
From: Mark [mailto:mwchamb...@gmail.com]
Sent: Friday
Team,
Is there a subscription URL we have to subscribe for to know about Minor
Version Release and Security Updates when they are released for public usage.
Regards,
Virendra
This message is intended only for the use of the addressee and may contain
information
Hello Team,
We are looking for some audit information about user creation. We need a few
audit fields which we did not find in PostgreSQL. I would be happy if someone
help us in finding these details. Besically we need information about:
1. User creation date
2. Last Password chang
, Virendra
Cc: pgsql-general@lists.postgresql.org
Subject: Re: User Details for PostgreSQL
On Thu, 9 May 2019 at 16:43, Kumar, Virendra
mailto:virendra.ku...@guycarp.com>> wrote:
Hello Team,
We are looking for some audit information about user creation. We need a few
audit fields which we did no
Team,
Can you please let us know if Sub-partitions are supported in PGSQL
(declarative partitions) 10.1. If yes can it be list-list partitions. We have a
situation where a table is very big having around 2 billion rows and is
growing. We want to use partitions but not sure if sub-partitions are
Can somebody tell us how many partitions are good number without impacting the
performance. We are hearing around a thousand, is that a limit. Do we have plan
to increase the number of partitions for a table. We would appreciate if
somebody can help us with this?
Regards,
Virendra
___
value a partition.
Regards,
Virendra
From: Andrew Staller [mailto:and...@timescale.com]
Sent: Tuesday, January 09, 2018 12:15 PM
To: Rakesh Kumar
Cc: Kumar, Virendra; pgsql-gene...@postgresql.org
Subject: Re: How Many Partitions are Good Performing
This is the blog post that Rakesh referenced:
https
For test I created two tables with 7800 partitions each and joining them sees
performance bottleneck. It is taking 5 seconds planning time. Please see
attached plan.
Regards,
Virendra
-Original Message-
From: pinker [mailto:pin...@onet.eu]
Sent: Wednesday, January 10, 2018 12:07 PM
To:
Hi Gurus,
We have 4-node cluster (1 master and 3 hot standby). We are using pgpool as
load balancer. We have an observation where if application requests for 3
connections, pgpool connects to all 4 servers and I see 3 connections on each
of them. I was expecting it have a total of 3 connection
Attached is config file.
[pgpool@usdf23v0550 ~]$ pgpool -v
pgpool-II version 3.7.1 (amefuriboshi)
Reading should go to all nodes.
Regards,
Virendra
From: Glauco Torres [mailto:torres.gla...@gmail.com]
Sent: Monday, January 29, 2018 11:53 AM
To: Kumar, Virendra
Cc: pgsql-gene...@postgresql.org
36 matches
Mail list logo
