pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: dbadmin@pangburngroup.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql streaming replication
Date: Tue, 28 May 2024 09:23:56 -0600
Message-ID: <0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com> (raw)
In-Reply-To: <b289a9c5-8e0c-09af-8aa9-7b8394e4dba5@pangburngroup.com>
References: <06ab2de0-86d6-426e-4a18-17e0b25553ef@pangburngroup.com>
	<566DFBB0-A057-4069-A1F0-1AEFB38281F5@elevated-dev.com>
	<b289a9c5-8e0c-09af-8aa9-7b8394e4dba5@pangburngroup.com>

> On May 28, 2024, at 9:00 AM, Prasanth <dbadmin@pangburngroup.com> wrote:
> 
> I ran few queries and the recent data seems to be there. Would this cause differences in sorting or are there bigger issues with this difference in glibc libraries?

A "difference" in sorting will literally mean some queries not finding the matching data--because indexes were created under one set of sorting rules, then traversed under a different set of sorting rules.




view thread (8+ messages)  latest in thread

Message-ID: <0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com>
Permalink:  ../0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com/
Also on:    postgresql.org/message-id/0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, dbadmin@pangburngroup.com
  Subject: Re: Postgresql streaming replication
  In-Reply-To: <0B15DA7E-E26C-4B2A-B389-2011C8216007@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox