Marinos,
> shared_buffers=10
> (I tried many values, this seems to work well for us - 12GB RAM)
> wal_buffers=500
> sort_mem=80
> checkpoint_segments=16
> effective_cache_size=100
> etc.
800MB for sort mem? Are you sure you typed that correctly? You must be
counting on not having
Hi,
one of our tables has to be updated frequently, but concurrently running
SELECT-queries must also have low latency times (it's being accessed
through a web interface).
I'm looking for ideas that might improve the interactive performance of
the system, without slowing down the updates too m
Leon,
> Hello all. I am in the midst of porting a large web application from a
> MS SQL Server backend to PostgreSQL. The migration work is basically
> complete, and we're at the testing and optimization phase of the
> project. The results so far have been disappointing, with Postgres
> perfor
Bruce,
my bet is on the limited amount of shared memory. The setup as posted by Leon
only shows 80 MB. On a 4 GB database, that's not all that much. Depending on
what he's doing, this might be a bottleneck. I don't like the virtual memory
strategy of Linux too much and would rather increase thi
Please run your largest (worst) queries using EXPLAIN ANALYZE and send
in the results so we can see how the queries are being executed &
optimized.
On Feb 12, 2004, at 11:29 AM, Leon Out wrote:
Hello all. I am in the midst of porting a large web application from a
MS SQL Server backend to Post
Leon Out wrote:
> Hello all. I am in the midst of porting a large web application from a
> MS SQL Server backend to PostgreSQL. The migration work is basically
> complete, and we're at the testing and optimization phase of the
> project. The results so far have been disappointing, with Postgres
On Thu, 12 Feb 2004, Leon Out wrote:
> Hello all. I am in the midst of porting a large web application from a
> MS SQL Server backend to PostgreSQL. The migration work is basically
> complete, and we're at the testing and optimization phase of the
> project. The results so far have been disappo
Hello all. I am in the midst of porting a large web application from a
MS SQL Server backend to PostgreSQL. The migration work is basically
complete, and we're at the testing and optimization phase of the
project. The results so far have been disappointing, with Postgres
performing queries in a
