Re: BUG #13852: SQL Select Slow Issues

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13852: SQL Select Slow Issues
Date: 2016-01-07 11:57:06
Message-ID: n6ljqk$qia$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

eugeneymail(at)ymail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2016-01-07 15:11:08 Re: BUG #13594: pg_ctl.exe redirects stderr to Windows Events Log if stderr is redirected to pipe
Previous Message Shulgin, Oleksandr 2016-01-07 10:28:55 Re: BUG #13852: SQL Select Slow Issues