Reg Me Please wrote:
Hello all.
I have some tables that contain exactly 1 row and that I use for searches with
JOIN.
Does it make any sense to hint the planner about this?
If so, how can I send such hints to it?
You don't give hints to the planner.
The planner does use statistics gathered from an ANALYZE to generate the
best plan, so if you haven't analyzed your db you will not likely get
the best plans.
see
http://www.postgresql.org/docs/8.2/interactive/sql-analyze.html
and
http://www.postgresql.org/docs/8.2/interactive/sql-vacuum.html
also
http://www.postgresql.org/docs/8.2/interactive/maintenance.html
can explain these tasks in more detail.
If this is insufficient then you can also look at your config file.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
