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,

[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] 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 like 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 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] 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 the other

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 workload. It is

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 of

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 the

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. I