English speaking PostgreSQL public chat. This group is for discussions on PostgreSQL-related topics and strives to provide best-effort support as well.
https://pages.cs.wisc.edu/~jignesh/publ/SmartSSD.pdf
Looks like they took those SSDs and reimplemented the WHERE
processing part of tuples inthe SSD itself
Apparently, Samsung made some SSDs with "PostgreDB" hardware acceleration, does somebody know what they hell they are on about?
Читать полностью…As long as you are using replication slots for SR and right archive_command, WAL files are not deleted from pg_wal before they are successfully streamed or shipped. However, misconfigurations or lagging replicas can lead to issues, so proactive monitoring is essential
Читать полностью…max_wal_size sets a guideline for checkpoint frequency and WAL recycling, but it is not a hard limit. The actual size of the pg_wal directory may exceed this value under certain circumstances
Читать полностью…is it correct to say that "max_wal_size" is the limit for the pg_wal directory?
Читать полностью…Back door jobs available for freshers and experienced persons
Читать полностью…parmarshyamsinh/getting-started-with-postgresql-a-beginners-guide-bf8d55fb2ef4" rel="nofollow">https://medium.com/@parmarshyamsinh/getting-started-with-postgresql-a-beginners-guide-bf8d55fb2ef4
Читать полностью…Ok,so if Microsoft Server solves the whole headaches around failovers, fencing, ..even new version of Postgresql 17 to solve as well incremental backups, and full restore backup, I should be very calm with such setup that would just work. Are there also some other backup tools that are good,free available and for windows that you would recommend? Postgresql does not yet natively provide differential backup/restore,so I would still need to look for option for that
Читать полностью…Hi, does someone have good experience with deployment of Postgresql with Windows Server? Does the Microsoft's feature of "Failover cluster" helps to solve the matrix of the typical tools, such as Patroni, Repmgr, pg_auto_failover, or this "Failover cluster" feature solves just the equation of shared disk storage failover (for write operation) to eg. Slave B node, when Master A node runs into problem?
I would be glad of any supporting comments? Thank you, Gorazd!
Hi,
I am looking for PostgreSQL developers with 8-10 years experience. Remote job in Bangalore. If you are interested let me know
if you’re not in hurry, it’s on our roadmap
https://neon.tech/docs/security/compliance
(why some “Neon” here? we are open-source Postrges-based cloud serverless, with contributing back to Open Source and Postgres developers in the team)
With a "where" query with only 0.1% match, queries are two times as fast and CPU usage is pretty much none
Читать полностью…I don't know. But I'm sure it's marketing gimmick. 🤷♂️
Читать полностью…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 ⬇️
Hello friends, you know we cannot use pg_lsclusters when patroni enabled. Whats is the best alternative command to get information same as pg_lsclusters? I mean that does cluster online or down, data path, log path, port number and version info together?
Читать полностью…So in case im not using replication slot and i configure my replica like primary_con_info + restore_command I also have to make sure my primary's pg_wal will keep enough wal files?
but if i use the archive command doesn it means that all the WAL files are also copied directly to another directory and can be fetched from there in case replica needs them?
Thanks,
now if i have replication that set as streaming+log shipping (archive command) - do i need to worry about WALs being deleted from pg_wal before streamed or shipped directly to replica?
A soft limit, yes. It *should* not grow above that before a checkpoint is triggered.
Читать полностью…I'd jump at this if it weren't such an obvious scam.. been job hunting for 3 months with no success
Читать полностью…But, of course, we are talking about Microsoft failover cluster, where,if postgres installed on 2 nodes, only one node can serve read/writes, while the other node cannot serve even with reads, correct? So actually, shared storage failover concept with windows build-in feature would not allow to release the master node with some read operations ...
Читать полностью…Patroni, Pgbackrest and Ubuntu combo works so great for me that I don't have to deal with Windows headache.
Читать полностью…I've seen people that swears that they knew an architect from a company that did that with a fine success!
PS Yes, MS fileover cluster is completely orthogonal to postgres replication clustering.
Btw, imho it's much better autofailover that pg_auto_failover and so on.
Also, it might be that the planner just ignores some of the JOINed tables if they aren't relevant to the result with only two columns. Compare the EXPLAIN outputs of both queries.
Читать полностью…If your 2 columns are in the index, no table accesses are necessary, and the sql is very fast....
Читать полностью…