| *** mc349 has quit IRC | 00:37 | |
| *** rossand has quit IRC | 02:41 | |
| *** elPiola has quit IRC | 02:45 | |
| *** elPiola has joined #ingres | 02:45 | |
| *** perftuning has quit IRC | 04:27 | |
| *** mc349 has joined #ingres | 08:07 | |
| *** grantc_offline is now known as grantc | 08:11 | |
| *** Alex|off is now known as Alex| | 08:29 | |
| *** ii_log` has joined #ingres | 08:34 | |
| *** ii_log has quit IRC | 08:35 | |
| *** ii_log` has left #ingres | 09:27 | |
| *** ii_log` has joined #ingres | 09:27 | |
| *** ii_log` is now known as ii_log | 09:28 | |
| *** zxiiro_ has quit IRC | 09:43 | |
| *** Alex| has quit IRC | 09:43 | |
| *** SlimeyPete has quit IRC | 09:43 | |
| *** pboro has quit IRC | 09:43 | |
| *** clach04 has quit IRC | 09:43 | |
| *** Nornagest has quit IRC | 09:43 | |
| *** pboro has joined #ingres | 09:54 | |
| *** Alex| has joined #ingres | 09:55 | |
| *** zxiiro_ has joined #ingres | 09:55 | |
| *** SlimeyPete has joined #ingres | 09:55 | |
| *** irc.freenode.net sets mode: +o Alex| | 09:55 | |
| *** clach04 has joined #ingres | 09:56 | |
| *** Nornagest has joined #ingres | 09:56 | |
| *** Alex| is now known as Alex|off | 10:25 | |
| *** Alex|off is now known as Alex| | 11:28 | |
| *** Alex| is now known as Alex|off | 13:24 | |
| *** troal01 has left #ingres | 13:27 | |
| *** troal01 has joined #ingres | 13:29 | |
| troal01 | Could anyone direct me to a good document regarding partitioning in Ingres? | 13:31 |
|---|---|---|
| grantc | what are you looking for? | 13:33 |
| troal01 | Well I've got a table with too many rows essentially so I run out of tids... I need to partition it so that it will all fit | 13:36 |
| grantc | you need to add new data locations (see create location) then execute modify to regoranize | 13:37 |
| troal01 | What modify command exactly? | 13:38 |
| grantc | modify yourtablehere to reorganize WITH LOCATION = (loc1, loc2,...) | 13:39 |
| grantc | if you want to use table partitioning which is something different see http://docs.ingres.com/Ingres/9.2/SQL%20Reference%20Guide/createtable.htm#o1964 | 13:39 |
| troal01 | Ahh so with reorganize I can fit more in there then? | 13:40 |
| grantc | yes but you have no control over what data is in each locations where as tp gives you that control | 13:41 |
| troal01 | Okay I don't care so much about where it is as to how much fits into my table :) | 13:43 |
| grantc | then bog standard loc and extending the table to use those new locations should be good enough | 13:44 |
| troal01 | Thanks grantc | 13:47 |
| *** rossand has joined #ingres | 13:53 | |
| *** ChanServ sets mode: +o rossand | 13:53 | |
| troal01 | What's the max value of tid again? | 15:31 |
| grantc | google is your friend :) | 15:32 |
| DarylM | Haven't seen the latest news about Google installing hidden startup software yet, eh grantc? ;) | 15:34 |
| grantc | don't i fecking know it | 15:35 |
| grantc | if picasa was not so useful.... | 15:35 |
| troal01 | Thanks grantc... I always assume google doesn't know anything about Ingres :P | 15:36 |
| DarylM | http://blog.wired.com/business/2009/02/why-googles-sof.html | 15:36 |
| grantc | google helps me out quite a bit with respect to Ingres | 15:38 |
| grantc | DarylM, that program got installed with the Picasa Mac beta, i would not mind so much if it actually worked | 15:40 |
| DarylM | Yup, it gets installed with everything Google now on Macs. Sigh. Which reminds me; we need a system boot startup package and an preference panel for Ingres on Macs | 15:56 |
| grantc | like the MySQL panel which is a start/stop button :) | 15:58 |
| DarylM | I started making one using MySQL as a basis (using Xcode) but the MySQL stuff is a bit of a hack | 15:58 |
| DarylM | Plus, I think we would want support for multiple II_SYSTEM installations | 15:59 |
| * grantc thinks DarylM is in for a world of pain | 15:59 | |
| * DarylM thinks that would be no change from normal | 16:00 | |
| grantc | managing a single installation/instance (or whatever it's called now) would/should be a no brainer | 16:00 |
| grantc | something like porting the linux init.d script to OSX | 16:01 |
| DarylM | Startup is easy. Preference GUI panels are not | 16:02 |
| grantc | what about checking the status? | 16:03 |
| DarylM | (or at least not easy for a n00b) | 16:03 |
| grantc | preference pain^H^Hne does a call to the startup script with a param of status | 16:03 |
| DarylM | Status is also an interesting problem. What constitutes "up"? (In general, that is not a Mac specific question) | 16:04 |
| grantc | i would argue that if the number of servers/processes running matched the startup count then you are good to go :) | 16:05 |
| grantc | or you could have a green light for each item in config.dat that has a startup entry... | 16:06 |
| grantc | but that gets a bit complicated | 16:06 |
| grantc | http://ingres.pastebin.com/d65dfd5c2 - is what there is on linux | 16:07 |
| DarylM | The thing I like about the MySql panel is its simplicity. ON or OFF. :-) | 16:09 |
| * DarylM attention will be directed at a client problem for a bit.... | 16:10 | |
| grantc | hmm - perhaps | 16:10 |
| *** perftuning has joined #ingres | 16:30 | |
| *** Alex|off is now known as Alex| | 17:16 | |
| troal01 | Why would I get this error message: E_US1206 The specified location name is invalid. when doing a modify to reorganize? | 17:35 |
| troal01 | I can do createdb in those locations so I know they exist | 17:35 |
| troal01 | Ahh I have to use extenddb? | 17:37 |
| grantc | yup | 17:38 |
| grantc | you need to extend the db in to that location before you can use it | 17:38 |
| troal01 | Yep now it work | 17:39 |
| troal01 | s | 17:39 |
| troal01 | Thanks.. | 17:39 |
| *** Alex| is now known as Alex|off | 18:56 | |
| *** DarylM has quit IRC | 20:21 | |
| troal01 | Hmm my copy statement got aborted because it tried to grow beyond the max tid | 20:47 |
| troal01 | But I did a modify table to reorganize with location =(loc1,loc2,loc3,loc4) before | 20:48 |
| *** grantc is now known as grantc_offline | 21:54 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!