From: Roderick A. Anderson (raanders_at_acm.org)
Date: Thu 19 Aug 2004 - 15:50:53 BST
On Wed, 18 Aug 2004, Matt Nuzum wrote:
> Rod,
> Let me just say that I've been using the 2.4.20ctx-17 (now antique)
> for some time in a scenario similar to what you described with out
> incident. I know that doesn't address your question with the 2.6
> kernel at all, I was just using it as a spring board into another
> point.
Well I'm almost as bad. I have a 2.4.20ctx-18 system that I have not ahd
to upgrade.
> Regarding PostgreSQL (and probably MySQL too) running in the vserver,
> some of the fine-tuning steps to get a database server running well
> for high performance applications won't work well in a vserver.
> Specifically, because PostgreSQL runs best when it's data is stored on
> the outer portions of the disk and with it's WAL on a separate disk
> and better yet, stripped across disks you will find that write
> performance (inserts and updates) will not be ideal.
Yeah, I lust for an eight-way Opteron 24 Gbyte RAM and 15 TB of attached
SCSI-to-SATA storage, but I have no need for it yet. We're got our RT and
a couple of low volume custom databases on the Pg server.
I've tried Enrico's suggestion but never got to the point of stress
testing it. My biggest slow down right now is getting OBDC to connect to
some MS SQL Server databases and the fact I have to SMB/CIF mount the W2K
fiels systems I need to access and that can be a bit problematic at best.
> All the other options I can think of are much more complex and I
> haven't tried any of them. I chose to put my db server on a separate
> box and connect to it through a private network. This provides at
> least a 3 fold improvement of write performance.
Yeah I keep asking but can't demostrate a need yet.
> Of course, maybe performance isn't that important in your case; Most
> of my vservers are merely there to logically separate administration
> tasks and performance is not the goal. If so, ignore my post.
Never. It was good and I like hearing from other Pg users and admins.
Mostly I get to curse MS SQL Server or swear at MySQL for being different
when dealing with the commandline interface.
> I hope you have a nice day,
Thanks I'm aimimg for one and the same to you.
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"
_______________________________________________
Vserver mailing list
Vserver_at_list.linux-vserver.org
http://list.linux-vserver.org/mailman/listinfo/vserver