Re: SQL select query becomes slow when using limit (with no offset)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: SQL select query becomes slow when using limit (with no offset)
Дата
Msg-id 603c8f070908070553p10f2021fl9c94c74b9152b19d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQL select query becomes slow when using limit (with no offset)  (Kees van Dieren <keesvandieren@gmail.com>)
Ответы Re: SQL select query becomes slow when using limit (with no offset)  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
On Fri, Aug 7, 2009 at 4:00 AM, Kees van Dieren<keesvandieren@gmail.com> wrote:
> Would it get attention if I submit this to
> http://www.postgresql.org/support/submitbug ? (in fact it is not really a
> bug, but an improvement request).

I think that many of the people who read that mailing list also read
this one, including, critically, Tom Lane, and you're not the first
person to run into a problem caused by lack of cross-column
statistics.  I don't think you're going to get very far by submitting
this as a bug.  There are already several people interested in this
problem, but as most of us don't get paid to hack on PostgreSQL, it's
a question of finding enough round tuits; this is not an easy thing to
fix.

If you are sufficiently bothered by this problem that you are willing
to pay someone to fix it for you, there are several companies with
whom you can contract to get this feature developed and committed for
the next release of PostgreSQL.

...Robert

В списке pgsql-performance по дате отправления:

Предыдущее
От: Kees van Dieren
Дата:
Сообщение: Re: SQL select query becomes slow when using limit (with no offset)
Следующее
От: Michael Nacos
Дата:
Сообщение: Re: postgresql and syslog