Skip site navigation (1) Skip section navigation (2)

how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence

From: Miernik <public(at)public(dot)miernik(dot)name>
To: pgsql-performance(at)postgresql(dot)org
Subject: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
Date: 2008-07-23 15:21:12
Message-ID: 20080723152112.30A4.0.NOFFLE@turbacz.local (view raw or flat)
Thread:
Lists: pgsql-performance
I have a PostgreSQL database on a very low-resource Xen virtual machine,
48 MB RAM. When two queries run at the same time, it takes longer to
complete then if run in sequence. Is there perhaps a way to install
something like a query sequencer, which would process queries in a FIFO
manner, one at a time, even if a new query comes before the last one
running is finished, it would not give the new query to the server
before the one running now finishes? That would greatly improve
performance.

Any tips in general for running PostgreSQL on such low-resource machine?

I have:

shared_buffers = 5MB
work_mem = 1024kB

are these good values, or could perhaps changing something improve it a
bit? Any other parameters to look at?

-- 
Miernik
http://miernik.name/


Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2008-07-23 17:25:35
Subject: Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
Previous:From: Valentin BogdanovDate: 2008-07-23 10:46:59
Subject: Re: Perl/DBI vs Native

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group