Today is my third day at the Postgres Conf in Silicon Valley. After seeing a huge interest of the attendees to Postgres as a vector database, I decided to put together a curated list of hands-on videos. The videos were produced earlier this year. I followed the hands-on approach by building real stuff. Enjoy, if this topic sounds relevant: submitted by /u/dmagda7817 [visit reddit] [comments ..read more

Hallo i may be stupid but i Googeld now for 3 Hours and cant finde a solution. I want to have 2 ubuntu22.04 Servers that run PostgreSQL Server1 (Master) Server2 (Passiv) Server 1 Replicates on Server 2 (I use Keepalaive so that when Server 1 is down the Database is still availabel) Now to my Problem : When the virtual IP shifts to Server to becuase Server 1 os offline I canot Insert into the Databse on Server 2. the error massage is cannot execute create table in read-only transaction Switching the Virtual addres works after a bit of work Here the guid i used https://www.linkedin.com/pulse/po ..read more

Hello PostgreSQL community, We at Xinnor have been working on optimizing the performance of PostgreSQL databases, especially in virtual environments. We built a high-performance storage solution with Kioxia PCIe5 NVMe drives, motherboard by Supermicro and our RAID engine. I thought it might be of interest to this community. Have you tried any similar solutions? It would be great to learn more about your experience as well. More details in our blog post - https://xinnor.io/blog/high-performance-storage-solution-for-postgresql-database-in-virtual-environment-boosted-by-xiraid-engine-and-kioxia ..read more

Excited to share our latest project, pgvector-remote, with you all! pgvector-remote is an extension designed to effortlessly incorporate remote vector stores, like Pinecone, into pgvector. With pgvector-remote, harnessing the power of a remote (Pinecone) index becomes as easy as utilizing ivfflat or hnsw. Why pgvector-remote? Simplifies integration of memory-intensive vector indexes like Pinecone into standard database servers. Addresses critical feature gaps in pgvector, such as metadata filtering for AI applications. Hides the complexity of maintaining and synchronizing vector stores from ..read more

Hey everyone. I've worked on many projects where users need access to the data hosted in the Postgres DB for whatever reason (monitor utilization, issues, etc). I also spent a lot of time trying to automate analysis and reports using the data in Postgres Seeing what AI could do, I decided to put this together and wanted to see if you are open to providing feedback on the approach and if this is something you find useful to help you solve problems It's available at https://raia.live https://reddit.com/link/1c7etjl/video/ts6xp3p90bvc1/player submitted by /u/raia-live [visit reddit] [comments ..read more

Is there a simple, non-complex pgpool configuration for 1 write-server that has multiple read-only replicas? My python app should hit the 1 pgpool server that splits the writes over to 1, while spreading reads across the read-replicants. Heimdall is pricy. pgbounce/etc appear focused on the pooling/performance, while pgpool is talked about being useful for splitting reads vs writes. I'm trying to avoid putting the logic into the client side (django db router) or any packages that appear to do that. submitted by /u/joej [visit reddit] [comments ..read more

I have three date columns, and I want to return which of the three columns contain the earliest date in them. I can find the earliest date easily with least(), but how can I show in my output what column it came from as well? Quick example table below   User ID User Added Date User Order Date User Acquired Date 123 01-01-2021 02-02-2022 03-03-2023 456 10-10-1999 08-08-2001 07-07-1997   I would like to return from this the following User ID Earliest Date Date Value 123 01-01-2021 User Added Date 456 07-07-1997 User Acquired Date submitted by /u/holymacaroniba ..read more

submitted by /u/Logical_Skill_ [visit reddit] [comments ..read more

submitted by /u/vladmihalceacom [visit reddit] [comments ..read more

Curt Kolovson kicked off the second day at the Postgres conference in Silicon Valley by sharing the story of his contribution to the most hated feature of Postgres and thoughts/progress on the temporal data support in the database. submitted by /u/dmagda7817 [visit reddit] [comments ..read more