Hi all,
Working with PostgreSQL Logical Replication is just great! It helps a lot
doing real time replication for analytical purposes without using any other
3d party service. Although all these years working as product architect of
reporting i have noted a few requirements which are always a chal
for each one, all ideas are for
publication/subscription.
Στις Τρί 22 Νοε 2022 στις 2:22 μ.μ., ο/η Amit Kapila <
amit.kapil...@gmail.com> έγραψε:
> On Mon, Nov 21, 2022 at 5:05 PM Ashutosh Bapat
> wrote:
> >
> > On Sat, Nov 19, 2022 at 6:47 PM Stavros Koureas
> > wr
:52, ο χρήστης «Stavros Koureas »
> έγραψε:
>
>
> Sure, this can be implemented as a subscription option, and it will cover
> this use case scenario as each subscriber points only to one database.
> I also have some more analytical/reporting use-cases which need additions in
>
rting performance
Στις Τετ 23 Νοε 2022 στις 5:19 π.μ., ο/η Amit Kapila <
amit.kapil...@gmail.com> έγραψε:
> On Wed, Nov 23, 2022 at 1:40 AM Stavros Koureas
> wrote:
> >
> > Reading more carefully what you described, I think you are interested in
> getting something
only the same origin data is
being updated.
Στις Τετ 23 Νοε 2022 στις 1:24 π.μ., ο/η Peter Smith
έγραψε:
> On Wed, Nov 23, 2022 at 7:38 AM Stavros Koureas
> wrote:
> >
> > Reading more carefully what you described, I think you are interested in
> getting something you call o
25 Νοε 2022 στις 12:21 μ.μ., ο/η Ashutosh Bapat <
ashutosh.bapat@gmail.com> έγραψε:
> On Wed, Nov 23, 2022 at 4:54 AM Peter Smith wrote:
> >
> > On Wed, Nov 23, 2022 at 7:38 AM Stavros Koureas
> > wrote:
> > >
> > > Reading more carefully what y
στις 10:16 π.μ., ο/η Peter Smith
έγραψε:
> On Fri, Nov 25, 2022 at 9:43 PM Stavros Koureas
> wrote:
> >
> > Yes, if the property is on the subscription side then it should be
> applied for all the tables that the connected publication is exposing.
> > So if the property
Στις Τρί 29 Νοε 2022 στις 3:27 μ.μ., ο/η Ashutosh Bapat <
ashutosh.bapat@gmail.com> έγραψε:
> That would be too restrictive - not necessarily in your application
> but generally. There could be some tables where consolidating rows
> with same PK from different publishers into a single row in su
uld be quicker rather than joining on a character varying
(plus the rest of the columns).
In addition, discussing with other people and also on Stack
Overflow/DBAExchange I have found that other people think it is a great
enhancement for analytical purposes.
Στις Τετ 30 Νοε 2022 στις 10:39 π.μ.
Working with PostgreSQL Logical Replication is just great! It helps a lot
doing real time replication for analytical purposes without using any other
3d party service. Although all these years working as a product architect
of reporting I have noted a few requirements which are always a challenge
a
10 matches
Mail list logo