Re: slow queries on large syslog table - Mailing list pgsql-general

From Chris Albertson
Subject Re: slow queries on large syslog table
Date
Msg-id 20011214003556.26923.qmail@web14708.mail.yahoo.com
Whole thread Raw
In response to Re: slow queries on large syslog table  ("colm ennis" <colm.ennis@eircom.net>)
List 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 by date:

Previous
From: "colm ennis"
Date:
Subject: Re: slow queries on large syslog table
Next
From: Stephan Szabo
Date:
Subject: Re: slow queries on large syslog table