От: Michael Fuhr
Тема: Re: Nested Loop
Дата: ,
Msg-id: 20070326140549.GA9322@winnie.fuhr.org
(см: обсуждение, исходный текст)
Ответ на: Nested Loop  ("Gauri Kanekar")
Ответы: Re: Nested Loop  ("Gauri Kanekar")
Список: pgsql-performance

Скрыть дерево обсуждения

Nested Loop  ("Gauri Kanekar", )
 Re: Nested Loop  (Michael Fuhr, )
  Re: Nested Loop  ("Gauri Kanekar", )
   Re: Nested Loop  ("Dave Dutcher", )
   Re: Nested Loop  (Ragnar, )
    Re: Nested Loop  ("Gauri Kanekar", )
     Re: Nested Loop  (Ragnar, )

On Mon, Mar 26, 2007 at 05:34:39PM +0530, Gauri Kanekar wrote:
> how to speedup nested loop queries and by which parameters.

Please post a query you're trying to tune and the EXPLAIN ANALYZE
output, as well as any changes you've already made in postgresql.conf
or configuration variables you've set in a particular session.
Without more information we can't give much advice other than to
make sure you're vacuuming and analyzing the tables often enough
to keep them from becoming bloated with dead rows and to keep the
statistics current, and to review a configuration checklist such
as this one:

http://www.powerpostgresql.com/PerfList

--
Michael Fuhr


В списке pgsql-performance по дате сообщения:

От: Ragnar
Дата:
Сообщение: Re: Nested Loop
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] ERROR: out of shared memory