Postgres Pro
Downloads
Home   >   mailing lists

Re: How to reduce impact of a query. - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: How to reduce impact of a query.
Date
Msg-id 49216DA4.9010004@sigaev.ru
Whole thread Raw
In response to How to reduce impact of a query.  (Howard Cole <howardnews@selestial.com>)
Responses Re: How to reduce impact of a query.  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
Tree view 
> 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@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Christiaan Willemsen
Date:
Subject: Re: FreeBSD 7 needing to allocate lots of shared memory
Next
From: Richard Huxton
Date:
Subject: Re: aggregates and case statements