Re: [HACKERS] Allow pg_dumpall to work without pg_authid

then it is ok. I can understand. Regards, Sachin On Wed, Mar 15, 2017 at 6:49 PM, Stephen Frost <sfr...@snowman.net> wrote: > Greetings, > > * Sachin Kotwal (kotsac...@gmail.com) wrote: > > Can we have backpatch this patch to PostgreSQL 9.6 and earlier releases ? > > No. Th

Re: [HACKERS] Allow pg_dumpall to work without pg_authid

subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Thanks and Regards, Sachin Kotwal

Re: [HACKERS] Why postgres take RowExclusiveLock on all partition

locking in partition scenario, then it is fine. We can consider this is limitation of PostgreSQL or any other RDBMS system. Regards, Sachin On Fri, Sep 16, 2016 at 7:41 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Sachin Kotwal <kotsac...@gmail.com> writes: > > Does it relea

Re: [HACKERS] Why postgres take RowExclusiveLock on all partition

. If will be happy we will be able to reduce locking in above scenario. Regards, Sachin On Fri, Sep 16, 2016 at 7:16 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Sachin Kotwal <kotsac...@gmail.com> writes: > > In another Terminal : > > > postgres=# select locktype, database::reg

Re: [HACKERS] Why postgres take RowExclusiveLock on all partition

6 at 6:20 PM, Ashutosh Bapat < ashutosh.ba...@enterprisedb.com> wrote: > On Fri, Sep 16, 2016 at 4:31 PM, Sachin Kotwal <kotsac...@gmail.com> > wrote: > > Hi Hackers, > > > > > > I checked if there is update transaction on master table involved in > &

[HACKERS] Why postgres take RowExclusiveLock on all partition

is resides? Feel free to ask if any further information is required . -- Thanks and Regards, Sachin Kotwal

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

ers \ / | pg_fdw(conn=100, diff pg instance on diff machine) | Hope i will test this scenario in detail once i get time and good hardware. If some one test this scenario please let me know. Thanks and regards, Sachin Kotwal On Thu, Jun 30, 2016 at 4:03 AM, Craig Ringer

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

Hi, On Wed, Jun 29, 2016 at 6:29 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > On 29 June 2016 at 18:47, Sachin Kotwal <kotsac...@gmail.com> wrote: > > >> I am testing pgbench with more than 100 connections. >> also set max_connection in postgresql.co

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

th max_connection = 200 in postgresql.conf >> and pgbench witn -c 180/190/200 >> > > Please reply. >> > > Please send precise information instead of expecting people to guess... > > -- > Fabien > -- Thanks and Regards, Sachin Kotwal

[HACKERS] pgbench unable to scale beyond 100 concurrent connections

tested it with max_connection = 200 in postgresql.conf and pgbench witn -c 180/190/200 Please reply. -- Thanks and Regards, Sachin Kotwal

Re: [HACKERS] Template for commit messages

s going to be any more accurate? > > Sincerely, > > JD > > >> > > -- > Command Prompt, Inc. http://the.postgres.company/ > +1-503-667-4564 > PostgreSQL Centered full stack support, consulting and development. > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Thanks and Regards, Sachin Kotwal

Re: [HACKERS] WAL replay bugs

and Regards, Sachin Kotwal NTT-DATA-OSS Center (Pune) -- View this message in context: http://postgresql.1045698.n5.nabble.com/WAL-replay-bugs-tp5799053p5799512.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org