From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Out of free buffers... HELP! |
Date: | 2001-09-18 15:26:46 |
Message-ID: | web-121099@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Mike,
> psql ids -c 'select src,dst,count(*) from brick* where src_port=135
> group by src,dst' > /tmp/135.dat
>
> and I get:
>
> ERROR: out of free buffers: time to abort !
>
> Any ideas on how to get this query to run?
You may be using the default buffer settings for Postgres on a large
database. Or your computer may be running a lot of software and not
have enough physical memory.
Suggestion:
1. Check memory usage on your machine.
2. If memory usage is low, adjust the "Shared Buffer" setting in the
postgresql.conf file. It defaults to 16; I have mine set at 2048.
3. For more tuning help, see techdocs.postgresql.org.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/plain | 2 bytes |
unknown_filename | text/plain | 2 bytes |
unknown_filename | text/plain | 2 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-09-18 15:31:49 | Holiday Calculations? |
Previous Message | Kovacs Baldvin | 2001-09-18 14:45:33 | Re: Out of free buffers... HELP! |