Re: BUG #13852: SQL Select Slow Issues - Mailing list pgsql-bugs

From Thomas Kellerer
Subject Re: BUG #13852: SQL Select Slow Issues
Date
Msg-id n6ljqk$qia$1@ger.gmane.org
Whole thread Raw
In response to BUG #13852: SQL Select Slow Issues  (eugeneymail@ymail.com)
List pgsql-bugs
eugeneymail@ymail.com schrieb am 06.01.2016 um 21:42:
> Starting with the quote from
> https://wiki.postgresql.org/wiki/Slow_Query_Questions
> “In any given week, some 50% of the questions on #postgresql IRC and 75% on
> pgsql-performance are requests for help with a slow query.”
>
> Count Distinct Compared on Top 4 SQL Databases
> https://www.periscopedata.com/blog/count-distinct-in-mysql-postgres-sql-server-and-oracle.html
>
> Select * is very slow
> http://postgresql.nabble.com/Select-is-very-slow-td3254568.html
>
> postgresql simple select is slow
> http://stackoverflow.com/questions/9019797/postgresql-simple-select-is-slow
>
> Slow select - PostgreSQL
> http://stackoverflow.com/questions/18508866/slow-select-postgresql
>
> PosgreSQL: very slow select on a single table with no joins
> http://dba.stackexchange.com/questions/73677/posgresql-very-slow-select-on-a-single-table-with-no-joins
>
> postgresql simple select is slow
> http://stackoverflow.com/questions/9019797/postgresql-simple-select-is-slow
>
> PostgreSQL queries slower than before?
>
> http://serverfault.com/questions/644980/postgresql-queries-slower-than-before
>
> Very slow column count on large Postgres tabls
> http://www.heidisql.com/forum.php?t=17959

That list does not prove anything.
You will find just as many "slow query questions" for any other DBMS.

And they probably make up at least 50% of all questions for any other DBMS as well.

pgsql-bugs by date:

Previous
From: "Shulgin, Oleksandr"
Date:
Subject: Re: BUG #13852: SQL Select Slow Issues
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #13594: pg_ctl.exe redirects stderr to Windows Events Log if stderr is redirected to pipe