Re: [HACKERS] Options for growth

2003-02-12 Thread scott.marlowe
On Wed, 12 Feb 2003, GB Clark wrote: > On Thu, 23 Jan 2003 11:19:36 -0700 (MST) > "scott.marlowe" <[EMAIL PROTECTED]> wrote: > > > On 23 Jan 2003, Hannu Krosing wrote: > > > > > Curt Sampson kirjutas N, 23.01.2003 kell 17:42: > > > > If the OS can handle the scheduling (which, last I checked, Li

Re: [HACKERS] Options for growth

2003-02-12 Thread GB Clark
On Thu, 23 Jan 2003 11:19:36 -0700 (MST) "scott.marlowe" <[EMAIL PROTECTED]> wrote: > On 23 Jan 2003, Hannu Krosing wrote: > > > Curt Sampson kirjutas N, 23.01.2003 kell 17:42: > > > If the OS can handle the scheduling (which, last I checked, Linux couldn't, > > > > When did you do your checking

Re: [HACKERS] Options for growth

2003-01-24 Thread Andrew Sullivan
On Thu, Jan 16, 2003 at 12:23:52PM -0500, Neil Conway wrote: > > The estimates I've heard from a couple parties are that PostgreSQL tends > to scale well up to 4 CPUs. I've been meaning to take a look at > improving that, but I haven't had a chance yet... I can definitely tell you that Postgres s

Re: [HACKERS] Options for growth

2003-01-23 Thread scott.marlowe
On 23 Jan 2003, Hannu Krosing wrote: > Curt Sampson kirjutas N, 23.01.2003 kell 17:42: > > If the OS can handle the scheduling (which, last I checked, Linux couldn't, > > When did you do your checking ? > (just curious, not to start a flame war ;) > > > at least not without patches), eight or

Re: [HACKERS] Options for growth

2003-01-23 Thread Curt Sampson
On Fri, 23 Jan 2003, Hannu Krosing wrote: > Curt Sampson kirjutas N, 23.01.2003 kell 17:42: > > If the OS can handle the scheduling (which, last I checked, Linux couldn't, > > When did you do your checking ? > (just curious, not to start a flame war ;) This was perhaps a year or so ago. IBM had s

Re: [HACKERS] Options for growth

2003-01-23 Thread Hannu Krosing
Curt Sampson kirjutas N, 23.01.2003 kell 17:42: > If the OS can handle the scheduling (which, last I checked, Linux couldn't, When did you do your checking ? (just curious, not to start a flame war ;) > at least not without patches), eight or sixteen > CPUs will be fine. > > cjs -- Hannu Kros

Re: [HACKERS] Options for growth

2003-01-23 Thread Curt Sampson
On Thu, 16 Jan 2003, D'Arcy J.M. Cain wrote: > Due to the fact that we are growing out of our current system > (PostgreSQL on PCs) we are looking for ways to expand and one of the > suggestions has been to toss PostgreSQL in favour of Oracle with > Remote Access Cluster (RAC) software. The theory

Re: [HACKERS] Options for growth

2003-01-23 Thread Curt Sampson
On Wed, 22 Jan 2003, Sean Chittenden wrote: > > > By the way, I too wonder which supported OS platform would support > > > over 4GB of memory on a PC.. > > > > Linux? I don't think there's any problem handling more than 4G > > memory in the system. On 32bit architectures, there's of course the > >

Re: [HACKERS] Options for growth

2003-01-22 Thread Sean Chittenden
> > That would depend on the OS. Not many 'pc-based unix' support over > > 4 GB of memory, some don't even go that far. > > > By the way, I too wonder which supported OS platform would support > > over 4GB of memory on a PC.. > > Linux? I don't think there's any problem handling more than 4G > me

Re: [HACKERS] Options for growth

2003-01-20 Thread Adrian 'Dagurashibanipal' von Bidder
[no cc:s please] On Mon, 2003-01-20 at 10:31, Daniel Kalchev wrote: > >>>"D'Arcy J.M. Cain" said: > > On Thursday 16 January 2003 11:59, Adrian 'Dagurashibanipal' von Bidder wrot > e: > > > On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote: > > > > We are also looking at hardware solutio

Re: [HACKERS] Options for growth

2003-01-20 Thread Daniel Kalchev
>>>"D'Arcy J.M. Cain" said: > On Thursday 16 January 2003 11:59, Adrian 'Dagurashibanipal' von Bidder wrot e: > > On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote: > > > We are also looking at hardware solutions, multi-CPU PCs with tons (24GB ) > > > of memory. I know that memory

Re: [HACKERS] Options for growth

2003-01-17 Thread D'Arcy J.M. Cain
On Thursday 16 January 2003 11:59, Adrian 'Dagurashibanipal' von Bidder wrote: > On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote: > > We are also looking at hardware solutions, multi-CPU PCs with tons (24GB) > > of memory. I know that memory will improve access if it prevents > > swapping but

Re: [HACKERS] Options for growth

2003-01-17 Thread D'Arcy J.M. Cain
On Thursday 16 January 2003 20:54, Christopher Kings-Lynne wrote: > > toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC) > > software. > > You mean Real Application Clusters? Oops, yes. -- D'Arcy J.M. Cain| Democracy is three wolves http://www.druid.net/darcy/

Re: [HACKERS] Options for growth

2003-01-17 Thread D'Arcy J.M. Cain
On Thursday 16 January 2003 12:23, Neil Conway wrote: > On Thu, 2003-01-16 at 11:42, D'Arcy J.M. Cain wrote: > > Is [Oracle RAC] really as simple as it sounds or would we just be > > giving up the other two for a new set of problems. > > That's a question you should be asking to an authority on Ora

Re: [HACKERS] Options for growth

2003-01-16 Thread Christopher Kings-Lynne
> Due to the fact that we are growing out of our current system > (PostgreSQL on > PCs) we are looking for ways to expand and one of the suggestions > has been to > toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC) > software. You mean Real Application Clusters? Chris -

Re: [HACKERS] Options for growth

2003-01-16 Thread Neil Conway
On Thu, 2003-01-16 at 11:42, D'Arcy J.M. Cain wrote: > Is [Oracle RAC] really as simple as it sounds or would we just be > giving up the other two for a new set of problems. That's a question you should be asking to an authority on Oracle RAC (which pgsql-hackers is not). > My idea is to create a

Re: [HACKERS] Options for growth

2003-01-16 Thread Adrian 'Dagurashibanipal' von Bidder
On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote: > We are also looking at hardware solutions, multi-CPU PCs with tons (24GB) of > memory. I know that memory will improve access if it prevents swapping but > how well does PostgreSQL utilize multiple CPUs? At most one CPU is used for any sin