An initial study of overheads of eddies
- 1 March 2004
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 33 (1) , 44-49
- https://doi.org/10.1145/974121.974129
Abstract
An eddy [2] is a highly adaptive query processing operator that continuously reoptimizes a query in response to changing runtime conditions. It does this by treating query processing as routing of tuples through operators and making per-tuple routing decisions. The benefits of such adaptivity can be significant, especially in highly dynamic environments such as data streams, sensor query processing, web querying, etc. Various parties have asserted that the cost of making per-tuple routing decisions is prohibitive. We have implemented eddies in the PostgreSQL open source database system [1] in the context of the TelegraphCQ project. In this paper, we present an "apples-to-apples" comparison of PostgreSQL query processing overhead with and without eddies. Our results show that with some minor tuning, the overhead of the eddy mechanism is negligible.Keywords
This publication has 4 references indexed in Scilit:
- Tuple Routing Strategies for Distributed EddiesPublished by Elsevier ,2003
- Continuously adaptive continuous queries over streamsPublished by Association for Computing Machinery (ACM) ,2002
- EddiesPublished by Association for Computing Machinery (ACM) ,2000
- Query evaluation techniques for large databasesACM Computing Surveys, 1993