Question

Does PostgreSQL self join ignore indexes?

score 2.3k · Answer 1 · 2025-01-07 20:06:27

2.3k

Views

Does PostgreSQL self join ignore indexes?

Published on 07 January 2025 at 20:06

score 769 · Answer 2 · 2025-01-07 20:06:53

769

Views

Configuring Merge Join in PostgreSQL

Published on 07 January 2025 at 20:06

score 269 · Answer 3 · 2025-01-07 20:09:08

269

Views

GIN index not used for small table when 0 rows returned

Published on 07 January 2025 at 20:09

score 5.7k · Answer 4 · 2025-01-07 20:11:05

5.7k

Views

PostgreSQL not using index on a filtered multiple sort query

Published on 07 January 2025 at 20:11

score 108 · Answer 5 · 2025-01-07 20:06:53

108

Views

PostgreSQL Performance Worsening

Published on 07 January 2025 at 20:06

score 9.1k · Answer 6 · 2025-01-07 20:06:25

9.1k

Views

How to speed up the query in PostgreSQL

Published on 07 January 2025 at 20:06

score 14.5k · Answer 7 · 2025-01-02 09:11:30

14.5k

Views

Row level security(RLS) performance is significantly slower in postgres.

Published on 02 January 2025 at 09:11

score 179 · Answer 8 · 2025-01-07 20:11:04

179

Views

Postgresql becomes unresponsible when new index value is added

Published on 07 January 2025 at 20:11

score 719 · Answer 9 · 2025-01-07 20:07:43

719

Views

Postgresql, slow SELECT query in postgres table

Published on 07 January 2025 at 20:07

score 4.5k · Answer 10 · 2025-01-07 20:07:41

4.5k

Views

Alter Table Set Statistics requires table lock

Published on 07 January 2025 at 20:07

score 1.4k · Answer 11 · 2025-01-07 20:09:45

1.4k

Views

Most efficient way to query for lat-long rectangle in SQL

Published on 07 January 2025 at 20:09

score 2.1k · Answer 12 · 2025-01-07 20:08:09

2.1k

Views

PostgreSQL join fetch all rows in table, too slow

Published on 07 January 2025 at 20:08

score 6k · Answer 13 · 2025-01-03 22:21:56

6k

Views

Postgres uses wrong index

Published on 03 January 2025 at 22:21

score 110 · Answer 14 · 2025-01-07 20:09:07

110

Views

Why does 'WHERE col = int' make this PostgreSQL query slow?

Published on 07 January 2025 at 20:09

score 1k · Answer 15 · 2025-01-07 20:05:49

1k

Views

Postgres chooses a bad query plan

Published on 07 January 2025 at 20:05

score 674 · Answer 16 · 2025-01-07 20:13:34

674

Views

How can I get all the rows in a huge table sorted efficiently using SQLAlchemy and PostgreSQL?

Published on 07 January 2025 at 20:13

score 231 · Answer 17 · 2025-01-07 20:11:03

231

Views

Heroku Postgres query speed sanity check. Am I doing it wrong?

Published on 07 January 2025 at 20:11

score 3.2k · Answer 18 · 2025-01-07 20:07:41

3.2k

Views

Analyzing performance of an insert in postgres

Published on 07 January 2025 at 20:07

score 59 · Answer 19 · 2025-01-07 20:05:25

59

Views

postgres query optimisation

Published on 07 January 2025 at 20:05

score 45 · Answer 20 · 2025-01-07 20:08:08

45

Views

Best way of using Django queryset where JSONField != {}

Published on 07 January 2025 at 20:08

List Question

Does PostgreSQL self join ignore indexes?

Configuring Merge Join in PostgreSQL

GIN index not used for small table when 0 rows returned

PostgreSQL not using index on a filtered multiple sort query

PostgreSQL Performance Worsening

How to speed up the query in PostgreSQL

Row level security(RLS) performance is significantly slower in postgres.

Postgresql becomes unresponsible when new index value is added

Postgresql, slow SELECT query in postgres table

Alter Table Set Statistics requires table lock

Most efficient way to query for lat-long rectangle in SQL

PostgreSQL join fetch all rows in table, too slow

Postgres uses wrong index

Why does 'WHERE col = int' make this PostgreSQL query slow?

Postgres chooses a bad query plan

How can I get all the rows in a huge table sorted efficiently using SQLAlchemy and PostgreSQL?

Heroku Postgres query speed sanity check. Am I doing it wrong?

Analyzing performance of an insert in postgres

postgres query optimisation

Best way of using Django queryset where JSONField != {}

Trending Questions

Popular # Hahtags

Popular Questions