Question : I have a table transfer_event from which I need to find the latest n entries for a set […]
Tag: postgresql-performance
Why does an alias with a ‘having’ clause not exist in PostgreSQL?
Question : I am trying to calculate distance between two coordinates and fetching some information based on a few conditions. […]
Convert a number to a letter postgresql [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Manually setting most_common_vals in Postgres
Question : I am currently building a system for exploration purposes on top of Postgres. Essentially, this results in queries […]
Why is this IN-clause with subquery materialization slow?
Question : Can someone help me explain why the performance of the two queries are so vastly different? (Setup-Code is […]
Efficient way to insert/update/delete table records from complex query in Postgres 9.x
Question : I have this function which returns a set a records and I need to persist those records into […]
Is pg12 cache used with two SELECT on same table but different fields
Question : Figure a table with fields a, b and c Figure two requests on this table : SELECT a, […]
does using PV and pipe affect perfomance importing database?
Question : I’m importing a database that’s almost 2.5 GB inside a docker postgres container. I wanted to know the […]
Postgres index scan on large table taking a long time
Question : I have a large table (~500M records, 85GB in size) on a PostgreSQL 10.10 database (AWS RDS instance). […]
Is this database fragmentation or something else? What can be done?
Question : I have the table below in PostgreSQL (automagically generated with insertions using Marten): create table mt_doc_order ( id […]