Ahmad,
what's about the number of unique words ? I mean stat() function.
Sometimes, it helps to identify garbage words.
How big is your articles (average length) ?
please, cut'n paste queries and output from psql ! How fast are
next queries ?
Oleg
On Fri, 23 Sep 2005, Ahmad Fajar
Hello fellow Postgresql'ers.
I've been stumbled on this RAID card which looks nice. It is a PCI-X SATA
Raid card with 6 channels, and does RAID 0,1,5,10,50.
It is a HP card with an Adaptec chip on it, and 64 MB cache.
HP Part # : 372953-B21
Adaptec Part # :
From: Dann Corbit [EMAIL PROTECTED]
Sent: Sep 23, 2005 5:38 PM
Subject: RE: [HACKERS] [PERFORM] Releasing memory during External sorting?
_C Unleashed_ also explains how to use a callback function to perform
arbitrary radix sorts (you simply need a method that returns the
[bucketsize] most
It looks like a rebranded low end Adaptec 64MB PCI-X - SATA RAID card.
Looks like the 64MB buffer is not upgradable.
Looks like it's SATA, not SATA II
There are much better ways to spend your money.
These are the products with the current best price/performance ratio:
It looks like a rebranded low end Adaptec 64MB PCI-X - SATA RAID card.
Looks like the 64MB buffer is not upgradable.
Looks like it's SATA, not SATA II
Yeah, that's exactly what it is. I can get one for 150 Euro, the Areca is
at least 600. This is for a budget server so while it would be
When I need to insert a few hundred or thousand things in
a table from a 3-tier application, it seems I'm much better
off creating a big string of semicolon separated insert
statements rather than sending them one at a time - even
when I use the obvious things like wrapping the statements
in a
Ron Mayer [EMAIL PROTECTED] writes:
Is it expected that I'd be better off sending big
concatenated strings like
insert into tbl (c1,c2) values (v1,v2);insert into tbl (c1,c2) values
(v3,v4);...
instead of sending them one at a time?
It's certainly possible, if the network round trip from