On Wed, Jan 18, 2006 at 05:11:15PM -0800, Brooks Davis wrote:
> On Wed, Jan 18, 2006 at 06:58:47PM -0600, Jim C. Nasby wrote:
> > On Sat, Jan 14, 2006 at 06:42:02AM -0800, Arne Woerner wrote:
> > > Did you do those "dd" tests with small block sizes (like 1byte:
> >
SQL does 8kB I/O by default. This can only be changed by
modifying a header file.
--
Jim C. Nasby, Database Architect[EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want
On Mon, Aug 22, 2005 at 09:09:20PM +0200, OxY wrote:
> i know there was a topic about fbsd vs linux mysql perf, but
> what i need is just a few compile and .cnf options to improve the stuff
> as much as possible, not to chase linux..
Then why aren't you asking on the mysql lists?
--
configure it so that your data isn't
safe at all, which would be an apples-oranges comparison to PostgreSQL.
--
Jim C. Nasby, Database Architect[EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go to
You should take a look at the context switch rate, which is apparentnly
sometimes an issue on Xeons. Switching to PostgreSQL might help too. ;P
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Windows
ings that will eventually go into PostgreSQL itself, and it's
been a big benefit when it comes to bringing people together to work on
something.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #1828
Window
rom what I've seen on the PostgreSQL lists, PostgreSQL sees a huge
(30%) performance increase on Opterons over Xeons, and other databases
see 10-15%. I haven't seen 32 bit vs 64 bit numbers, but I would expect
the increase to be even larger than Xeon to Opteron numbers.
--
Jim C. Nasby, Database C
y is memory bandwidth, which the Opterons have much more of than
other CPUs. So any application that needs to move a lot of data, whether
a database or a router, will benefit.
--
Jim C. Nasby, Database Consultant [EMAIL PROTECTED]
Give your computer some brain candy! www.distribute