| From: | Frank Finner <postgresql(at)finner(dot)de> |
|---|---|
| To: | "Mario Soto" <mario_soto(at)venezolanadeavaluos(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: performance very slow |
| Date: | 2004-05-26 17:46:32 |
| Message-ID: | 20040526194632.4c4f9f09.postgresql@finner.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Hi,
shared_buffers seems quite low for a server to me. For best performance, you
should read and follow the optimisation articles on
http://techdocs.postgresql.org/.
Regards, Frank
On Wed, 26 May 2004 11:26:30 -0400 (VET) "Mario Soto"
<mario_soto(at)venezolanadeavaluos(dot)com> sat down, thought long and then wrote:
> Hi. i hava a postresql 7.4.2 in a production server.
>
> tha machine is a Pentium IV 2,6 GHZ AND 1 GB IN RAM with lINUX RH 9.0.
>
...
>
>
> BUT THE PERFORMANCE IT´S VERY SLOW
>
> what can do ?????
>
> Thank
>
>
> Mario Soto
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ericson Smith | 2004-05-26 18:30:26 | Postgresql Logging |
| Previous Message | Peter Eisentraut | 2004-05-26 17:28:37 | Re: About table schema |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vitaly Belman | 2004-05-26 18:00:34 | Re: PostgreSQL caching |
| Previous Message | Chris Browne | 2004-05-26 16:58:55 | Re: tuning for AIX 5L with large memory |