Re: [PERFORM] Tables Without OIDS and its effect

2003-12-13 Thread Sai Hertz And Control Systems
Hello  Neil Conway, We are doing some test on our applications and will let know the community  if without OIDS we could gain more speed . 2. Though I have not written any code in my any of the pgsql functions which depend on OIDS 1. Will without OIDS the functions behave internally

[PERFORM] a lot of problems with pg 7.4

2003-12-13 Thread Kari Lavikka
Hi! We have been running a rather busy website using pg 7.3 as the database. Peak hitrate is something like 120 request / second without images and other static stuff. The site is a sort of image gallery for IRC users. I evaluated pg 7.4 on our development server and it looked just fine but perf

Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

2003-12-13 Thread Jeff Bohmer
Just one more piece of advice, you might want to look into a good battery backed cache hardware RAID controller. They work quite well for heavily updated databases. The more drives you throw at the RAID array the faster it will be. I've seen this list often recommended such a setup. We'll probab

Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

2003-12-13 Thread Jeff Bohmer
Shridhar Daithankar wrote: FWIW, there are only two pieces of software that need 64bit aware for a typical server job. Kernel and glibc. Rest of the apps can do fine as 32 bits unless you are oracle and insist on outsmarting OS. In fact running 32 bit apps on 64 bit OS has plenty of advantages

[PERFORM] Update performance doc

2003-12-13 Thread Bruce Momjian
I have updated my hardware performance documentation to reflect the findings during the past few months on the performance list: http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html Thanks. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PR

Re: [PERFORM] Tuning for mid-size server

2003-12-13 Thread Bruce Momjian
Andrew Sullivan wrote: > On Tue, Oct 21, 2003 at 03:11:17PM -0600, scott.marlowe wrote: > > I think where it makes sense is when you have something like a report > > server where the result sets may be huge, but the parellel load is load, > > i.e. 5 or 10 users tossing around 100 Meg or more at t