| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "Eugeny N Dzhurinsky" <bofh(at)redwerk(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: getting better performance |
| Date: | 2006-07-06 15:26:54 |
| Message-ID: | b42b73150607060826r253be9c7h1cea9826c758d6f8@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 7/6/06, Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com> wrote:
> 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?
you may want to explore upping your FSM settings with that many tables.
Merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-07-06 15:32:28 | Re: getting better performance |
| Previous Message | Eugeny N Dzhurinsky | 2006-07-06 15:11:26 | Re: getting better performance |