Re: REPOST: Nested loops row estimates always too high

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема Re: REPOST: Nested loops row estimates always too high
Дата
Msg-id 1190778646.5402.16.camel@neuromancer.home.net
обсуждение исходный текст
Ответ на Re: REPOST: Nested loops row estimates always too high  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Ответы Re: REPOST: Nested loops row estimates always too high  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Tue, 2007-09-25 at 11:31 +0200, Steinar H. Gunderson wrote:
> On Tue, Sep 25, 2007 at 12:53:55AM -0400, Carlo Stonebanks wrote:
> > My problem is that I think that SRF's are causing my problems. The SRF's
> > gets an automatic row estimate of 1000 rows. Add a condition to it, the
> > planner guesses 333 rows. Even at 333, this is an overestimate of the number
> > of rows returned.
> >
> > I'm really disappointed - SRF's are a great way to place the enterprise's
> > db-centric business logic at the server.
>
> Fortunately, in 8.3 you can attach a row estimate to the function yourself,
> which should most likely fix your problem. Look forward to the first beta :-)
>

Where can I erad more about this new "feature"?

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

Предыдущее
От: "Bryan Murphy"
Дата:
Сообщение: Re: query io stats and finding a slow query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: REPOST: Nested loops row estimates always too high