I somehow managed to convince the powers that be to let me get a
couple X25-E's.
I tossed them in my macpro (8 cores), fired up Ubuntu 8.10 and did
some testing.
Raw numbers are very impressive. I was able to get 3700 random seek
+read's a second. In a R1 config it stayed at 3700, but if I a
Robert Haas escribió:
> Have you ever given any thought to whether it would be possible to
> implement referential integrity constraints with statement-level
> triggers instead of row-level triggers?
Well, one reason we haven't discussed this is because our per-statement
triggers are too primitiv
On Tue, Feb 3, 2009 at 9:54 AM, Jeff wrote:
> Scalefactor 50, 10 clients: 900tps
>
> At scalefactor 50 the dataset fits well within memory, so I scaled it up.
>
> Scalefactor 1500: 10 clients: 420tps
>
> While some of us have arrays that can smash those numbers, that is crazy
> impressive for a pl
I don't think write caching on the disks is a risk to data integrity if you are
configured correctly.
Furthermore, these drives don't use the RAM for write cache, they only use a
bit of SRAM on the controller chip for that (and respect fsync), so write
caching should be fine.
Confirm that NCQ i
Alvaro Herrera writes:
> Robert Haas escribió:
>> Have you ever given any thought to whether it would be possible to
>> implement referential integrity constraints with statement-level
>> triggers instead of row-level triggers?
> Well, one reason we haven't discussed this is because our per-state
Hello All,
TL> If you're deleting very many but not all rows, people tend
TL> to drop the FK constraints and re-establish them afterwards.
I find
BEGIN;
CREATE TEMP TABLE remnant AS
SELECT * FROM bigtable WHERE (very_restrictive_condition);
TRUNCATE TABLE bigtable;
INSERT INTO bigtable SELECT
On Tue, Feb 3, 2009 at 10:54 AM, Jeff wrote:
> Now, moving into reality I compiled 8.3.latest and gave it a whirl. Running
> against a software R1 of the 2 x25-e's I got the following pgbench results:
> (note config tweaks: work_mem=>4mb, shared_buffers=>1gb, should probably
> have tweaked chec
On Tue, Feb 3, 2009 at 4:17 PM, Tom Lane wrote:
> Alvaro Herrera writes:
>> Robert Haas escribió:
>>> Have you ever given any thought to whether it would be possible to
>>> implement referential integrity constraints with statement-level
>>> triggers instead of row-level triggers?
>
>> Well, one
