Hello, my query looks like this: SELECT * FROM free_times WHERE time_start > '2024-03-01'; is it ok to set a index like this: create index i_ft ON free_times(time_start) Or is there a better way/ more performant way to query by timestamp and creating an index ? submitted by /u/Far-Mathematician122 [visit reddit] [comments ..read more

I’m working on a data project and I feel I’m too obsessed with modeling the data at its most accurate form. I feel trapped in a semantic hell where i deconstructed the data too much. The data is relational and I work with postgresql. I mainly want to know about personal experiences of how to mitigate this paralysis analysis and be more pragmatic. submitted by /u/MothWithEyes [visit reddit] [comments ..read more

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

Hi, My understanding is that the replication tools normally rely on the database transaction logs to find the CDC/delta changes(Insert/Update/Delete) for tables and then move those delta changes to the target system/databases. Whatever may be the source database (It might be open source postgres or aws RDS). And never done though, but i am assuming , manually scanning the DB logs must not be easy ones and also might not be given access to DB logs because of security reasons too. Hope my understanding is correct here. Thus, in absence of such replication tool(may be because of the additional c ..read more

I have a postgresql database (main/standby configuration), the database was down for 2 weeks, however, it was receiving traffic duirng that time, but not processing it, now the dataase is up, and the trafic is being processed. There were about 0.2 million messages to process. in the 1st day the database process around 30k messages, in the 2nd day around 20k messages, but now it is processing very slow like 1000 messages at day 3. Now I see the CPU Load is too much as well. submitted by /u/Writer_Sports [visit reddit] [comments ..read more

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

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

Hello r/postgreSQL community! I’m excited to share our latest article titled "Introduction to PostgreSQL Extensions" on Medium, which is a fantastic resource for anyone looking to enhance their PostgreSQL database capabilities. In this guide, we delve into the world of PostgreSQL extensions, a powerful feature that allows users to add new functionalities to their database systems without altering the core database itself. Whether you're new to PostgreSQL or looking to expand your existing knowledge, this article provides a clear and comprehensive introduction to what extensions are available ..read more

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

I am playing with inheritance tables and wanted to see if rows in separate children could share one parent row. I wrote the following script either expecting one row across all three tables or a uniqueness/primary key violation. The result is a single row in each child and two in the parent, as if there were no uniqueness contraint on the primary key. Is this a bug? https://sqlfiddle.com/postgresql/online-compiler?id=f44175e4-93a0-4e19-b659-e693008a3c28 ```sql CREATE TABLE p1 ( p1_id uuid PRIMARY KEY DEFAULT gen_random_uuid(), i_p1 text ); CREATE TABLE c1 ( i_c1 text ) INHERITS (p1); CREATE T ..read more