You could build a dual opteron with 4 GB of ram, 12 10k raptor SATA
drives with a battery backed cache for about 7k or less.
Okay. You trust SATA drives? I've been leary of them for a production
database. Pardon my ignorance, but what is a battery backed cache? I
know the drives have a
Hi Steve,
Okay. You trust SATA drives? I've been leary of them for a production
database. Pardon my ignorance, but what is a battery backed cache? I
know the drives have a built-in cache but I don't if that's the same.
Are the 12 drives internal or an external chasis? Could you point me to
a
On Fri, 25 Mar 2005, Karim Nassar wrote:
On Fri, 2005-03-25 at 15:10 +, Simon Riggs wrote:
Karim: Did this happen? If not, can you drop and re-create and confirm
that you get the WARNING? If not, we have problems.
No. Nor do I think that I should. SERIAL is shortcut for INTEGER, no? I
On Sat, 2005-03-26 at 07:55 -0800, Stephan Szabo wrote:
That seems like it should be okay, hmm, what does something like:
PREPARE test(int) AS SELECT 1 from measurement where
id_int_sensor_meas_type = $1 FOR UPDATE;
EXPLAIN ANALYZE EXECUTE TEST(1);
give you as the plan?
Bjoern, Josh, Steve,
Get 12 or 16 x 74GB Western Digital Raptor S-ATA drives, one 3ware
9500S-12 or two 3ware 9500S-8 raid controllers with a battery backup
unit (in case of power loss the controller saves unflushed data), a
decent tyan board for the existing dual xeon with 2 pci-x slots and
Steve, can we clarify that you are not currently having any performance
issues, you're just worried about failure? Recommendations should be based
on whether improving applicaiton speed is a requirement ...
Josh,
The priorities are: 1)improve safety/failure-prevention, 2) improve
performance.
The Chenbros are nice, but kinda pricey ($800) if Steve doesn't need the
machine to be rackable.
If your primary goal is redundancy, you may wish to consider the possibility
of building a brand-new machine for $7k (you can do a lot of machine for
$7000 if it doesn't have to be rackable) and
On Sat, 26 Mar 2005, Karim Nassar wrote:
On Sat, 2005-03-26 at 07:55 -0800, Stephan Szabo wrote:
That seems like it should be okay, hmm, what does something like:
PREPARE test(int) AS SELECT 1 from measurement where
id_int_sensor_meas_type = $1 FOR UPDATE;
EXPLAIN ANALYZE EXECUTE
On Sat, 2005-03-26 at 15:18 -0800, Stephan Szabo wrote:
On Sat, 26 Mar 2005, Karim Nassar wrote:
On Sat, 2005-03-26 at 07:55 -0800, Stephan Szabo wrote:
That seems like it should be okay, hmm, what does something like:
PREPARE test(int) AS SELECT 1 from measurement where