Re: How to reduce impact of a query.

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Howard Cole <howardnews(at)selestial(dot)com>
Cc: 'PgSql General' <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to reduce impact of a query.
Date: 2008-11-17 13:12:04
Message-ID: 49216DA4.9010004@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> The machine in question is a 1GB Ram, AMD 64 with Raid 1 Sata disks. Non
> standard parts of my postgresql.conf are as follows:
> max_connections=100
> shared_buffers=128MB
> work_mem=4MB
> maintenance_work_mem=256MB
> max_fsm_pages=204800
> max_fsm_relations=1500
>
> Any tips appreciated.

Pls, show
1) effective_cache_size
2) The query
3) Output of EXPLAIN ANALYZE of query

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message charlie derr 2008-11-17 13:46:10 List Ettiquette (perhaps Off Topic by now) was: Re: Database access over the Internet...
Previous Message Christiaan Willemsen 2008-11-17 13:05:29 Re: FreeBSD 7 needing to allocate lots of shared memory