postgresql-9.5 Archives

Aggregated column causes full table scan even though the right index is present

By adminPosted on March 25, 2023

Question : I have a query where I want to fetch the first few rows from the table datasets ordered […]

By adminPosted on March 22, 2023

Question : I installed pgbouncer and I setup the pgbouncer.ini and my application can connect to pgbouncer and make queries. […]

By adminPosted on March 18, 2023

Question : The following query on a foreign takes about 5 seconds to execute on 3.2 million rows: SELECT x.”IncidentTypeCode”, […]

By adminPosted on March 17, 2023

Question : I have a very large table (around 140M rows) with five columns: CREATE TABLE IF NOT EXISTS citations […]

By adminPosted on March 11, 2023

Question : My problem is same as the one asked in below topic Streaming Replication Failover – how to point […]

By adminPosted on March 8, 2023

Question : I am currently working on moving data from one database to another in PostgreSQL. I am studying python […]

By adminPosted on March 7, 2023

Question : There’s a script at the end that will fully create the schema and populate it with sample data. […]

By adminPosted on March 5, 2023

Question : We have an UPSERT feature achieved through on conflict do set. How can I set the values conditionally […]

By adminPosted on February 25, 2023

Question : I have three tables (A, B and C) with various data regarding mining facilities in them. But only […]

By adminPosted on February 24, 2023

Question : I’ve created a number of tables in my public schema. Occasionally, I need to run a seeder to […]