Re: stange optimizer results

Поиск
Список
Период
Сортировка
От Peter T. Brown
Тема Re: stange optimizer results
Дата
Msg-id 1037914453.1784.45.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: stange optimizer results  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: stange optimizer results  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-performance
trouble is that this SQL is being automatically created by my
object-relational mapping software and I can't easily customize it. Is
there any other way I can force Postgres to do the most efficient thing?



On Thu, 2002-11-21 at 10:35, Stephan Szabo wrote:
>
> On Thu, 21 Nov 2002, Stephan Szabo wrote:
>
> > On 21 Nov 2002, Peter T. Brown wrote:
> >
> > > Hello--
> > >
> > > Attached is a file containing two SQL queries. The first take
> > > prohibitively long to complete because, according to EXPLAIN, it ignore
> > > two very important indexes. The second SQL query seems almost identical
> > > to the first but runs very fast because, according to EXPLAIN, it does
> > > uses all the indexes appropriately.
> > >
> > > Can someone please explain to me what the difference is here? Or if
> > > there is something I can do with my indexes to make the first query run
> > > like the second?
> >
> > It doesn't take into account that in general a=b, b=constant implies
> > a=constant.
> >
> >  Perhaps if you used explicit join syntax for visitor joining
> > visitorextra it might help.  Like doing:
> >  FROM visitor inner join visitorextra on (...)
> >   left outer join ...
>
> Sent this too quickly.  It probably won't make it use an index on
> vistorextra, but it may lower the number of expected rows that it's going
> to be left outer joining so that a nested loop and index scan makes sense.
>
>
--

Peter T. Brown
Director Of Technology
Memetic Systems, Inc.
"Translating Customer Data Into Marketing Action."
206.335.2927
http://www.memeticsystems.com/


В списке pgsql-performance по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: [ADMIN] H/W RAID 5 on slower disks versus no raid on
Следующее
От: Francisco J Reyes
Дата:
Сообщение: ...