PostgreSQL

01 Dec 2024 00:54

Wow it's really something. 👍
I change my mind.

PostgreSQL

01 Dec 2024 00:48

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

PostgreSQL

01 Dec 2024 00:32

Apparently, Samsung made some SSDs with "PostgreDB" hardware acceleration, does somebody know what they hell they are on about?

PostgreSQL

28 Nov 2024 10:21

Patronictl and status of patroni service

PostgreSQL

27 Nov 2024 14:52

Yes correct you can fetch them from restore command

PostgreSQL

27 Nov 2024 14:22

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

PostgreSQL

27 Nov 2024 14:13

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

PostgreSQL

27 Nov 2024 14:10

is it correct to say that "max_wal_size" is the limit for the pg_wal directory?

PostgreSQL

27 Nov 2024 03:49

Back door jobs available for freshers and experienced persons

PostgreSQL

25 Nov 2024 06:49

parmarshyamsinh/getting-started-with-postgresql-a-beginners-guide-bf8d55fb2ef4" rel="nofollow">https://medium.com/@parmarshyamsinh/getting-started-with-postgresql-a-beginners-guide-bf8d55fb2ef4

PostgreSQL

25 Nov 2024 06:44

Hi guys new to PostgreSQL how and where to start??

PostgreSQL

24 Nov 2024 19:17

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

PostgreSQL

24 Nov 2024 19:05

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!

PostgreSQL

23 Nov 2024 18:32

Hi,
I am looking for PostgreSQL developers with 8-10 years experience. Remote job in Bangalore. If you are interested let me know

PostgreSQL

23 Nov 2024 17:09

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)

PostgreSQL

01 Dec 2024 00:49

With a "where" query with only 0.1% match, queries are two times as fast and CPU usage is pretty much none

PostgreSQL

01 Dec 2024 00:42

I don't know. But I'm sure it's marketing gimmick. 🤷‍♂️

PostgreSQL

28 Nov 2024 14:00

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

28 Nov 2024 10:10

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?

PostgreSQL

27 Nov 2024 14:24

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?

PostgreSQL

27 Nov 2024 14:15

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?

PostgreSQL

27 Nov 2024 14:12

A soft limit, yes. It *should* not grow above that before a checkpoint is triggered.

PostgreSQL

27 Nov 2024 05:06

I'd jump at this if it weren't such an obvious scam.. been job hunting for 3 months with no success

PostgreSQL

26 Nov 2024 20:35

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

PostgreSQL

25 Nov 2024 06:46

# su - postgres
$ psql

PostgreSQL

24 Nov 2024 23:13

Patroni, Pgbackrest and Ubuntu combo works so great for me that I don't have to deal with Windows headache.

PostgreSQL

24 Nov 2024 19:08

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.

PostgreSQL

23 Nov 2024 18:48

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.

PostgreSQL

23 Nov 2024 17:31

If your 2 columns are in the index, no table accesses are necessary, and the sql is very fast....

PostgreSQL

23 Nov 2024 17:03

HIPAA with postgre and GCP . Kindly help . Newbie