On 5/8/24 08:24, Daniel McKenzie wrote:
It's running both (in docker containers) and also quite a few more
docker containers running various .NET applications.
I think what you found is that the r7a.medium instance is not capable
enough to do all that it is asked without introducing lag under
It's running both (in docker containers) and also quite a few more docker
containers running various .NET applications.
Daniel McKenzie
Software Developer
Office: +1 403.910.5927 x 251
Mobile: +44 7712 159045
Website: www.curvedental.com
*Curve Dental Confidentiality Notice*
This message is inte
We have found two things that appear to resolve the problem -
* Using a more powerful EC2 instance. We can reproduce the issue with
a r7a.medium instance but not with a r7a.large EC2 instance.
* Changing the Postgres synchronous_commit parameter from "on" to
"off". We cannot repro
On Wed, 2024-05-08 at 00:20 +, bugge...@riseup.net wrote:
> I heard PGSQL can act like MSSQL behaviour so I'm trying to migrating
> tables to try it myself, but I really have hard time to migrating them.
I think you have heard about Babelfish (https://babelfishpg.org/).
It is a modified versio
Hello!
In the following setup:
DROP DOMAIN IF EXISTS uint64 CASCADE;
DROP TABLE IF EXISTS demo;
CREATE DOMAIN uint64 AS NUMERIC(20, 0);
CREATE TABLE demo(key uint64);
INSERT INTO demo SELECT g FROM generate_series(1, 1000) g;
I would like to change the type of "key" column to NUMERIC(40, 0)
Hi,
On 5/8/24 11:17, Daniel McKenzie wrote:
> We have a .NET application which subscribes to a logical replication slot
> using wal2json. The purpose of the application is to publish events to AWS
> SQS. We are required to first "enrich" these events by querying the
> database.
>
> We have found
We have a .NET application which subscribes to a logical replication slot
using wal2json. The purpose of the application is to publish events to AWS
SQS. We are required to first "enrich" these events by querying the
database.
We have found that these queries will often find old data (i.e. the dat
