script.sql

text/plain

Filename: script.sql

Type: text/plain

Part: 1

Message: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile

drop table _tmpXX ;
\timing
create table _tmpXX as select * from 
  ( select *, 
      (select healpixid from idt_match as m where m.transitid=o.transitid) 
        as x from idt_photoobservation_small as o offset 0
  ) as y where x%16=XX order by x;