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
(см: обсуждение, исходный текст)
Ответ на: Re: Using more tha one index per table  (Craig James)
Ответы: Re: Using more tha one index per table  (Craig James)
Список: pgsql-performance

Скрыть дерево обсуждения

Using more tha one index per table  (Elias Ghanem, )
 Re: Using more tha one index per table  ("A. Kretschmer", )
  Re: Using more tha one index per table  (Rob Wultsch, )
   Re: Using more tha one index per table  (Scott Marlowe, )
 Re: Using more tha one index per table  (Scott Marlowe, )
 Re: Using more tha one index per table  (Andy Colson, )
 Re: Using more tha one index per table  (Greg Smith, )
  Re: Using more tha one index per table  (Craig Ringer, )
   Re: Using more tha one index per table  (Craig James, )
    Re: Using more tha one index per table  (Greg Smith, )
     Re: Using more tha one index per table  (Steve Atkins, )
      Re: Using more tha one index per table  (Greg Smith, )
       Re: Using more tha one index per table  (Steve Atkins, )
       Re: Using more tha one index per table  (Richard Huxton, )
        Re: Using more tha one index per table  (Rob Wultsch, )
     Re: Using more tha one index per table  (Craig James, )
     Re: Using more tha one index per table  (Dimitri Fontaine, )
    Re: Using more tha one index per table  (Torsten Zühlsdorff, )
     Re: Using more tha one index per table  (Craig James, )
      Re: Using more tha one index per table  (Torsten Zühlsdorff, )
       Re: Using more tha one index per table  (Craig James, )

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 по дате сообщения:

От: Torsten Zühlsdorff
Дата:
Сообщение: Re: Using more tha one index per table
От: Joshua Tolley
Дата:
Сообщение: Re: Pooling in Core WAS: Need help in performance tuning.