Re: postgres 7.4 at 100%

От: Bruno Wolff III
Тема: Re: postgres 7.4 at 100%
Дата: ,
Msg-id: 20040629132813.GA28041@wolff.to
(см: обсуждение, исходный текст)
Ответ на: Re: postgres 7.4 at 100%  (Chris Cheston)
Список: pgsql-performance

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

postgres 7.4 at 100%  (Chris Cheston, )
 Re: postgres 7.4 at 100%  (Richard Huxton, )
  Re: postgres 7.4 at 100%  (Chris Cheston, )
 Re: postgres 7.4 at 100%  (Doug McNaught, )
  Re: postgres 7.4 at 100%  ("Joshua D. Drake", )
   Re: postgres 7.4 at 100%  (Chris Cheston, )
    Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
     Re: postgres 7.4 at 100%  (Frank Knobbe, )
      Re: postgres 7.4 at 100%  (Tom Lane, )
       Re: postgres 7.4 at 100%  (Josh Berkus, )
        Re: postgres 7.4 at 100%  (Chris Cheston, )
         Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
          Re: postgres 7.4 at 100%  (Chris Cheston, )
           Re: postgres 7.4 at 100%  (Bruno Wolff III, )
           Re: postgres 7.4 at 100%  ("Gavin M. Roy", )
            Re: postgres 7.4 at 100%  (Chris Cheston, )
             Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
              Re: postgres 7.4 at 100%  (Chris Cheston, )
               Re: postgres 7.4 at 100%  (Christopher Kings-Lynne, )
         Re: postgres 7.4 at 100%  (Tom Lane, )
      Re: postgres 7.4 at 100%  (Josh Berkus, )
       Re: postgres 7.4 at 100%  (Frank Knobbe, )
        Re: postgres 7.4 at 100%  (Josh Berkus, )
 Re: postgres 7.4 at 100%  (Duane Lee - EGOVX, )

On Tue, Jun 29, 2004 at 01:37:30 -0700,
  Chris Cheston <> wrote:
> ok i just vacuumed it and it's taking slightly longer now to execute
> (only about 8 ms longer, to around 701 ms).
>
> Not using indexes for calllogs(from)... should I?  The values for
> calllogs(from) are not unique (sorry if I'm misunderstanding your
> point).

If you are hoping for some other plan than a sequential scan through
all of the records you are going to need an index. You can have an
index on a column (or function) that isn't unique for all rows.


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

От: "Bill"
Дата:
Сообщение: Re: Query performance
От: Richard Huxton
Дата:
Сообщение: Re: Query performance