# # ChangeLog for /sql # # Generated by Trac 0.10.3 # 05/24/13 10:34:09 # 10/09/09 19:09:46 Robert Treat <robert@omniti.com> [0136c0f3f48fe6e4addf4d56caccce5608118f37] * sql/sprocs/stratcon.init_metric_numeric_rollup_5m.sql (added) * sql/sprocs/stratcon.init_rollup_matrix_numeric_5m.sql (deleted) we should probably name this appropriatly, round duex 10/09/09 19:08:57 Robert Treat <robert@omniti.com> [5670e468848cf3cd4817132422126141c540863a] * sql/sprocs/stratcon.init_rollup_matrix_numeric_5m.sql (modified) we should probably name this appropriatly 10/09/09 19:06:57 Robert Treat <robert@omniti.com> [c24c74b1cb20b7f00adc69391d316f16c8da4d31] * sql/sprocs/stratcon.init_rollup_matrix_numeric_5m.sql (added) initialize emtpy arrays for storage 10/02/09 20:18:13 Denish Patel <denish@omniti.com> [b9af7580cb21afd3490880bfc2830a14ed242b38] * sql/sprocs/stratcon.fetch_varset.sql (modified) stratcon.loading_dock_metric_text_s_change_log should be noit.metric_text_changelog 10/02/09 20:15:24 Denish Patel <denish@omniti.com> [2a0ae7f26e6d4261f0b0afb4e271488a2455a4e2] * sql/sprocs/noit.metric_text_archive_log_changes.sql (modified) Trigger Function noit.metric_text_archive_log_changes 10/02/09 20:10:13 Denish Patel <denish@omniti.com> [1d598ad3c8038009189e67c3da0eaa05953a1edc] * sql/sprocs/noit.metric_text_archive_log_changes.sql (added) place for noit.metric_text_archive_log_changes 10/02/09 20:07:59 Denish Patel <denish@omniti.com> [544a1ea5a8955bbe0932db12162b6fb260cd89e9] * sql/sprocs/stratcon.metric_name_summary_tsvector.sql (modified) Changed variable name to match with column name to avoid further conusion for ts_search_all vs fts_data 10/02/09 20:05:41 Denish Patel <denish@omniti.com> [ae19db0fd28c28eccecf646249d15a8ad3bd6851] * sql/sprocs/noit.update_metric_summary_fulltext.sql (modified) * sql/sprocs/noit.update_mns_via_check_tag.sql (modified) * sql/sprocs/noit.update_mns_via_metric_tag.sql (modified) * sql/sprocs/noit.update_mns_via_self.sql (modified) Updated trigger functions related to metric_name_summary as we changed column name from ts_search_all to fts_data 10/02/09 19:58:40 Denish Patel <denish@omniti.com> [2407bbfb4b4102e4faceeca0dd9510862b01c344] * sql/sprocs/noit.update_mns_via_metric_tag.sql (modified) Trigger function noit.update_mns_via_metric_tag 10/02/09 19:56:50 Denish Patel <denish@omniti.com> [3b2f82c766ae4877378154731023a27447192e2b] * sql/sprocs/noit.update_mns_via_metric_tag.sql (added) stub for noit.update_mns_via_metric_tag 10/02/09 19:52:45 Denish Patel <denish@omniti.com> [f2f2353e4dd7ecf5cd5016d921a77166c57a235b] * sql/sprocs/noit.check_status_archive_log_changes.sql (modified) Trigger function noit.check_status_archive_log_changes 10/02/09 19:19:21 Denish Patel <denish@omniti.com> [ec157f4aeccb329d265b86c5af1a8e103ce85c4f] * sql/sprocs/noit.check_status_archive_log_changes.sql (added) place for noit.check_status_archive_log_changes 10/02/09 19:14:29 Denish Patel <denish@omniti.com> [978cc49fa9053924e4eabdf90e77664a8a8da630] * sql/sprocs/noit.update_metric_summary_fulltext.sql (modified) updated noit.update_metric_summary_fulltext 10/02/09 19:10:36 Denish Patel <denish@omniti.com> [89da11dfe1603e9e3dd239922a65372058f925fe] * sql/sprocs/noit.update_metric_summary_fulltext.sql (added) stub place for noit.update_metric_summary_fulltext 10/02/09 19:03:47 Denish Patel <denish@omniti.com> [4ff346a7dcd198c02bb08809ffc8fe5cf6f613d9] * sql/sprocs/noit.update_mns_via_self.sql (modified) Added noit.update_mns_via_self 10/02/09 18:53:59 Denish Patel <denish@omniti.com> [426d0fd8097a20882bfc6c83f302d4f034b35e15] * sql/sprocs/noit.update_mns_via_self.sql (added) place for noit.update_mns_via_self 10/02/09 18:50:32 Robert Treat <robert@omniti.com> [aa30d3163c60516fad188cf6c9e0341a9895a6dd] * sql/sprocs/noit.check_archive_log_changes.sql (modified) trigger function for check_archive_changelog 10/02/09 18:45:01 Denish Patel <denish@omniti.com> [1cb12d1bd5a9021a4249d44f0a80de3a36e848c9] * sql/sprocs/noit.mark_metric_numeric_rollup_buffer.sql (added) updated noit.mark_metric_numeric_rollup_buffer 10/02/09 18:27:51 Denish Patel <denish@omniti.com> [7bdcc136d61994452c7859ab1437d1b6a3af6402] * sql/sprocs/noit.update_mns_via_check_tag.sql (modified) updated noit.update_mns_via_check_tag 10/02/09 18:24:04 Denish Patel <denish@omniti.com> [747802282ccab1d4eb70c32d900e96abd5af005d] * sql/sprocs/noit.update_mns_via_check_tag.sql (added) stub for noit.update_mns_via_check_tag 10/02/09 18:17:28 Robert Treat <robert@omniti.com> [d0f32e941f25b35bb1b266c88cd201603e687759] * sql/sprocs/noit.check_archive_log_changes.sql (added) stub for check_archive trigger func 10/02/09 16:26:44 Robert Treat <robert@omniti.com> [2b8f8c20cf8db128b58a867bceb25006514a662e] * sql/tables/noit.check_tag.sql (modified) * sql/tables/noit.metric_name_summary.sql (modified) * sql/tables/noit.metric_numeric_rollup_queue.sql (modified) * sql/tables/noit.metric_tag.sql (modified) * sql/tables/noit.tasklock.sql (modified) fix up bugs now that it's tested 10/01/09 19:55:31 Denish Patel <denish@omniti.com> [6bf36f96f69a29ee3b0fe2ce43262b4898eabc65] * sql/sprocs/stratcon.metric_name_summary_tsvector.sql (added) stratcon.metric_name_summary_tsvector function 10/01/09 19:12:52 Denish Patel <denish@omniti.com> [efff2d97f875ae97b5b8083173c63b45af7e29df] * sql/sprocs/stratcon.fetch_varset.sql (modified) * sql/sprocs/stratcon.window_robust_derive.sql (added) added stratcon.window_robust_derive 10/01/09 18:52:07 Denish Patel <denish@omniti.com> [176662823c617f275f16583569d617151ef34731] * sql/sprocs/stratcon.fetch_varset.sql (added) fetch varset functions 10/01/09 18:24:01 Denish Patel <denish@omniti.com> [161a5c5dbc37986a5d1c5ce66869d4504f97f0eb] * sql/sprocs/noit.choose_window.sql (deleted) * sql/sprocs/noit.fetch_dataset.sql (deleted) * sql/sprocs/stratcon.choose_window.sql (added) * sql/sprocs/stratcon.fetch_dataset.sql (added) Change schema to stratcon and modified functions to be secturity definer 10/01/09 18:10:47 Denish Patel <denish@omniti.com> [b57ec8315f866c742be1da0a080ee0c836ff02a1] * sql/sprocs/noit.choose_window.sql (added) * sql/sprocs/noit.fetch_dataset.sql (added) noit functions related to fetch data 10/01/09 18:08:18 Robert Treat <robert@omniti.com> [003566b519017539659f61ab68d038cb3218e43b] * sql/sprocs/stratcon.get_storage_node_for_sid.sql (added) * sql/sprocs/stratcon.map_uuid_to_sid.sql (added) give me a uuid and it's noit, i'll give you a sid and which node to put it on 09/30/09 17:14:36 Robert Treat <robert@omniti.com> [3b8a086327fecf81c67436b95e046185bd2dad97] * sql/dblayout.txt (added) what are we up to? 09/30/09 17:08:09 Robert Treat <robert@omniti.com> [30ba483a94e1eaee4fc0b743d7126f60ffb8a908] * sql/tables/stratcon.tasklock.sql (deleted) straggling file rename 09/30/09 17:07:46 Robert Treat <robert@omniti.com> [420b34c7d61262546669125ae17b29becad77298] * sql/tables/noit.tasklock_sequence.sql (added) actually, this should be in noit schema, though we do want to leave it decoupled 09/30/09 17:04:25 Robert Treat <robert@omniti.com> [81f7001e39e1c3484d225b7a609fc803c86ba5ef] * sql/tables/noit.tasklock.sql (added) * sql/tables/stratcon.tasklock.sql (modified) new task locking infrastructure 09/30/09 16:52:30 Robert Treat <robert@omniti.com> [64c35d610d430e39870bc67c35bdf49298ba29f8] * sql/tables/noit.check_changelog.sql (deleted) * sql/tables/noit.metric_numeric_rollup_buffer.sql (deleted) file renames 09/30/09 16:52:12 Robert Treat <robert@omniti.com> [e0b4c4bf93b3aea304cd8cf9e9f7a02f9cc79a88] * sql/tables/noit.metric_numeric_rollup_queue.sql (added) queue for tracking which numeric intervals need to be rolled up 09/30/09 16:44:33 Robert Treat <robert@omniti.com> [392462ca87d64f403a0ac61c95102e6611b362f3] * sql/tables/noit.check_status_archive.sql (modified) status type check table 09/30/09 16:41:15 Robert Treat <robert@omniti.com> [5745519bbdae8e0191e208603505894084660654] * sql/tables/noit.metric_numeric_archive.sql (modified) numeric metrics 09/30/09 16:14:10 Robert Treat <robert@omniti.com> [77e875df87c94f8cd2b8fbc32fbe360623e759b8] * sql/tables/noit.metric_numeric_rollup_12hours.sql (modified) * sql/tables/noit.metric_numeric_rollup_20m.sql (modified) * sql/tables/noit.metric_numeric_rollup_60m.sql (modified) * sql/tables/noit.metric_numeric_rollup_6hours.sql (modified) adding schema for rollup tables, with array based storage 09/29/09 22:22:18 Robert Treat <robert@omniti.com> [88d5aaab122fefd6471e1d4604f54cd1a6df433b] * sql/tables/noit.metric_text_archive.sql (modified) * sql/tables/noit.metric_text_changelog.sql (modified) * sql/tables/noit.metric_text_currently.sql (modified) text metric tables 09/29/09 21:53:51 Robert Treat <robert@omniti.com> [3e3863d0f5b6548f78558042bd6c87f71145a732] * sql/tables/noit.metric_name_summary.sql (modified) metric name summary 09/29/09 21:43:28 Robert Treat <robert@omniti.com> [3278b4e18773a14f0cf214226356adbc065fa9be] * sql/tables/noit.check_tag.sql (modified) * sql/tables/noit.metric_tag.sql (modified) tag tables 09/29/09 20:59:27 Robert Treat <robert@omniti.com> [378ef447b1015a081fe182f16097392fa036a9ce] * sql/tables/noit.check_status_changelog.sql (modified) check status tables 09/29/09 20:53:19 Robert Treat <robert@omniti.com> [ff905e92ad93d8c9a71dcfc0d1825f3667a22c01] * sql/tables/noit.check_archive.sql (modified) fix whoopsies 09/29/09 20:48:20 Robert Treat <robert@omniti.com> [35417f1d20ade67bfbf99b03c861fe1756ee11cd] * sql/tables/noit.check_archive.sql (modified) * sql/tables/noit.check_currently.sql (added) layout of primary check tables 09/29/09 20:22:36 Robert Treat <robert@omniti.com> [4e7af0052829e39e8da8375b559e9be499b247c2] * sql/tables/noit.metric_numeric_rollup_5m.sql (modified) store data in chunks as array values to save storage space 09/29/09 20:12:34 Robert Treat <robert@omniti.com> [a34bc1266a0a4f7fa69f17c5957f160162a4398d] * sql/tables/noit.check_archive.sql (added) * sql/tables/noit.check_changelog.sql (added) * sql/tables/noit.check_status_archive.sql (added) * sql/tables/noit.check_status_changelog.sql (added) * sql/tables/noit.check_tag.sql (added) * sql/tables/noit.metric_name_summary.sql (added) * sql/tables/noit.metric_numeric_archive.sql (added) * sql/tables/noit.metric_numeric_rollup_12hours.sql (added) * sql/tables/noit.metric_numeric_rollup_20m.sql (added) * sql/tables/noit.metric_numeric_rollup_5m.sql (added) * sql/tables/noit.metric_numeric_rollup_60m.sql (added) * sql/tables/noit.metric_numeric_rollup_6hours.sql (added) * sql/tables/noit.metric_numeric_rollup_buffer.sql (added) * sql/tables/noit.metric_tag.sql (added) * sql/tables/noit.metric_text_archive.sql (added) * sql/tables/noit.metric_text_changelog.sql (added) * sql/tables/noit.metric_text_currently.sql (added) * sql/tables/stratcon.current_node_config.sql (added) * sql/tables/stratcon.map_uuid_to_sid.sql (added) * sql/tables/stratcon.storage_node.sql (added) * sql/tables/stratcon.tasklock.sql (added) map table plus placeholders for upcoming schema 07/10/09 00:26:52 Theo Schlossnagle <jesus@omniti.com> [06519e0d896bfca30746212670c342a1b84a74a5] * sql/reconnoiter_ddl_dump.sql (modified) Patch from Dan. fixes #153 06/15/09 23:07:39 Theo Schlossnagle <jesus@omniti.com> [f6540baac0ed25babb2a91d9b715988abb653bcb] * sql/crontab (modified) * sql/dump.sh (added) * sql/reconnoiter_ddl_dump.sql (modified) * src/stratcon.conf.in (modified) * src/stratcon_datastore.c (modified) flag-day(stratcond,database) partition the loading docks, refs #140 06/10/09 17:39:06 Denish Patel <denish@omniti.com> [9d38c6543b77583aaef091ecd0e2903e89067d0b] * sql/reconnoiter_ddl_dump.sql (modified) updated schema ddl 05/20/09 23:49:08 Theo Schlossnagle <jesus@omniti.com> [6adb5a7837cf0e5945ed038897c9b08c7259701c] * sql/README (added) * sql/reconnoiter_ddl_dump.sql (modified) update the schema, remove unnecessary crap 04/09/09 20:55:04 Denish Patel <denish@omniti.com> [a647406d9e447fa4cb7212f74bc63a1fcf52dfea] * sql/reconnoiter_ddl_dump.sql (modified) updated pgdump ddl 03/28/09 02:14:16 Theo Schlossnagle <jesus@omniti.com> [17a8e8e4556d3b18451fd9531ef964be402a98d0] * sql/reconnoiter_ddl_dump.sql (modified) make the counter_dev stuff much more intelligent and accommodating of rolling counters if data is collected 'fast enough'. Fixes #110 03/26/09 21:58:11 Denish Patel <denish@omniti.com> [c3a1f2e12de43c398369bb5a3f902eebde93f9bb] * sql/reconnoiter_ddl_dump.sql (modified) checking in postgres ddl dump 03/21/09 02:07:35 Robert Treat <robert@omniti.com> [e3e35fcfbb73d6001f7b6dca7ff7311e1148ccfb] * sql/reconnoiter_ddl_dump.sql (modified) use gin index for tsvectors 12/03/08 21:32:30 Denish Patel <denish@omniti.com> [9295ab0de02cda482cfd2a5762f8a76727b480d1] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl update 12/03/08 17:37:57 Denish Patel <denish@omniti.com> [ea0809f5e7f454f5e874bca7d79be8e2d6a10789] * sql/crontab (modified) Added job to cleanup prism.saved_graphs table with saved_graphs=false. 11/20/08 23:03:02 Denish Patel <denish@omniti.com> [f67c8f851568c1e75293edbe51cd405f940bab8b] * sql/reconnoiter_ddl_dump.sql (modified) updated saved_graphs before i/u trigger function 11/04/08 20:23:11 Denish Patel <denish@omniti.com> [d4547fc2ca717194bd02bda7276a0efa26d120d0] * sql/reconnoiter_ddl_dump.sql (modified) prism.saved_graphs triggers adjustments 10/16/08 16:17:38 Denish Patel <denish@omniti.com> [be06d4c772959d7f67b61729ed0fcfa446eb59a4] * sql/reconnoiter_ddl_dump.sql (modified) fixed ownership of tables 10/14/08 19:00:42 Denish Patel <denish@omniti.com> [c256764571a55858b9a8db0f8905c297ec481926] * sql/reconnoiter_ddl_dump.sql (modified) updated remove_metric function 10/13/08 21:12:29 Denish Patel <denish@omniti.com> [9e9c974e402a479ebbc927ca69c82166708b2d80] * sql/reconnoiter_ddl_dump.sql (modified) another fix for saved graph serach 10/13/08 18:13:40 Denish Patel <denish@omniti.com> [04c2ba0f9a1814ea044e5060104e73817640055d] * sql/reconnoiter_ddl_dump.sql (modified) Fixed sved graphs trigger 10/07/08 14:29:57 Denish Patel <denish@omniti.com> [848c999201996fa821ee897f8bc9e3c0979a575f] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl export 09/26/08 21:14:54 Denish Patel <denish@omniti.com> [fb7be7b187d801c131a11404d2c489a6fc8350a6] * sql/reconnoiter_ddl_dump.sql (modified) Modified function and trigger for saved_graphs as it was messing up with search results 09/25/08 19:24:59 Denish Patel <denish@omniti.com> [c73b2b53bb74c7e8135888bc652903c9327f7dbd] * sql/reconnoiter_ddl_dump.sql (modified) granted more privs to stratcon user 09/25/08 16:07:48 Denish Patel <denish@omniti.com> [15df64bd213a7a14a521d3d2d4418ee9379272aa] * sql/reconnoiter_ddl_dump.sql (modified) implemented add/remove tags functionality for graphs and created function to update ts_search_all vector based on title and graph_tags, applied trigger to call the function on saved_graphs 09/25/08 01:18:36 Denish Patel <denish@omniti.com> [43ec19ac079e004379a4c8d8117756c8d622eff8] * sql/reconnoiter_ddl_dump.sql (modified) added index 09/24/08 20:45:15 Denish Patel <denish@omniti.com> [75075e2a62f4974e24117f519581ad75b2a083c4] * sql/reconnoiter_ddl_dump.sql (modified) Moved metric_tags from prism schema to stratcon and grant all table to prism, modified all functions,triggers to reflect the changes 09/24/08 19:50:24 Denish Patel <denish@omniti.com> [f3544432ddf95a1f7eabd18d8fa0f355191362eb] * sql/reconnoiter_ddl_dump.sql (modified) Added search and tags functionalities 09/22/08 18:09:27 Denish Patel <denish@omniti.com> [146a7f3bfbf2f113f1cbdba31a2ba3e575d3e2f8] * sql/reconnoiter_ddl_dump.sql (modified) Full database dump 09/22/08 18:00:45 Denish Patel <denish@omniti.com> [9f9d948f5f91f25c6ec5d43a5ddcd1143e30fd45] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl update-- alter schema statrcon owner to reconnoiter 09/22/08 17:57:16 Denish Patel <denish@omniti.com> [70d8a8f096162b8f5ef06f5668066b9e7e942814] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl update 08/26/08 01:25:15 Theo Schlossnagle <jesus@omniti.com> [0a06b2cbef3380c0fa794480d2fae8b4b1431f92] * Makefile.in (modified) * buildtools/install-sh (added) * buildtools/mkinstalldirs (added) * configure.in (modified) * sql/Makefile.in (added) * src/Makefile.in (modified) * src/modules-lua/Makefile.in (added) * src/modules/Makefile.in (modified) refs #50 08/26/08 00:24:40 Theo Schlossnagle <jesus@omniti.com> [60d776d5d65d4ceec7b23dbddb1d8e3893c97571] * sql/schema.sql (deleted) just use reconnoiter_ddl_dump.sql as the master 08/11/08 20:58:43 Denish Patel <denish@omniti.com> [8c44e3b0e275f77a5f98f49c8b0ae180976694e9] * sql/reconnoiter_ddl_dump.sql (modified) dump stratcon schema 08/03/08 19:23:21 Theo Schlossnagle <jesus@omniti.com> [3be398539c4bcd0e77acf4390c6dda1635329b58] * sql/crontab (added) people are gonna need this crontab to see rollups 07/12/08 15:13:51 Theo Schlossnagle <jesus@omniti.com> [356779758e509ee0f1a2f419e9fab1d48fdc3c33] * sql/schema.sql (modified) implement a materialized view on the most recent metric_text change (need speed!) 07/11/08 19:40:02 Denish Patel <denish@omniti.com> [4aae95d137f38b64f49d27c9611b1fba6242666a] * sql/reconnoiter_ddl_dump.sql (modified) updated Reconniter DDL dump 07/11/08 19:35:19 Denish Patel <denish@omniti.com> [47b88b010a032a620acac2e7dff46570fe80d64a] * sql/schema.sql (modified) corrected error warning for stratcon.mv_loading_dock_check_s() 07/10/08 18:34:28 Theo Schlossnagle <jesus@omniti.com> [e94863c5d22e2229730530ce3039661489cbbd73] * sql/schema.sql (modified) make the fetch_ procedures also accept sids 07/10/08 16:49:20 Denish Patel <denish@omniti.com> [adba02c5fdb37a1095d0d170a8cf31937dbedbb0] * sql/schema.sql (modified) added mv_loading_dock_check_s() trigger function and related table/indexes. 07/10/08 02:51:36 Theo Schlossnagle <jesus@omniti.com> [ee3bbe783b5e3fcbb1febb6a523e12550d04d90d] * sql/schema.sql (modified) fix bug in update config and revert the out-of-order text metric support as it is just too expensive, closes #45 07/02/08 18:29:43 Denish Patel <denish@omniti.com> [5366a70920df98ecf37fed906dfe718d250c4ec1] * sql/reconnoiter_ddl_dump.sql (modified) Exported Latest DDL dump 07/01/08 14:14:22 Theo Schlossnagle <jesus@omniti.com> [e0795d09a594dd276dd59643a85230388401fb06] * sql/schema.sql (modified) fix up insert function for config info, refs #26 06/30/08 19:32:15 Denish Patel <denish@omniti.com> [7710784460d9831062155d3e99f3bf22e4d978b0] * sql/schema.sql (modified) added node configuration tables and trigger. 06/16/08 19:16:10 Denish Patel <denish@omniti.com> [6b9f38ffb400becb8ab312d34abd2981bca9fe87] * sql/schema.sql (modified) remove min/max values from rollup tables/functions. 06/06/08 20:42:16 Denish Patel <denish@omniti.com> [601c99b9ea251da8e30fe85e055c372a540491ee] * sql/schema.sql (modified) Exception handling UNIQUE_VIOLATION in log_whence_change_log function. 06/06/08 17:57:15 Denish Patel <denish@omniti.com> [d95460a5334988d9e1dc8c94c3eefbaf222c2d48] * sql/schema.sql (modified) exception handing on stratcon.loading_dock_metric_numeric_s_whence_log 06/01/08 02:38:47 Theo Schlossnagle <jesus@omniti.com> [23df8e9f199cb077a586490d9d495708b62bd93e] * sql/schema.sql (modified) fix PK 05/30/08 20:42:07 Denish Patel <denish@omniti.com> [6390014a64eb9ab5483bc88e66779b6c0ef7a20d] * sql/reconnoiter_ddl_dump.sql (added) Added DDL dump for reconnointer database 05/30/08 20:33:26 Denish Patel <denish@omniti.com> [99564b3a9f761d3fb72e07eaa38809b4ff64c558] * sql/schema.sql (modified) Updated Text change log trigger function to log older data changes too. 05/24/08 00:33:16 Theo Schlossnagle <jesus@omniti.com> [6ea1dad6f00d20ef52591c282ffc9b1e002d5420] * sql/schema.sql (modified) Oops.. This caused every line in loading_dock_status_s to be considered as a change 05/22/08 21:11:14 Denish Patel <denish@omniti.com> [197579c398b7365b2eea60f9b2245fdf72ada185] * sql/schema.sql (modified) Grants. 05/22/08 21:08:22 Denish Patel <denish@omniti.com> [809b898d87dcc7153a3360ebb67c91113854f9a7] * sql/schema.sql (modified) Added Remove_mtric function; 05/21/08 20:41:30 Denish Patel <denish@omniti.com> [3b875de14155ab34c26bdae600fc2827218f85f2] * sql/schema.sql (modified) better handling NOTICE for running job. 05/21/08 20:25:37 Denish Patel <denish@omniti.com> [a2c8a40a569ad8bc6677c21303849d5844ce5436] * sql/schema.sql (modified) Updated roll ups functions to process all available records from log_whence_s table by interval. 05/14/08 20:34:00 Denish Patel <denish@omniti.com> [b927b3bbf9eeab57dc26e56d2eddfea8cc199a49] * sql/schema.sql (modified) updated sequence ddl to start with 1. 05/14/08 20:10:38 Denish Patel <denish@omniti.com> [a7da22e2c7fcc5e15bb1a4e4ab695d6a0c560b43] * sql/schema.sql (modified) Added date_trunc('hour',rollup_time) index on 20m rollup tables so we can use during 1 hour rollup_table function. 05/14/08 18:45:06 Denish Patel <denish@omniti.com> [be8707fb024addfa6eb855a9d160e6f2b5afec3f] * sql/schema.sql (modified) Replace TIMESTAMP with TIMESTAMPTZ. 05/14/08 15:31:43 Denish Patel <denish@omniti.com> [152d473243c4c0e838439fd654a698515e8288fc] * sql/schema.sql (modified) stddev_value removed. 05/14/08 00:54:13 Theo Schlossnagle <jesus@omniti.com> [5de3ee066898c7932e978dbe8224ca4e280635cb] * sql/schema.sql (modified) fix the triggers.. the row itself is called nam, the summary is metric_name. Also, move the if not found's in the windowed functions to be immediately after window selection