Re: BUG #13852: SQL Select Slow Issues

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: BUG #13852: SQL Select Slow Issues
Дата
Msg-id n6ljqk$qia$1@ger.gmane.org
обсуждение исходный текст
Ответ на BUG #13852: SQL Select Slow Issues  (eugeneymail@ymail.com)
Список 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 по дате отправления:

Предыдущее
От: "Shulgin, Oleksandr"
Дата:
Сообщение: Re: BUG #13852: SQL Select Slow Issues
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #13594: pg_ctl.exe redirects stderr to Windows Events Log if stderr is redirected to pipe