2830
English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
You could store & reset the table statistics on a regular basis.
Or use pgBadger with full statement logging.
Or write a patch 😏
Anyone here open to host the next #pgsqlphriday blogging event?
Details: https://www.pgsqlphriday.com/
Or do you have topic ideas?
https://stackoverflow.com/questions/46099743/why-writes-in-a-table-prevent-vacuums-in-another
Is this true?
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!
Hi all, is there any provision in Postgresql to know the number of transactions in all tables in a database for a particular time. Means can we check how many insert/update/delete/select queries executed in each table in a database for a specific time period?
Читать полностью…
Yes 6 months ago, I passed associated and professional for epas and postgres.
Читать полностью…
You're talking about EDB's certification, aren't you?
Читать полностью…
Can anyone confirm if someone has recently completed the PostgreSQL Associate Certification?
Читать полностью…
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.