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
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
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
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
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
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