git://git.onelab.eu / plcapi.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 8d69717) | patch
- PostgreSQL apparently does not push outer conditionals inside joined
authorMark Huang <mlhuang@cs.princeton.edu>
Mon, 29 Jan 2007 20:13:12 +0000 (20:13 +0000)
committerMark Huang <mlhuang@cs.princeton.edu>
Mon, 29 Jan 2007 20:13:12 +0000 (20:13 +0000)
commit5d36ded39af25684c24bd64470db93b505375d9f
tree97437691ca4d2b0fa1cdb11e148eb3ac6d16d82etree | snapshot
parent8d6971759769219f95ab9cd832030812c11b3378commit | diff
- PostgreSQL apparently does not push outer conditionals inside joined
  group aggregate views, causing each group aggregate view to be fully
  loaded. So, instead of joining group aggregate views, subquery them
  using the primary key directly. Speeds up single-node and single-slice
  queries by 1000x-10000x using real data from public PlanetLab DB.
planetlab4.sql diff | blob | history
plcapi