Re: Using more tha one index per table

Поиск
Список
Период
Сортировка
Искать
От
Torsten Zühlsdorff
Тема
Re: Using more tha one index per table
Дата
Msg-id
i2bn0a$12p$1@news.eternal-september.org
Ответ на
Список
Дерево обсуждения
Using more tha one index per table Elias Ghanem <e.ghanem@acteos.com>
Re: Using more tha one index per table "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Using more tha one index per table Rob Wultsch <wultsch@gmail.com>
Re: Using more tha one index per table Scott Marlowe <scott.marlowe@gmail.com>
Re: Using more tha one index per table Andy Colson <andy@squeakycode.net>
Re: Using more tha one index per table Greg Smith <greg@2ndquadrant.com>
Re: Using more tha one index per table Craig Ringer <craig@postnewspapers.com.au>
Re: Using more tha one index per table Craig James <craig_james@emolecules.com>
Re: Using more tha one index per table Greg Smith <greg@2ndquadrant.com>
Re: Using more tha one index per table Craig James <craig_james@emolecules.com>
Re: Using more tha one index per table Steve Atkins <steve@blighty.com>
Re: Using more tha one index per table Greg Smith <greg@2ndquadrant.com>
Re: Using more tha one index per table Richard Huxton <dev@archonet.com>
Re: Using more tha one index per table Rob Wultsch <wultsch@gmail.com>
Re: Using more tha one index per table Steve Atkins <steve@blighty.com>
Re: Using more tha one index per table Dimitri Fontaine <dfontaine@hi-media.com>
Re: Using more tha one index per table Torsten Zühlsdorff <foo@meisterderspiele.de>
Re: Using more tha one index per table Craig James <craig_james@emolecules.com>
Re: Using more tha one index per table Torsten Zühlsdorff <foo@meisterderspiele.de>
Re: Using more tha one index per table Craig James <craig_james@emolecules.com>
Re: Using more tha one index per table Scott Marlowe <scott.marlowe@gmail.com>
Craig James schrieb:

>>>   A useful trick to know is that if you replace the version number
>>> with "current", you'll get to the latest version most of the time
>>> (sometimes the name of the page is changed between versions, too, but
>>> this isn't that frequent).
>>
>> The docs pages could perhaps benefit from an auto-generated note saying:
>>
>> "The current version of Pg is 8.4. This documentation is for version
>> 8.2. Click [here] for documentation on the current version."
>>
>> ... or something to that effect. It'd be a nice (and more user-friendly)
>> alternative to url twiddling when searches reveal docs for an old
>> version, and might help push the /current/ pages up in search rank too.
> 
> In addition, why not use symlinks so that the current version is simply 
> called "current", as in
> 
>    http://www.postgresql.org/docs/current/static/sql-insert.html
> 
> If you google for "postgres insert", you get this:
> 
>   http://www.postgresql.org/docs/8.1/static/sql-insert.html
> 
> The problem is that Google ranks pages based on inbound links, so older 
> versions of Postgres *always* come up before the latest version in page 
> ranking.  

Since 2009 you can deal with this by defining the canonical-version. 
(http://googlewebmastercentral.blogspot.com/2009/02/specify-your-canonical.html)

Greetings from Germany,
Torsten

-- 
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8 
verschiedenen Datenbanksystemen abstrahiert,
Queries von Applikationen trennt und automatisch die Query-Ergebnisse 
auswerten kann.
В списке pgsql-performance по дате отправления
От: Pavel Stehule
Дата:
Сообщение: Re: Execution Plan
От: Joshua Tolley
Дата:
FAQ