Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Update TIP 9 please

0 views
Skip to first unread message

Simon Riggs

unread,
Nov 14, 2004, 6:31:38 AM11/14/04
to
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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Markus Bertheau

unread,
Nov 14, 2004, 9:37:04 AM11/14/04
to
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 <twa...@bluetwanger.de>


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Robert Treat

unread,
Nov 15, 2004, 11:46:25 AM11/15/04
to
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

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

0 new messages