PostgreSQL

21 Oct 2024 05:14

Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.

- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong

⬇️ Press the button down here ⬇️

PostgreSQL

19 Oct 2024 22:29

https://learn.microsoft.com/en-us/azure/dms/

PostgreSQL

19 Oct 2024 19:09

Hi all
Anyone has done Postgres migration from single server to flexible in azure

PostgreSQL

19 Oct 2024 14:58

Hi! I want to learn how postgres works internally. Can anyone share me a book or any articles?

PostgreSQL

18 Oct 2024 18:26

Hello
I learn Postgresql on Datacamp and i want telegram and instagram channels to strengthen my knowledge in it.
If you have any channels like that send me DM.
Thanks

PostgreSQL

17 Oct 2024 09:55

Or you can exclude indexes during restore :) they will be valid in the catalog.

PostgreSQL

17 Oct 2024 09:54

So in wal-g you can have handful of inconsistencies: restore table, but not a foreign-key-table etc.

PostgreSQL

17 Oct 2024 09:52

It’s not there yet. In wal-g you can restore only several tables.
Backrest allows you to exclude databases.

PostgreSQL

17 Oct 2024 08:54

Can you suggest any solution to retrieve the data faster, tried key value pair indexing for json, don't see any improvement

PostgreSQL

17 Oct 2024 08:47

This was just an example, there is one row with 3000 loads

PostgreSQL

17 Oct 2024 08:47

That isn't huge by all means...

PostgreSQL

17 Oct 2024 08:26

It is very dangerous and I don't like it

PostgreSQL

17 Oct 2024 08:23

Nope. It would be too costly to have wal-g features in basebackup.
What exactly is wrong with current design? Don’t you like that oid-relfilenode map?

PostgreSQL

17 Oct 2024 08:15

We are not crazy. We are ordinary people. Our feature is misdesigned, that's why it is crazy

PostgreSQL

17 Oct 2024 07:34

Zero change of being adapted by anyone except us.
It is an disadvantage

PostgreSQL

20 Oct 2024 13:53

Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.

- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong

⬇️ Press the button down here ⬇️

PostgreSQL

19 Oct 2024 22:26

This two links are really good
https://postgrespro.com/community/books/internals
https://www.interdb.jp/pg/

PostgreSQL

19 Oct 2024 15:06

PostgreSQL 14 internals is very very useful

PostgreSQL

18 Oct 2024 18:41

This channel seems like a good stat to me 😏

PostgreSQL

17 Oct 2024 20:35

Hello and welcome to this chat. Here we discuss PostgreSQL and provide best-effort voluntary support on Postgresql issues.
If you have any question, try asking kindly, including log files, error descriptions and perhaps what you're trying to do.

- 🚫 photos and screenshots
- 🚫 spam and offtopic
- ✅ questions with log files and clear explanation of what's gone wrong

⬇️ Press the button down here ⬇️

PostgreSQL

17 Oct 2024 09:54

Ah, that was about tables, nod databases. OK, got it.

PostgreSQL

17 Oct 2024 09:53

Basebackup does not allow you partial restore at all.

PostgreSQL

17 Oct 2024 09:46

i dont know, i never use it

PostgreSQL

17 Oct 2024 08:48

Are pgbackrest and pgprobackup implementations that much different?

PostgreSQL

17 Oct 2024 08:47

Except there 2 mio more of those array elements 😏

PostgreSQL

17 Oct 2024 08:38

Hi, I need help with my 'json_playload' column as datatype JSONB with the remaining all other columns, the table has only 200 records but the json_ payload column is huge. Hence while retrieving the data from table using select * query, it is taking longer for output. 1 example for the json_ payload column : {"SchemaName":"dbo","ChangedTableName":"StmData","NumberOfRows":2,"Batches":1,"Lsn":"0x000010620000335E0007","TranEndTimeUTC":"2024-09-17T16:23:43.803"},
{"SchemaName":"dbo","ChangedTableName":"StmData","NumberOfRows":2,"Batches":1,"Lsn":"0x00001062000033C10007","TranEndTimeUTC":"2024-09-17T16:24:27.597"},
{"SchemaName":"dbo","ChangedTableName":"StmData","NumberOfRows":2,"Batches":1,"Lsn":"0x00001062000033C40005","TranEndTimeUTC":"2024-09-17T16:24:27.597"}]

PostgreSQL

17 Oct 2024 08:24

I don't like obsolete relations in pg_class after partial restore

PostgreSQL

17 Oct 2024 08:19

Firstly, write a proposal to pgsql hackers with intended design for pg_basebackup

PostgreSQL

17 Oct 2024 07:36

I bet there must be someone more crazy

PostgreSQL

17 Oct 2024 07:33

yeah, I mean are there any disadvantages of being "too crazy"?