11 мар. 2022 г. · I'm using PostgreSQL 12.8 and I have two tables: CREATE TABLE s ( id BIGINT PRIMARY KEY, type VARCHAR, active BOOLEAN ); With more than 230k rows.

8 мая 2013 г. · I'm doing queries where I want to get the students by their entryyear (and sometimes by their sat and/or act scores), then get all of those students associated ...

15 июл. 2020 г. · I'm trying to create a view that does distinct on an indexed column that isn't unique and the performance is very bad.

7 апр. 2021 г. · I am looking for ways to improve the above query primarily to achieve better performance considering primarily the size of the envisaged dataset.

23 февр. 2015 г. · With 3 sets th query runs quite fast, but as soon as one adds another 3-4 sets the query performance degrades to ~30-40 secs.

22 окт. 2015 г. · It generally won't make any difference, because they should result in the same query plan. At least, an EXISTS subquery will; ...

6 февр. 2024 г. · The view being joined is fairly complex, and relies on some sub-views as well, but when executed in isolation it's very fast.

20 февр. 2013 г. · The slowness of the second query is caused by sequential scan on view1 which is a view containing three UNIONS and about three JOINS in each UNION.

25 апр. 2019 г. · PostgreSQL query taking too long · 3 · Improving Subquery performance in Postgres · 1 · Query extremely slow because of sub-queries · 1 · Query ...

27 мар. 2015 г. · I think that the join expressed in the SELECT clause is being executed even for the 100000 rows you are not including in the final data set.