Re: How to post to this mailing list from a web based interface

2021-02-14 Thread Ravi__Krishna
Eventually I found out. It is Nabble service. -- Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: How to post to this mailing list from a web based interface

2021-02-14 Thread Thomas Munro
On Fri, Jan 29, 2021 at 4:27 AM Alvaro Herrera wrote: > On 2021-Jan-28, Ravi Krishna wrote: > > I recollect there use to be a website from where one can reply from web. > > The community does not maintain such a service. > > There used to be a Gmane archive of this list that you could use to > pos

Re: How to post to this mailing list from a web based interface

2021-02-14 Thread Adrian Klaver
On 2/14/21 5:37 PM, Ravi__Krishna wrote: Eventually I found out. It is Nabble service. I would search the --general archives for the problems with using Nabble to post. Short version, you will get answers quicker(or at all) by not using it. -- Sent from: https://www.postgresql-archive.

Re: Why is Postgres only using 8 cores for partitioned count? [Parallel Append]

2021-02-14 Thread Gavin Flower
On 14/02/2021 22:47, David Rowley wrote: On Sun, 14 Feb 2021 at 13:15, Seamus Abshere wrote: The comment from Robert says: (src/backend/optimizer/path/allpaths.c) /* * If the use of parallel append is permitted, always request at least * lo

Re: Why is Postgres only using 8 cores for partitioned count? [Parallel Append]

2021-02-14 Thread Seamus Abshere
Hi David, That is a great suggestion, except my partitions are foreign tables. I wonder if I could figure out a single empty partition that’s just a normal table... but I’m using hash partitioning, so I think I would lose a modulus. Best, Seamus -- Seamus Abshere, SCEA +1 (608) 772-0696 https:

700% faster (was: Re: Why is Postgres only using 8 cores for partitioned count? [Parallel append])

2021-02-14 Thread Seamus Abshere
hi, Apologies for the self-replying, but I made it 700% faster by compiling from source and forcing the parallel_workers from 7 to 96. If this weren't a partitioned table, I could just do `alter table test_3pd_cstore_partitioned set (parallel_workers = 96)` - but that isn't currently supported

Re: Why is Postgres only using 8 cores for partitioned count? [Parallel Append]

2021-02-14 Thread David Rowley
On Sun, 14 Feb 2021 at 13:15, Seamus Abshere wrote: > The comment from Robert says: (src/backend/optimizer/path/allpaths.c) > > /* > * If the use of parallel append is permitted, always request > at least > * log2(# of children) workers. > > In my