Re: select on 1milion register = 6s

От: Alvaro Herrera
Тема: Re: select on 1milion register = 6s
Дата: ,
Msg-id: 20070729180220.GA4051@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: Re: select on 1milion register = 6s  ("Scott Marlowe")
Список: pgsql-performance

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

select on 1milion register = 6s  ("Bruno Rodrigues Siqueira", )
 Re: select on 1milion register = 6s  (Craig James, )
  RES: select on 1milion register = 6s  ("Bruno Rodrigues Siqueira", )
   Re: RES: select on 1milion register = 6s  (Ragnar, )
    RES: RES: select on 1milion register = 6s  ("Bruno Rodrigues Siqueira", )
    Re: RES: select on 1milion register = 6s  (Decibel!, )
     RES: RES: select on 1milion register = 6s  ("Bruno Rodrigues Siqueira", )
      Re: RES: RES: select on 1milion register = 6s  (Decibel!, )
     Re: RES: RES: select on 1milion register = 6s  (Decibel!, )
   Re: select on 1milion register = 6s  ("Scott Marlowe", )
    Re: select on 1milion register = 6s  (Alvaro Herrera, )
    Re: select on 1milion register = 6s  (Jan Dittmer, )
 Re: select on 1milion register = 6s  (Hervé Piedvache, )
  RES: select on 1milion register = 6s  ("Bruno Rodrigues Siqueira", )
  RES: select on 1milion register = 6s  ("Bruno Rodrigues Siqueira", )

Scott Marlowe wrote:
> On 7/28/07, Bruno Rodrigues Siqueira <> wrote:

> > stats_start_collector = off
> > #stats_command_string = off
> > #stats_block_level = off
> > #stats_row_level = off
> > #stats_reset_on_server_start = off
>
> I think you need stats_row_level on for autovacuum, but I'm not 100% sure.

That's correct (of course you need "start_collector" on as well).  Most
likely, autovacuum is not even running.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

От: Alvaro Herrera
Дата:
Сообщение: Re: select on 1milion register = 6s
От: Decibel!
Дата:
Сообщение: Re: RES: RES: select on 1milion register = 6s