*** 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!