|
Not the planner but you can hint the query as in this example select /*+ ordered use_hash(code1)*/ * from table_1; Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Wed, 2 Jan 2008 00:15:14 +1030 > From: pgsql@xxxxxxxxxx > To: regmeplease@xxxxxxxxx > CC: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Hinting the planner > > 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/ i’m is proud to present Cause Effect, a series about real people making a difference. Learn more |
