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,
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
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
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
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
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
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
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
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