Skip site navigation (1) Skip section navigation (2)

Re: query optimization

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: Saranya Sivakumar <sarlavk(at)yahoo(dot)com>
Subject: Re: query optimization
Date: 2005-08-25 21:08:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

1) Please format the query you want help optimising.  Proper query format 
is like:
SELECT columns
FROM table JOIN table
	JOIN table
WHERE condition

2) Please run EXPLAIN ANALYZE rather than just EXPLAIN, and please run it 
on the query you actually want help with (the query you gave us and the 
explain output do not match).

3) Please give us the following settings from your PostgreSQL.conf:

After that, we'll probably be able to help you!


Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-novice by date

Next:From: Michael FuhrDate: 2005-08-25 21:43:56
Subject: Re: Superuser can execute but not view function
Previous:From: Saranya SivakumarDate: 2005-08-25 20:25:01
Subject: query optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group