getting better performance

From: Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: getting better performance
Date: 2006-07-06 06:40:16
Message-ID: 20060706064016.GC1091@office.redwerk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello!

I have a postgresql server serving thousands of tables. Sometime there are
queries which involves several tables.

In postgresql.conf I have these settings:

shared_buffers = 40000
work_mem = 8192
maintenance_work_mem = 16384
max_stack_depth = 2048

all other settings are left by default (except ones needed for pg_autovacuum).

Is there anything I can tune to get better performance?

--
Eugene N Dzhurinsky

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message A. Kretschmer 2006-07-06 06:48:07 Re: getting better performance
Previous Message Mark Kirkwood 2006-07-06 00:52:09 Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL