Hi,
Is there a version dependency when using logical replication? Do both
sides have to be running the same major version? Or is it a wire
protocol that will be backwards compatible in future releases?
I sincerely hope it's the latter so that users of this aren't forced
to upgrade all of their in
Hi,
Can someone take a look at this blog post?
https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json
Can Redis really be 16 times faster than Postgres? Surely Postgres can get
closer to the raw speed of the hardware than 1 order of magnitude?
Thanks,
Colin
Hi,
I have a customer approaching transaction wraparound, about 3million
transaction IDs away at the moment.
Postgres 9.5 (yes, I know...)
Somewhat mislead by the message to vacuum the database in single user
mode, they are now in single user mode and are running "vacuum full"
on the "worst" data
Hi,
I have a customer approaching transaction wraparound, about 3million
transaction IDs away at the moment.
Postgres 9.5 (yes, I know...)
Somewhat mislead by the message to vacuum the database in single user
mode, they are now in single user mode and are running "vacuum full"
on the "worst" data
Hi,
This works in Postgres 15:
pg15> create function json_test(out value text, out json jsonb)
returns record
language sql
as
$$
select null::text, null::jsonb;
$$
;
CREATE FUNCTION
pg15> select * from json_test();
┌───┬──┐
│ value │ json │
├───┼──┤
│ │ │
└───┴───
