On Fri, Dec 5, 2025 at 11:48 AM Marcos Pegoraro wrote:
> Em sex., 5 de dez. de 2025 às 09:03, Marcos Pegoraro
> escreveu:
>
>> I have a logical replication where I want to replicate only one schema.
>> All worked fine, it copied all tables to subscriber, except one. That
>> table has 8GB and it
On 12/5/25 09:24, Sivaprasad wrote:
Hi all,
I’m happy to share a major update to BISCUIT (Bitmap Indexed Searching
with Comprehensive Union and Intersection Techniques), which has now
evolved from a standalone extension into a full Index Access Method
(IAM) for PostgreSQL.
The appropriate list
Hi all,
I’m happy to share a major update to BISCUIT (Bitmap Indexed Searching
with Comprehensive Union and Intersection Techniques), which has now
evolved from a standalone extension into a full Index Access Method
(IAM) for PostgreSQL.
Since the initial release, BISCUIT has gained a mature arch
Em sex., 5 de dez. de 2025 às 09:03, Marcos Pegoraro
escreveu:
> I have a logical replication where I want to replicate only one schema.
> All worked fine, it copied all tables to subscriber, except one. That
> table has 8GB and it copied 5GB. That copy has been frozen since yesterday,
> as you c
On Fri, 5 Dec 2025, Thiemo Kellner wrote:
Am I missing something?
Thiemo,
Nope. I was the one missing something:
select p.person_nbr, p.company_nbr, max(c.next_contact)
from people as p
inner join contacts as c
on p.person_nbr = c.person_nbr
where c.next_contact >= '2025-11-01'
group b
On Thu, 4 Dec 2025, David G. Johnston wrote:
So:
Select person.*, lastcontact.*
from people
join lateral (select contacts.*
from contacts
where contacts.person_nbr = people.person_nbr
order by last_contact_date
desc limit 1)
as lastcontact on true;
I was giving you a query
Hi
Am I missing something?
select p.person_nbr
,p.company_nbr
,max(c.next_contact) -- the lasted contact in the group
from people as p
inner join contacts as c
on p.contact_id = c.id -- assumed join condition
where c.next_contact >= '2025-11-01'
group
I have a logical replication where I want to replicate only one schema.
This schema has auditing of every customer, so a thousand of tables, one
for each customer
CREATE PUBLICATION pub_a FOR TABLES IN SCHEMA audit;
All worked fine, it copied all tables to subscriber, except one. That table
has 8GB
Rich Shepard wrote:
> select p.person_nbr, p.company_nbr, c.next_contact
> from people as p, contacts as c
> where c.next_contact >= '2025-11-01'
> group by p.person_nbr, p.company_nbr, c.next_contact
> order by p.person_nbr, p.company_nbr, max(c.next_contact);
>
> returns all contacts rather tha
