PostgreSQL

21 Oct 2024 19:04

If I use group by, it will duplicate rows because the read and timestamp have different values

PostgreSQL

21 Oct 2024 19:01

Somebody please Help me here.
I Run some software on some pc with a RAM of 2GB.
The software runs on MySQL Database.
Whenever I open the the application,it appears frozen,still.that is, you cant navigate through it.
I suspect This is due to small RAM size of 2gb.
What trick can i use to run the software on this laptop,With a ram of 2gb?

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

21 Oct 2024 19:04

Hi all! Can someone help me with this?

I have a Chat table that contains messages and if it was read or not. Each message is a row. I'm working on the conversation screen. Each user has one conversation. I want to SELECT sender, name, read, timestamp but without duplicates, ordering by read = false and timestamp DESC. How can I do it with good performance?

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