Re: [GENERAL] RAMFS with Postgres

2005-07-26 Thread Marco Colombo
On Fri, 2005-07-22 at 15:56 +0100, Alex Stapleton wrote: > On 21 Jul 2005, at 17:02, Scott Marlowe wrote: > > > On Thu, 2005-07-21 at 02:43, vinita bansal wrote: > > > >> Hi, > >> > >> My application is database intensive. I am using 4 processes since > >> I have 4 > >> processeors on my box. Th

Re: [GENERAL] RAMFS with Postgres

2005-07-23 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Alex Stapleton): > On 21 Jul 2005, at 17:02, Scott Marlowe wrote: > >> On Thu, 2005-07-21 at 02:43, vinita bansal wrote: >> >>> Hi, >>> >>> My application is database intensive. I am using 4 processes since >>> I have 4 >>> processeors on my box. There are times when all th

Re: [GENERAL] RAMFS with Postgres

2005-07-22 Thread Scott Marlowe
On Fri, 2005-07-22 at 09:56, Alex Stapleton wrote: > On 21 Jul 2005, at 17:02, Scott Marlowe wrote: > > > > My feeling is that you may be going about this the wrong way. Most > > likely the issue so far has been I/O contention. Have you tested your > > application using a fast, battery backed ca

Re: [GENERAL] RAMFS with Postgres

2005-07-22 Thread Alex Stapleton
On 21 Jul 2005, at 17:02, Scott Marlowe wrote: On Thu, 2005-07-21 at 02:43, vinita bansal wrote: Hi, My application is database intensive. I am using 4 processes since I have 4 processeors on my box. There are times when all the 4 processes write to the database at the same time and time

Re: [GENERAL] RAMFS with Postgres

2005-07-21 Thread Scott Marlowe
On Thu, 2005-07-21 at 02:43, vinita bansal wrote: > Hi, > > My application is database intensive. I am using 4 processes since I have 4 > processeors on my box. There are times when all the 4 processes write to the > database at the same time and times when all of them will read all at once. >

Re: [GENERAL] RAMFS with Postgres

2005-07-21 Thread Marco Colombo
On Thu, 2005-07-21 at 07:43 +, vinita bansal wrote: > Hi, > > My application is database intensive. I am using 4 processes since I have 4 > processeors on my box. There are times when all the 4 processes write to the > database at the same time and times when all of them will read all at onc

Re: [GENERAL] RAMFS with Postgres

2005-07-21 Thread vinita bansal
Hi, My application is database intensive. I am using 4 processes since I have 4 processeors on my box. There are times when all the 4 processes write to the database at the same time and times when all of them will read all at once. The database is definitely not read only. Out of the entire d

Re: [GENERAL] RAMFS with Postgres

2005-07-20 Thread Marco Colombo
On Tue, 2005-07-19 at 16:45 +, vinita bansal wrote: > Hi, > > I am trying RAMFS solution with Postgres wherein I am pushing the most > heavily used tables in RAM. Why? I mean, what problem are you trying to solve? > I have 32GB RAM on a 64 bit opteron machine. My database size is 40GB. I

[GENERAL] RAMFS with Postgres

2005-07-19 Thread vinita bansal
Hi, I am trying RAMFS solution with Postgres wherein I am pushing the most heavily used tables in RAM. I have 32GB RAM on a 64 bit opteron machine. My database size is 40GB. I think Linux allows max. of 16GB (half of available RAM) to be used directly to push tables to it. I am concerned ab