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
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
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!
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
‐‐‐ 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 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
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 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
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
‐‐‐ 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
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
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?
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 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 |
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
‐‐‐ 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
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
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
18 matches
Mail list logo
