From: Michael Fuhr <mike@fuhr.org>
To: Gauri Kanekar <meetgaurikanekar@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Nested Loop
Date: Mon, 26 Mar 2007 08:05:49 -0600
Message-ID: <20070326140549.GA9322@winnie.fuhr.org> (raw)
In-Reply-To: <7e4ba9550703260504u6e9402ferd958620c79e9640a@mail.gmail.com>
References: <7e4ba9550703260504u6e9402ferd958620c79e9640a@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mike@fuhr.org, meetgaurikanekar@gmail.com
Subject: Re: Nested Loop
In-Reply-To: <20070326140549.GA9322@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox