BDS
Only using the free v1.0...
Sent from Yahoo Mail on Android
On Sat, 14 Aug 2021 at 2:07, Laura Smith
wrote: ‐‐‐ Original Message ‐‐‐
On Friday, August 13th, 2021 at 12:35 PM, Zahir Lalani
wrote:
> Confidential
>
> Thx Laura
>
> So here is the dilemma - everything in the clo
On 8/13/21 1:36 PM, ourdiaspora wrote:
‐‐‐ Original Message ‐‐‐
On Wednesday, August 11th, 2021 at 3:13 PM, Adrian Klaver
wrote:
Are you using some form of container/VM on the machine for either server?
The machine is a chromebook, GNU/Linux via 'crouton' chroot. Is this the
po
‐‐‐ Original Message ‐‐‐
On Wednesday, August 11th, 2021 at 3:13 PM, Adrian Klaver
wrote:
>
> Are you using some form of container/VM on the machine for either server?
>
The machine is a chromebook, GNU/Linux via 'crouton' chroot. Is this the
potential cause of blockage of port 5432
Em sex., 13 de ago. de 2021 às 11:55, Ram Charan Kallem <
ramcharan.kal...@non.se.com> escreveu:
> Hi,
>
>
>
> We are using Postgres 10 (Single client)and observed that there are
> multiple PostgreSQL Server process are running in background.
>
> Why these additional process are created or is thi
On 8/13/21 3:20 AM, Ram Charan Kallem wrote:
Hi,
We are using Postgres 10 (Single client)and observed that there are
multiple PostgreSQL Server process are running in background.
Why these additional process are created or is this an expected behavior.
Yes. From my Linux machine:
ps ax |
On Fri, 13 Aug 2021 at 21:07, Michael Lewis wrote:
> On Fri, Aug 13, 2021 at 3:02 AM Vijaykumar Jain <
> vijaykumarjain.git...@gmail.com> wrote:
>
>> ... use binary split for large partitions, to avoid large row movements.
>>
>
> Would you expound on this?
>
if we have range partitions based on
On Fri, Aug 13, 2021 at 3:02 AM Vijaykumar Jain <
vijaykumarjain.git...@gmail.com> wrote:
> ... use binary split for large partitions, to avoid large row movements.
>
Would you expound on this?
Hi,
We are using Postgres 10 (Single client)and observed that there are multiple
PostgreSQL Server process are running in background.
Why these additional process are created or is this an expected behavior.
[cid:image001.png@01D7905A.F629F440]
Regards,
RamCharan
‐‐‐ Original Message ‐‐‐
On Friday, August 13th, 2021 at 12:35 PM, Zahir Lalani
wrote:
> Confidential
>
> Thx Laura
>
> So here is the dilemma - everything in the cloud world tends toward
> horizontal scaling. We do that with PG using single master and multiple
> slaves. But we are wr
On Fri, Aug 13, 2021, 5:05 PM Zahir Lalani
wrote:
> Confidential
>
> Thx Laura
>
> So here is the dilemma - everything in the cloud world tends toward
> horizontal scaling. We do that with PG using single master and multiple
> slaves. But we are write heavy and of course the load on the master is
On Fri, Aug 13, 2021 at 11:35:29AM +, Zahir Lalani wrote:
> Confidential
>
> Thx Laura
>
> So here is the dilemma - everything in the cloud world tends toward
> horizontal scaling. We do that with PG using single master and multiple
> slaves. But we are write heavy and of course the load on
Confidential
Thx Laura
So here is the dilemma - everything in the cloud world tends toward horizontal
scaling. We do that with PG using single master and multiple slaves. But we are
write heavy and of course the load on the master is quite high. It does seem
that multi-master has risks (everyo
On Thu, Aug 12, 2021 at 06:20:23PM +0200, Magnus Hagander wrote:
> On Thu, Aug 12, 2021 at 4:38 PM hubert depesz lubaczewski
> wrote:
> >
> > On Thu, Aug 12, 2021 at 11:32:15AM +0200, Magnus Hagander wrote:
> > > Which database are you connected to? If you just want to look at the
> > > global sta
‐‐‐ Original Message ‐‐‐
On Friday, August 13th, 2021 at 9:00 AM, Zahir Lalani
wrote:
> Confidential
>
> Hello all
>
> Does anyone on the list have production experience of using PG in a
> multi-master setup – if so using which tools?
>
> Thx
>
> Zahir
I have sometimes considered it
On Fri, 13 Aug 2021 at 14:13, Pól Ua Laoínecháin wrote:
> Thanks again for your questions - they gave me pause for thought and I
> will try to apply them in future partitioning scenarios. (Unfortunatly
> :-) ) there is no magic number of partitions for, say, a given size of
> table - otherwise it
Dear Ron,
> > Just a quick follow-up - could I script the creation of 1000
> > partitions using bash
> Sure. That's what scripting languages are for.
Thank you so much for your helpful and expansive answer. No wonder
everyone talks about how friendly and welcoming the PostgreSQL
community is!
Hi Vijay, and thanks for replying,
>> I have a 400GB joining table (one SMALLINT and the other INTEGER -
>> Primary Keys on other tables) with 1000 fields on one side and 10M on
>> the other, so 10,000M (or 10Bn) records all told.
> My queries:
>> results with the existing setup? Does it look
Confidential
Hello all
Does anyone on the list have production experience of using PG in a
multi-master setup - if so using which tools?
Thx
Zahir
18 matches
Mail list logo
