Scott Marlowe wrote:
>> random_page_cost = 1# units are one sequential page
>> fetch
>
> Seldom if ever is it a good idea to bonk the planner on the head with
> random_page_cost=1. setting it to 1.2 ot 1.4 is low enough, but 1.4
> to 2.0 is more realistic.
Which is probably t
Jim Buttafuoco wrote:
Jan,
I write queries like this
CREATE VIEW parent_childs AS
SELECT
c.parent,
count(c.state) as childtotal,
sum(case when c.state = 1 then 1 else 0 end) as childstate1,
sum(case when c.state = 2 then 1 else 0 end) as childstate2,
sum(
Hi,
I more or less often come about the problem of aggregating a
child table counting it's different states. The cleanest solution
I've come up with so far is:
BEGIN;
CREATE TABLE parent (
id int not null,
name text not null,
UNIQUE(id)
);
CREATE TABLE child (
na
Greg Stark wrote:
> Jan Dittmer <[EMAIL PROTECTED]> writes:
>
>
>>You could always do raid 1 over raid 0, with newer kernels (2.6ish)
>>there is even a dedicated raid10 driver.
>
>
> Aren't you much better off doing raid 0 over raid 1?
>
> With
Joshua D. Drake wrote:
>>RAID controllers tend to use i960 or StrongARM CPUs that run at speeds
>>that _aren't_ all that impressive. With software RAID, you can take
>>advantage of the _enormous_ increases in the speed of the main CPU.
>>
>>I don't know so much about FreeBSD's handling of this, bu
Neil Conway wrote:
> Also, I would imagine Win32 provides some means to inform the kernel
> about your expected I/O pattern, but I haven't checked. Does anyone know
> of any other relevant APIs?
See CreateFile, Parameter dwFlagsAndAttributes
http://msdn.microsoft.com/library/default.asp?url=/li
