On Mon, Nov 17, 2008 at 1:15 PM, Howard Cole <howardnews@xxxxxxxxxxxxx> wrote: > Hi, > > I am running multiple 8.2 databases on a not-so-powerful W2K3 server - and > it runs great - for the majority of time. However I have some monster > tsearch queries which take a lot of processing and hog system resources - > especially disk. > > I am not concerned with the amount of time or speed of the tsearch2 query, > which is doing a lot of work, all I need to do is make sure that the query > does not impact all other databases and queries running on the same machine. > > 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. Not directly related to your question, but if effective_cache_size hasn't been changed from the default, adjusting it could improve overall performance a fair bit. Regards, Isak -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
