Pg Performers,
This might be a out of the ordinary question, or perhaps I have been out
of the loop for a while but does PostgreSQL (or any other database) have
support for lazy index updates. What I mean by lazy index updates is
index updating which occur at a regular interval rather than per
tr
> We're looking into getting an Adaptec 2200S or the Megaraid 320 2x
> which have better processors, and hopefully better performance. We
> feel that the use of the AIC7930 as the CPU on the ZCR just doesn't
> cut it and a faster raid controller would work better. Does anyone out
> there have any
On Tue, 2004-03-02 at 17:42, William Yu wrote:
> Anjan Dave wrote:
> > We have a Quad-Intel XEON 2.0GHz (1MB cache), 12GB memory, running RH9,
> > PG 7.4.0. There's an internal U320, 10K RPM RAID-10 setup on 4 drives.
> >
> > We are expecting a pretty high load, a few thousands of 'concurrent'
> We are running into issues with IO saturation obviously. Since this
> thing is only going to get bigger we are looking for some advice on
> how to accommodate DB's of this size.
> Second and more radical, has anyone run
> postgreSQL on the new Apple G5 with an XRaid system? This seems like
One thing I learned after spending about a week comparing the Athlon (2
ghz, 333 mhz frontside bus) and Xeon (2.4 ghz, 266 mhz frontside bus)
platforms was that on average the select queries I was benchmarking ran
30% faster on the Athlon (this was with data cached in memory so may not
apply to the
