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: 200508251408.55390.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novice
Saranya,

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

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:
effective_cache_size
random_page_cost

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

-- 
--Josh

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-2014 The PostgreSQL Global Development Group