| From: | Chris Albertson <chrisalbertson90278(at)yahoo(dot)com> |
|---|---|
| To: | colm ennis <colm(dot)ennis(at)eircom(dot)net>, Antonio_Fiol_Bonnin <fiol(at)w3ping(dot)com> |
| Cc: | PostgreSQL General Mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: slow queries on large syslog table |
| Date: | 2001-12-14 00:35:56 |
| Message-ID: | 20011214003556.26923.qmail@web14708.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
--- colm ennis <colm(dot)ennis(at)eircom(dot)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(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-12-14 00:36:51 | Re: slow queries on large syslog table |
| Previous Message | Philip Hallstrom | 2001-12-14 00:00:33 | Re: storing intermediate results from recursive plpgsql |