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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-07-23 17:25:35 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 Message Valentin Bogdanov 2008-07-23 10:46:59 Re: Perl/DBI vs Native