Обсуждение: Update TIP 9 please

Поиск
Список
Период
Сортировка

Update TIP 9 please

От
Simon Riggs
Дата:
When 8.0 is released, TIP 9 should change from

TIP 9: the planner will ignore your desire to choose an index scan if
your joining column's datatypes do not match

to 

TIP 9: the planner will ignore your desire to choose an index scan if
your joining column's datatypes do not match (upgrade to 8.0!)

We could change this now...

...and add another TIP to encourage people to upgrade...?

-- 
Best Regards, Simon Riggs



Re: Update TIP 9 please

От
Markus Bertheau
Дата:
Who maintains the tips?

В Вск, 14/11/2004 в 11:31 +0000, Simon Riggs пишет:
> When 8.0 is released, TIP 9 should change from
> 
> TIP 9: the planner will ignore your desire to choose an index scan if
> your joining column's datatypes do not match
> 
> to 
> 
> TIP 9: the planner will ignore your desire to choose an index scan if
> your joining column's datatypes do not match (upgrade to 8.0!)
> 
> We could change this now...
> 
> ...and add another TIP to encourage people to upgrade...?
> 
-- 
Markus Bertheau <twanger@bluetwanger.de>



Re: Update TIP 9 please

От
Robert Treat
Дата:
Marc is the one who does the actual updating, though I have it on my
list of things to do when the new release goes out since I sent him a
bunch last time.  I've also been thinking we ought to update tip #7
"don't forget to increase your free space map settings" to something
more general like "be sure to adjust your postgresql.conf settings for
maximum performance. documentation about different settings is located
in the docs under section 3.16.4 'run-time configuration'"

Robert Treat

On Sun, 2004-11-14 at 09:37, Markus Bertheau wrote:
> Who maintains the tips?
>
> В Вск, 14/11/2004 в 11:31 +0000, Simon Riggs пишет:
> > When 8.0 is released, TIP 9 should change from
> >
> > TIP 9: the planner will ignore your desire to choose an index scan if
> > your joining column's datatypes do not match
> >
> > to
> >
> > TIP 9: the planner will ignore your desire to choose an index scan if
> > your joining column's datatypes do not match (upgrade to 8.0!)
> >
> > We could change this now...
> >
> > ...and add another TIP to encourage people to upgrade...?
> >
> --
> Markus Bertheau <twanger@bluetwanger.de>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL