| Lists: | pgsql-hackers |
|---|
| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Update TIP 9 please |
| Date: | 2004-11-14 11:31:38 |
| Message-ID: | 1100431898.2950.181.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| From: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Update TIP 9 please |
| Date: | 2004-11-14 14:37:04 |
| Message-ID: | 1100443024.3321.0.camel@fc3 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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(at)bluetwanger(dot)de>
| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Update TIP 9 please |
| Date: | 2004-11-15 16:46:25 |
| Message-ID: | 1100537186.5507.145.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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(at)bluetwanger(dot)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