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

2008-07-23 Thread Miernik
Scott Marlowe <[EMAIL PROTECTED]> wrote: > Well, my guess is that by running under Xen you're already sacrificing > quite a bit of performance, and running it with only 48 Megs of ram is > making it even worse. But if your budget is $100 a year, I guess > you're probably stuck with such a setup.

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

2008-07-23 Thread Scott Marlowe
On Wed, Jul 23, 2008 at 2:32 PM, Miernik <[EMAIL PROTECTED]> wrote: > Scott Marlowe <[EMAIL PROTECTED]> wrote: >> won't ever run into. Why such an incredibly limited virtual machine? >> Even my cell phone came with 256 meg built in two years ago. > > Because I don't want to spend too much money on

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

2008-07-23 Thread Miernik
Scott Marlowe <[EMAIL PROTECTED]> wrote: > won't ever run into. Why such an incredibly limited virtual machine? > Even my cell phone came with 256 meg built in two years ago. Because I don't want to spend too much money on the machine rent, and a 48 MB RAM Xen is about all I can get with a budget

Re: [PERFORM] Samsung 32GB SATA SSD tested

2008-07-23 Thread Scott Marlowe
On Wed, Jul 23, 2008 at 1:57 PM, Jeffrey Baker <[EMAIL PROTECTED]> wrote: > On Tue, Jul 22, 2008 at 5:32 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: >> On Tue, Jul 22, 2008 at 6:04 PM, Jeffrey W. Baker <[EMAIL PROTECTED]> wrote: >> >>> Strangely the RAID controller behaves badly on the TPC-B workl

Re: [PERFORM] Samsung 32GB SATA SSD tested

2008-07-23 Thread Jeffrey Baker
On Tue, Jul 22, 2008 at 5:32 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Tue, Jul 22, 2008 at 6:04 PM, Jeffrey W. Baker <[EMAIL PROTECTED]> wrote: > >> Strangely the RAID controller behaves badly on the TPC-B workload. It >> is faster than disk, but not by a lot, and it's much slower than th

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

2008-07-23 Thread Alvaro Herrera
Miernik wrote: > 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

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

2008-07-23 Thread Scott Marlowe
On Wed, Jul 23, 2008 at 9:21 AM, Miernik <[EMAIL PROTECTED]> wrote: > 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 lik

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

2008-07-23 Thread Miernik
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

Re: [PERFORM] Perl/DBI vs Native

2008-07-23 Thread Valentin Bogdanov
Thanks Guys, this is really useful, especially the pg_service.conf. I have got an app where the connection parameters have to be set in 3 different places I was thinking of writing something myself but now that I know of pg_service.conf, problem solved. Regards, Val --- On Tue, 22/7/08, Jeffr