[PERFORM] Constraint propagating for equal fields

2010-01-28 Thread Віталій Тимчишин
Hello. I've always thought that PostgreSQL would propagate constraint from field1 to field2 if condition says field1=field2, but this does not seem the case: dict=# explain select * from domain_list,title.domains where processed_at is not null and key=groupid and key < 100 and groupid < 10

Re: [PERFORM] Benchmark shows very slow bulk delete

2010-01-28 Thread Ivan Voras
James Mansion wrote: > Ivan Voras wrote: >> I wish that, when people got the idea to run a simplistic benchmark >> like this, they would at least have the common sense to put the >> database on a RAM drive to avoid problems with different cylinder >> speeds of rotational media and fragmentation fro