Re: strange performance regression between 7.4 and 8.1

От: Alvaro Herrera
Тема: Re: strange performance regression between 7.4 and 8.1
Дата: ,
Msg-id: 20070302193319.GA12629@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: strange performance regression between 7.4 and 8.1  (Florian Weimer)
Список: pgsql-performance

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

strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
 Re: strange performance regression between 7.4 and 8.1  ("Joshua D. Drake", )
  Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
   Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
    Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
   Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
    Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
     Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
      Re: strange performance regression between 7.4 and 8.1  (Tom Lane, )
       Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
  Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
   Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
    Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
     Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
      Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
       Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
        Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
         Re: strange performance regression between 7.4 and 8.1  ("Joshua D. Drake", )
          Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
           Re: strange performance regression between 7.4 and 8.1  ("Joshua D. Drake", )
            Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
         Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
          Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
 Re: strange performance regression between 7.4 and 8.1  (Ron, )
 Re: strange performance regression between 7.4 and 8.1  (Florian Weimer, )
  Re: strange performance regression between 7.4 and 8.1  (Carlos Moreno, )
   Re: strange performance regression between 7.4 and 8.1  (Ron, )
  Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
  Re: strange performance regression between 7.4 and 8.1  (Alvaro Herrera, )
 Re: strange performance regression between 7.4 and 8.1  (Ron, )
  Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
   Re: strange performance regression between 7.4 and 8.1  (Scott Marlowe, )
 Re: strange performance regression between 7.4 and 8.1  (Ron, )
  Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
 Re: strange performance regression between 7.4 and 8.1  (Anton Rommerskirchen, )
 Re: strange performance regression between 7.4 and 8.1  (Ron, )
  Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )
   Re: strange performance regression between 7.4 and 8.1  (Guido Neitzer, )
    Re: strange performance regression between 7.4 and 8.1  (Jeff Frost, )
     Re: strange performance regression between 7.4 and 8.1  ("Alex Deucher", )

Florian Weimer escribió:

> Locale settings make a huge difference for sorting and LIKE queries.
> We usually use the C locale and SQL_ASCII encoding, mostly for
> performance reasons.  (Proper UTF-8 can be enforced through
> constraints if necessary.)

Hmm, you are aware of varchar_pattern_ops and related opclasses, right?
That helps for LIKE queries in non-C locales (though you do have to keep
almost-duplicate indexes).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


В списке pgsql-performance по дате сообщения:

От: Josh Berkus
Дата:
Сообщение: Re: Performance Query
От: Tom Lane
Дата:
Сообщение: Re: Performance Query