Re: slow queries on large syslog table

Поиск
Список
Период
Сортировка
От Chris Albertson
Тема Re: slow queries on large syslog table
Дата
Msg-id 20011214003556.26923.qmail@web14708.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: slow queries on large syslog table  ("colm ennis" <colm.ennis@eircom.net>)
Список pgsql-general
--- colm ennis <colm.ennis@eircom.net> wrote:

>
> im not using the -B option so i guess im using the3 default
> number/size
> buffers.

That is the number one thing you can do to help.
The default buffer size is 64 * 8K = 0.5M. Half
a megabyte is pretty darm small.  Try going to 100Mb
and see what hapens.  Thats a 500x increase.

=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com

В списке pgsql-general по дате отправления:

Предыдущее
От: "colm ennis"
Дата:
Сообщение: Re: slow queries on large syslog table
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: slow queries on large syslog table