Відео

where can i find the part 2 Sir?

Is there any possibility of auto partitioning in postresql itself? I want to create partition by range based on createdAt, whenever a new entry added to main table, the postgrSQL itself need to check whether partition exist for that createdAt value, if not it needs to create on its own. Is it possible now with postgres 16?

Perrfect

very good questions. Very well answered by him, its all about his experience and the situations he faced.

hello . ı have a 3 node. my patroni is active but.3 node replica mode. ıf ı look patroni status; INFO : WAİTİNG LEADER BOOSTRAP. PLEASE HELP ME

Hi, i have a question, i have an case which on my table it has 14gb toast size while the data only consume 1.2Gb, and yes there are 2 Column storing a lot of text (payload) . I already perform vacuum and vacuum full on that table but the toast is still there. My question is 1. Is it normal having 14 gb toast size while the actual data onlly take 1.2 gb 2. If this aint normal, how to fix this? Thank you!

Thanks for putting this together!

Promo-SM

In the PaaS AWS, Aurora will take the control

Buying RI doesn’t give you the guarantee you will have a reserved capacity…

Hi sir, how to do troubleshoot if conversions didn't happen

I'am issuing same etcdctl command to get kay-value, but nothing returning. What can be problem

Interesting topic, thanks for the presentation.

Hi can you share the query that you have used either in github

Can you please paste the script here? that polls for the primary node continuously?

Your explanation simple yet superb , Kindly share the document

00:05 Passwords may appear in Postgres logs when creating new roles or users. 00:34 Postgres logs can expose sensitive passwords. 01:06 Reset PG start statements and create a test role 01:46 Logging all or ddl statements can expose passwords in Postgres logs. 02:25 Sensitive passwords appearing in Postgres logs 03:00 Passwords appearing in PG statements is a security issue 03:30 Mitigate the risk of storing plain text passwords in Postgres logs 04:08 Postgres logs can store plain text passwords.

Do i have to take a downtime during switchover if i randomly wanted to switch one node and remove it

Hi can you you make a vedio for pgpool ssl configuration.

🎯 Key Takeaways for quick navigation: 03:35 🤖 Patroni handles node failures and failovers internally. 04:19 🛡️ A demonstration of simulating a primary node failure and leader election in Patroni. 07:28 💼 How to perform a planned leader switch-over in Patroni. 09:22 🤖 Introduction to etcd commands for Patroni configuration and monitoring. Made with HARPA AI

🎯 Key Takeaways for quick navigation: 00:01 🤖 Introduction to Patroni and its reliance on DCS (etcd) - Patroni is a Python-based bot used in PostgreSQL clustering. - Patroni relies on a Distributed Configuration Store (DCS), like etcd, for coordination and leader election. 03:35 🛡️ Overview of Node Failure and Failover in Patroni - When the primary node fails, a new leader election process is triggered. - Replicas check the status of other nodes, and the one with the least replication lag becomes the new leader. 04:19 💼 Demonstration of Node Failure and Leader Election - The TTL of the leader key counts down, and the first replica to acquire it becomes the new leader. - Demonstrates the leader election process when the primary node fails. 07:28 🛡️ Planned Leader Switch Over in Patroni - Shows how to manually switch the leader in a planned maintenance scenario. - Node 1 is promoted as the new leader using the "switch over" option. 09:22 🤖 Introduction to etcd Commands - Introduction to etcd commands used for Patroni configuration and monitoring. - Demonstrates commands like "get leader key value," "get configuration," and "get member details." Made with HARPA AI

thanks

where is part2?

So if a table is 1TB size then we will see 1024 files in disk? Isn’t that too difficult to maintain?

where is part2?

How do we know about this seminars that you are conducting online ??

Very interesting

Where is the document ?

Very useful examples, thanks for the demo!

This is a great video. Thanks for this.

hi Does the clone database also replicated the data from the source after its creation or its a database from snapshot at that point?

thanks 😉

Can we change this segment value? Does it have any effect on performance? Cuz postgresql is operating on 8kb pages by default

Very informative, thank you for sharing this.