2806
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
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 ⬇️
There should be add data sources button somewhere in IDE. Choose host as localhost, port 5432, user postgres, database postgres and connect.
Читать полностью…
Some here knows how to add a tag in a xml like this ‘teléfono’ but when make in postgresl the xml i got this <campoAdicional nombre="Teléfono">(02) 222-2242</campoAdicional>
Читать полностью…
Mind sharing an EXPLAIN plan on e.g. explain.dalibo.com ?
Читать полностью…
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 ⬇️
Yes, not in this style.
It's strange I don't see the HR posts requirements pinned, but there are some anyway.
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
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()
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?
Start with Ora2Pg documentation.
And CyberTec has an Oracle_FDW based migration tool.
I've posted some notes/lessons learned in the past.
After my big client goes live, I will write a serious article for CyberTec on the complete process, etc.
Expect to have issues with Packages, Package Variables, and Temp Tables.
Also, read the article "Don't Do This"...
https://wiki.postgresql.org/wiki/Don't_Do_This
How did you install PostgreSQL?
On what OS did you install it?
If some of your utilities don't understand the &xE9; symbol - it's a happy coincidence that you discovered it so early. It's best to fix the bugs of incorrect xml handling.
Thereafter, you can move on to finding out what changes the symbols (or why they are like that). Tools, versions, operating systems, exact code, debugging, etc.
First, the QUERY helps.
An Explain Plan REALLY Helps.
Otherwise it's like asking a mechanic why your car makes a sound, without him seeing the car, and you not telling him more than the COLOR of the car... Or the exact sound.
Hi all,
Our Postgresql DBS is on RDS, and the tables are designed with character and timestamp datatype columns only. The indexes are created on the character columns only. We reduced to character length from 255 to closed max columns length too.While executing the functions, the execution time differs now & then even after doing regular maintenance like a vacuum. We tried to increase the work_mem parameters & tested it, but the execution time hasn't reduced below 8 secs. Please let me know if you have your valuable ideas to tune with anything.
Thanks in advance!
Cross posting from pgconf group (hopefully rose bot doesn't ban me). My database comedy blog
https://drunkdba.medium.com/schr%C3%B6dingers-backups-a-quantum-backup-tale-087a7dd2dd58?source=friends_link&sk=123f283f4a7d397cd77549c6892e8f43
Job Openings - Immediate Hiring!
We are currently hiring for the following permanent work-from-office/client positions (no work from home allowed):
1. Oracle DBA
• Locations: Noida & Mumbai
2. Oracle Apps DBA
• Locations: Noida & Gurgaon
3. MSSQL DBA
• Locations: Noida & Mumbai (Lower Parel)
4. Postgres/MySQL DBA
• Location: Hyderabad
• Note: PostgreSQL should be primary, but the candidate must also know MySQL as secondary.
If you or anyone you know is interested, please share your resume and contact details. Feel free to pass this message along!
Hello everyone,
Is it any way to migrate all schema in single run by using ora2pg tool?
I still don't get the problem.
SELECT sender,"text",read,"date"
WHERE user IN (183,132)
ORDER BY "read" DESC, "date" DESC;
"read" ASC (not sure right now), but what in the world would you use max() or GROUP BY for?
Читать полностью…
I can't imagine a schema that would possibly result in this...
Are you storing two "read" values?
If I use group by, it will duplicate rows because the read and timestamp have different values
Читать полностью…
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?