Re: [PERFORM] Configuration settings for 32GB RAM server

2006-12-05 Thread Mark Lonsdale
] Sent: 04 December 2006 23:29 To: Mark Lonsdale Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Configuration settings for 32GB RAM server On 4-Dec-06, at 12:10 PM, Mark Lonsdale wrote: Hi We are migrating our Postgres 7.3.4 application to postgres 8.1.5 and also

[PERFORM] Configuration settings for 32GB RAM server

2006-12-04 Thread Mark Lonsdale
Hi We are migrating our Postgres 7.3.4 application to postgres 8.1.5 and also moving it to a server with a much larger hardware configuration as well.The server will have the following specification. - 4 physical CPUs (hyperthreaded to 8) - 32 GB RAM - x86_64 architecture

Re: [PERFORM] Configuration Issue ?

2006-10-25 Thread Mark Lonsdale
y is in it. Really appreciate your help and fast turnaround on this Mark -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: 25 October 2006 22:17 To: Richard Huxton Cc: Mark Lonsdale; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Configuration Issue ? Rich

Re: [PERFORM] Configuration Issue ?

2006-10-25 Thread Mark Lonsdale
Mark -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: 25 October 2006 21:52 To: Mark Lonsdale Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Configuration Issue ? Mark Lonsdale wrote: > > > Hi > > > > Please help. I have

[PERFORM] Configuration Issue ?

2006-10-25 Thread Mark Lonsdale
  Hi   Please help.  I have got a postgres 7.3.4 database running on RedHat ES 3, with 8GB of physical memory in it.   The machine is shared with my application which is pretty intensive in doing selects and updates against the database, but there are usually no more than 10 connections