Re: How can I Improve performance in Solaris?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: ingrid martinez <ingridm(at)qoslabs(dot)com>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How can I Improve performance in Solaris?
Date: 2003-08-13 15:49:51
Message-ID: 1060789790.11688.21.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 2003-08-13 at 11:17, ingrid martinez wrote:
> The query that execute is only inserts, I use a batch of 300 and then do
> commit.
>
> insert into FLOWS values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Any foreign keys on this table? Triggers or Rules?

What kind of hardware do you have? Anything else running on it?

Could you provide the header information from top?

Off the cuff, modify your postgresql.conf for the below and restart
PostgreSQL.

shared_buffers = 1000 # 2*max_connections, min 16
effective_cache_size = 4000 # default in 8k pages

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-13 16:17:01 Re: How can I Improve performance in Solaris?
Previous Message Josh Berkus 2003-08-13 15:46:55 Re: Perfomance Tuning