public.commandprompt.com: Issueshttps://public.commandprompt.com/https://public.commandprompt.com/favicon.ico?16484970162008-07-23T02:21:23Zpublic.commandprompt.com
Redmine Odbcng - Feature #4873 (New): Win64 versionhttps://public.commandprompt.com/issues/48732008-07-23T02:21:23Zbford -bford@foo.bar
<p>Check ODBCng for compatibility with Windows x64.</p> Pggraph - Bug #4945 (New): Force all graphs to abort if non-specific data specifiedhttps://public.commandprompt.com/issues/49452008-07-15T15:32:45ZAurynn Shawashaw@commandprompt.com
<p>For all graphs, prevent date ranges from working if:</p>
<ul>
<li>High-level, multi-graph pages would be generated normally</li>
<li>Non-specific data is passed to the graphing function.
<ul>
<li>For pggraph_database, it REQUIRES a datname</li>
<li>For pggraph_table, it requires a datname, a tablename and a schemaname</li>
<li>For pggraph_index, it requires a datname, an indexname, and a schemaname</li>
</ul></li>
</ul> Pggraph - Bug #4943 (New): Future Planning and Ideashttps://public.commandprompt.com/issues/49432008-07-14T11:32:17ZAurynn Shawashaw@commandprompt.com
<ul>
<li>Javascript+SVG-based graphs, based on example code Darcy showed off a while back. This would allow us to do offset-based graphs (clicking an offset of, say, 5 days scrolls it back in time that far), as well as the ability to do click & drag ala the Google Maps interface.</li>
</ul> Pggraph - Bug #4940 (New): Remove prefixeshttps://public.commandprompt.com/issues/49402008-07-14T11:05:46ZAurynn Shawashaw@commandprompt.com
<p>As we are moving to a schema'd design, remove the prefix additions from the code and all new installations.</p>
<p>This involves a plpgsql function signature change.</p> Pggraph - Bug #4937 (New): Modification of DB Client code for date rangeshttps://public.commandprompt.com/issues/49372008-07-14T10:45:13ZAurynn Shawashaw@commandprompt.com
<p>The client code needs to be modified to take advantage of the new date range function signatures.</p>
<p>This will require:</p>
<ul>
<li>Modification of the functions that call the DB functions.
<ul>
<li>Ideally (and this will be a new ticket) I'd like to write the transparent python->db function mapper (obj.func(arg,arg) gets seamlessly converted to SELECT * FROM func(arg,arg))</li>
</ul></li>
</ul> Pggraph - Bug #4936 (New): Modify averaging functionshttps://public.commandprompt.com/issues/49362008-07-14T10:11:55ZAurynn Shawashaw@commandprompt.com
<p>All plpgsql functions will need two new arguments, and one removed argument:</p>
<p>start DATE, end DATE, and removal of offset INT.</p>
<p>The functions will be altered in the following ways:</p>
<ul>
<li>Determining the length of the WHILE loop from the date ranges, if present, instead of using the interval to calculate it.</li>
<li>Alter the queries to use the start DATE parameter to position the start of the set, and then utilize the WHILE loop to offset from that point, ie, WHERE date = date_start + (interval * iterations)::interval</li>
</ul> Odbcng - Bug #4872 (New): ODBCng + UNICODEhttps://public.commandprompt.com/issues/48722008-04-24T08:55:03Zbford -bford@foo.bar
<p>ODBCng doesn't pass perl DBD-ODBC unicode tests on Windows.<br />Current results:<br />Failed Test Stat Wstat Total Fail List of Failed<br />-------------------------------------------------------------------------------<br />t/40UnicodeRoundTrip.t 2 512 62 2 31 49<br />t/41Unicode.t 12 3072 55 12 35-40 49-54</p> Pggraph - Feature #4933 (New): Feature requests, pggraphhttps://public.commandprompt.com/issues/49332008-03-12T12:44:15ZAurynn Shawashaw@commandprompt.com
<p>From cashnet:</p>
<pre>
Should at least display timezone on graphs (would be better if this was configurable).
Unused indexes is too strict, assuming that it's just looking for 0 idxscans (since it's not showing that, I don't know... :) ). It should show index usage stats, and also include indexes that have low usage, perhaps compared to other indexes on the table, or to table stats.
It'd also be good to have a report of tables that could use indexes. I'll typically use a metric like tablescans * relpages, with a cap of say 100 or 200. If this was done with stats over time the metric would essentially be "here's tables that we're doing more than X sequential pages per $unit_time".
</pre> Pggraph - Feature #4932 (New): Have pggraph directly access Wiki passwordshttps://public.commandprompt.com/issues/49322007-12-31T10:28:34ZAurynn Shawashaw@commandprompt.com
<p>Should we have pggraph be on its own, independent password auth, or link it directly to the wiki pw auth?</p> Pggraph - Feature #4931 (New): Develop a nagios plugin for pggraph checkshttps://public.commandprompt.com/issues/49312007-12-18T19:24:29ZDevrim Gunduzdevrim@commandprompt.com
<p>Develop a nagios plugin for pggraph checks</p> Odbcng - Feature #4868 (New): Test environmenthttps://public.commandprompt.com/issues/48682007-11-27T20:48:55Zbford -bford@foo.bar
<p>We need an automatic testing system to run existing tests from exterior developers mixed with our own tests.</p> Odbcng - Feature #4866 (New): please post test caseshttps://public.commandprompt.com/issues/48662007-11-16T20:21:29Zbford -bford@foo.bar
<p>Now that we are using all the different tests for compatibility I would like to see a report on the wiki of the results of those tests.</p> Pggraph - Feature #4926 (New): insert/update/deletehttps://public.commandprompt.com/issues/49262007-08-20T16:15:10Zbford -bford@foo.bar
<p>We have the ability to see which relations did what type of dml for a given interval. However we don't have the ability to see that data database wide. What I would to see is on the database graph to have the option to select DML which would sum the n_tup_ins, n_tup_del and n_tup_update for all relations on the particular database and graph it based on the interval.</p> Pggraph - Feature #4925 (New): Allow graphing specific intervalshttps://public.commandprompt.com/issues/49252007-07-03T08:28:32ZDarcy Buskermolendarcyb@foo.bar
<p>Add the ability to graph a specific block of time.</p>
<p>IE I'd like to see the 10 minute graph from 2 weeks ago, so that I can inspect Foo. and corilate it with information provided by a customer.</p> Pggraph - Feature #4901 (New): pggraph_table doesn't list tableshttps://public.commandprompt.com/issues/49012006-12-29T17:18:15Zbford -bford@foo.bar
<p>If you go to the table graphing, it will not list the tables until you click show at least once. It would make sense to grab the table names on display of the page.</p>