PostgreSQL

22 Oct 2024 09:42

Hello everyone,

Is it any way to migrate all schema in single run by using ora2pg tool?

PostgreSQL

21 Oct 2024 20:05

I still don't get the problem.

SELECT sender,"text",read,"date"
WHERE user IN (183,132)
ORDER BY "read" DESC, "date" DESC;

PostgreSQL

21 Oct 2024 19:57

I can't imagine a schema that would possibly result in this...
Are you storing two "read" values?

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

22 Oct 2024 07:43

Hey folks a python dev here

I have been assigned a data engineer responsibilities recently… asked to take up the complete responsibility of the DB …(postgresql)
So u get it right I have not been exposed to db that much … like how an optimised ER should be and etc
So I am not sure what all concepts I should be aware of and should have a good grip on
I know sql but the basic stuff like functions and methods, sub queries, join
Familiar with normalisation and views

Please help me with what all other topics should I be having a grip over and any resources to practice sql questions

Also I am finding it difficult to run some commands like ‘connect’ over Dbeaver

PostgreSQL

21 Oct 2024 19:59

Example:
Sender text read date
183 Hi True 10/10/2024 09:03
183 hello false 10/10/2024 10:03

But I already made it work using Max() and every()

PostgreSQL

21 Oct 2024 19:23

Very wrong group if it's MySQL it's running

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...