pboro | Hmm... there's no Ingres DTP plugin for DTP 1.7? | 00:36 |
---|---|---|
pboro | ahh, it's available from Galileo site | 00:45 |
pboro | excellent :) | 00:46 |
*** dyki has joined #ingres | 01:20 | |
*** Deyan has joined #ingres | 02:00 | |
Deyan | hi everybody | 02:00 |
Deyan | select * from ii_log where nickname='pboro'; | 02:00 |
Deyan | \p\g | 02:01 |
*** Deyan has quit IRC | 02:23 | |
*** toumi01 has joined #ingres | 03:32 | |
*** toumi01 has quit IRC | 04:09 | |
*** dyki has quit IRC | 04:09 | |
*** Vroomfondle has quit IRC | 04:09 | |
*** pboro has quit IRC | 04:09 | |
*** bonro01 has quit IRC | 04:09 | |
*** thiagomz has quit IRC | 04:09 | |
*** toumi01 has joined #ingres | 04:10 | |
*** dyki has joined #ingres | 04:10 | |
*** pboro has joined #ingres | 04:10 | |
*** thiagomz has joined #ingres | 04:10 | |
*** bonro01 has joined #ingres | 04:10 | |
*** Vroomfondle has joined #ingres | 04:10 | |
*** dyki has quit IRC | 04:25 | |
*** toumi01 has quit IRC | 04:25 | |
*** Vroomfondle has quit IRC | 04:25 | |
*** bonro01 has quit IRC | 04:25 | |
*** pboro has quit IRC | 04:25 | |
*** thiagomz has quit IRC | 04:25 | |
*** toumi01 has joined #ingres | 04:26 | |
*** dyki has joined #ingres | 04:26 | |
*** pboro has joined #ingres | 04:26 | |
*** thiagomz has joined #ingres | 04:26 | |
*** bonro01 has joined #ingres | 04:26 | |
*** Vroomfondle has joined #ingres | 04:26 | |
*** rossand has joined #ingres | 05:14 | |
*** ChanServ sets mode: +o rossand | 05:14 | |
*** atrofast1 has quit IRC | 05:23 | |
*** atrofast has joined #ingres | 05:31 | |
thiagomz | Guys, can anyone suggest me changes in my logging system based on that ==> http://pastebin.com/m72c45939 | 05:57 |
pboro | how long has it been running before running the summary? | 05:59 |
pboro | it looks like there could be more buffers since >90% of buffers are in use most of the time | 06:00 |
pboro | hmm... but "All logwriters busy" is pretty low compared to the number of transactions | 06:02 |
magnusg| | Maybe an increase of the size of the log buffers. | 06:02 |
magnusg| | From 4K o 8K | 06:03 |
thiagomz | pboro: 2 days, I restarted the server on sunday... | 06:03 |
thiagomz | i was thinking in resize my log buffer from 1M to more... | 06:04 |
*** atrofast has quit IRC | 06:09 | |
*** rossand has quit IRC | 06:09 | |
*** dyki has quit IRC | 06:09 | |
*** toumi01 has quit IRC | 06:09 | |
*** Vroomfondle has quit IRC | 06:09 | |
*** bonro01 has quit IRC | 06:09 | |
*** pboro has quit IRC | 06:09 | |
*** thiagomz has quit IRC | 06:09 | |
*** Nornagest has quit IRC | 06:09 | |
*** magnusg| has quit IRC | 06:09 | |
*** clach04 has quit IRC | 06:09 | |
*** Alex| has quit IRC | 06:09 | |
*** FrankW has quit IRC | 06:18 | |
*** magnusg| has joined #ingres | 06:28 | |
*** clach04 has joined #ingres | 06:28 | |
*** Nornagest has joined #ingres | 06:28 | |
*** Alex| has joined #ingres | 06:28 | |
*** Deyan] has joined #ingres | 06:28 | |
*** Vroomfondle has joined #ingres | 06:28 | |
*** bonro01 has joined #ingres | 06:28 | |
*** pboro has joined #ingres | 06:28 | |
*** dyki has joined #ingres | 06:28 | |
*** toumi01 has joined #ingres | 06:28 | |
*** atrofast has joined #ingres | 06:28 | |
*** rossand has joined #ingres | 06:28 | |
*** irc.freenode.net sets mode: +oo Alex| rossand | 06:28 | |
*** thiagomz has joined #ingres | 06:29 | |
atrofast | Hey all, in Ingres, is schema == owner of a table or is there a more subtle disctinction between them? | 06:45 |
atrofast | distinction even | 06:46 |
*** rossand has quit IRC | 07:11 | |
*** magnusg| has left #ingres | 07:51 | |
Deyan] | atrofast: i was wondering the same | 08:02 |
atrofast | If no one knows on top of their head, time to troll the docs :) | 08:03 |
atrofast | Seems like a schema is associated with a username: http://docs.ingres.com/Ingres/9.2/SQL%20Reference%20Guide/createschema.htm | 08:27 |
*** Alex| is now known as Alex|off | 08:41 | |
*** grantc has joined #ingres | 09:21 | |
*** ChanServ sets mode: +o grantc | 09:21 | |
*** mull has joined #ingres | 09:22 | |
*** DerMeister has joined #ingres | 09:25 | |
*** Gerhard has joined #ingres | 09:29 | |
*** grantc has left #ingres | 09:33 | |
*** Deyan] has quit IRC | 09:39 | |
*** dyki has quit IRC | 09:44 | |
*** DerMeister has quit IRC | 09:57 | |
*** Gerhard has quit IRC | 10:09 | |
*** adrianwarwickuni has joined #ingres | 10:28 | |
thiagomz | guys, is there a more easy way to calculate hit ratios from a trace point dm420, than looking in each dbms for fix calls and hits, etc... ? | 10:29 |
thiagomz | for each configured cache... | 10:30 |
adrianwarwickuni | Does Ingres perform any "whole program optimization"? For example, suppose an SQL user-defined function OP takes a parameter named X and a query invokes OP for every tuple with the constant 1 for X (and some other arguments variable). If OP contains a block IF X < 1... then when the compiler retrieves the definition of OP from the catalog will it further optimize OP to remove the branching code? | 10:38 |
thiagomz | adrianwarwickuni: you are talking about bind variables ? | 10:46 |
thiagomz | adrianwarwickuni: like in oracle ? | 10:46 |
adrianwarwickuni | No, I'm talking about SQL code (without bind variables) calling a stored procedure and it being conceivable to specialize the procedure code to perform better for the context where it's being called. Bind variables are for the exact opposite scenario, i.e. to avoid compiling many very similar queries - generalization. | 10:51 |
*** Alex|off is now known as Alex| | 10:51 | |
adrianwarwickuni | It's also known as interprocedural optimization. | 10:54 |
adrianwarwickuni | (in compiler design circles) | 10:54 |
thiagomz | Guys, in imadb - ima_dbms_server_parameters - startup_time, anyone knows how to calculate the uptime ? | 11:46 |
atrofast | In the Ingres backend, how can I extract readable information (data type, name etc) from the DMU_CB.dmu_attr_array? | 12:20 |
atrofast | Ah cast the dmu_attr_array.ptr_address to DMU_ATTR_ENTRY | 13:01 |
*** rossand has joined #ingres | 13:10 | |
*** ChanServ sets mode: +o rossand | 13:10 | |
*** Alex| is now known as Alex|off | 13:37 | |
*** rossand has quit IRC | 13:43 | |
*** rossand has joined #ingres | 13:50 | |
*** ChanServ sets mode: +o rossand | 13:50 | |
*** rossand has quit IRC | 14:18 | |
*** adrianwarwickuni has quit IRC | 14:23 | |
*** mull has quit IRC | 15:21 | |
*** bonro01 has quit IRC | 18:55 | |
*** bonro01 has joined #ingres | 19:41 | |
*** toumi01 has quit IRC | 19:52 | |
*** rossand has joined #ingres | 20:03 | |
*** ChanServ sets mode: +o rossand | 20:03 | |
*** rossand has quit IRC | 20:55 | |
*** rossand has joined #ingres | 20:56 | |
*** ChanServ sets mode: +o rossand | 20:56 | |
*** zxiiro has joined #ingres | 21:14 | |
*** ChanServ sets mode: +v zxiiro | 21:14 | |
*** zxiiro has quit IRC | 21:14 | |
*** rossand has quit IRC | 21:19 | |
*** Alex|off is now known as Alex| | 22:35 | |
*** Alex| is now known as Alex|off | 23:04 | |
*** magnusg| has joined #ingres | 23:08 | |
*** Alex|off is now known as Alex| | 23:18 | |
*** DarylM has joined #ingres | 23:22 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!