| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | juapabsan(at)tutopia(dot)com |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Confirm calculus |
| Date: | 2010-06-16 19:34:43 |
| Message-ID: | AANLkTilo9EFWughGyfslZjejliCsMATpKL5brNmt4CIb@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jun 16, 2010 at 7:46 AM, Juan Pablo Sandoval Rivera
<juapabsan(at)tutopia(dot)com> wrote:
> Good morning List
>
> In relation to the process of tuning the engine PostgreSQL database, especially
> 7.3.7 version that is being used currently, agreaceria me clarify a procedure
I concur with the other poster on keeping shared_mem lower on this
older version. Also, you should be running at the very least the
latest version of 7.3, which is 7.3.21 and available here:
ftp://ftp-archives.postgresql.org/pub/source/
Tuning 7.3 is more an effort in futility at this point, considering
that a non-tuned 8.3 or 8.4 install will still be much much faster.
If the lack of auto-casts in 8.3 impacts you negatively then at least
look at 8.2.latest.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig James | 2010-06-16 19:36:31 | Re: PostgreSQL as a local in-memory cache |
| Previous Message | Balkrishna Sharma | 2010-06-16 19:33:12 | Re: PostgreSQL as a local in-memory cache |