*** Mud is now known as Guest35178 | 00:00 | |
*** dyki has joined #ingres | 00:42 | |
*** dyki has quit IRC | 00:49 | |
*** PaulM05 has joined #ingres | 00:59 | |
*** cthibert has joined #ingres | 03:34 | |
*** gerhard has joined #ingres | 04:20 | |
*** atrofast has joined #ingres | 04:40 | |
gerhard | Hi all | 04:41 |
---|---|---|
PaulM05 | hi | 04:41 |
*** gerhard has quit IRC | 04:49 | |
*** PaulM05 is now known as PaulM_lunch | 04:50 | |
*** zxiiro has quit IRC | 05:06 | |
*** PaulM_lunch is now known as PaulM05 | 05:39 | |
*** zxiiro has joined #ingres | 05:52 | |
*** ChanServ sets mode: +v zxiiro | 05:52 | |
*** rossand has joined #ingres | 06:12 | |
*** ChanServ sets mode: +o rossand | 06:12 | |
*** cthibert has quit IRC | 06:14 | |
*** Alex| has quit IRC | 06:19 | |
*** cthibert has joined #ingres | 06:24 | |
*** DarylM has joined #ingres | 07:16 | |
*** mull has joined #ingres | 07:17 | |
*** ccsidiot has joined #ingres | 07:31 | |
*** dyki has joined #ingres | 07:54 | |
*** dyki has quit IRC | 08:32 | |
atrofast | Has anyone run the test suite on main lately? Mine froze on be/blob06.sep | 08:43 |
PaulM05 | that's a known problem | 08:44 |
PaulM05 | the fix was *just* submitted (about 2mins ago!) | 08:44 |
PaulM05 | are you working from SVN? | 08:44 |
atrofast | Yeah | 08:44 |
atrofast | Thanks PaulM05, I'll eagerly await the fix to arrive in SVN :) | 08:45 |
PaulM05 | look for change Change 501737/bug 122655 | 08:45 |
PaulM05 | np - I hit myself this morning | 08:45 |
*** Guest35178 is now known as Mud | 08:55 | |
atrofast | Yeah it's in SVN PaulM05, thanks a bunch | 08:58 |
*** atrofast has quit IRC | 09:18 | |
*** hanje04 has joined #ingres | 09:24 | |
*** atrofast has joined #ingres | 09:27 | |
*** ccsidiot has quit IRC | 10:09 | |
*** PaulM05 has quit IRC | 10:35 | |
*** ccsidiot has joined #ingres | 11:00 | |
*** monda07 has joined #ingres | 11:28 | |
*** Alex| has joined #ingres | 11:40 | |
*** ChanServ sets mode: +o Alex| | 11:40 | |
*** DarylM has quit IRC | 11:46 | |
*** monda07 is now known as DarylM | 11:46 | |
cthibert | Hello. Can anyone provide some advice on 2 million record tables? I've such a table and it runs into system lock shortages when trying to read it. I've tried upping the lock values with CBF and now the error seems to be around virtual memory. However, before I just keep increasing numbers, is there anyone else that has done tuning for 2million record tables? | 12:23 |
pboro | is readlock=nolock a viable solution? | 12:29 |
cthibert | Hmm, would be good for what I'm doing now. May be as long term, would have to look into how this will be used in the future. Thanks pboro. | 12:38 |
pboro | big pages and page level locking would be my best bet after readlock=nolock | 12:42 |
pboro | and checking that queries don't unnecessarily do full scans... I hope 10.0 with its support for MVCC helps with these :) | 12:43 |
cthibert | Yeah, unfortunately this is a full scan. Map generation for geo. It needs to get all the points of interest to put them on the map. At this point it's exhausting the 'virtual address space of the process' when 'expanding the virtual size of server.' It's an O/S error it appears. Hmm, looks like I may have to tell the O/S to let this happen, or mess around with the application side to control the queries bett | 12:54 |
hanje04 | cthibert: you may not have a choice. Max user space memory on x86 Linux is 3Gb, are you anywhere near that? | 13:14 |
cthibert | Hmm, probably. Top showed mem usage over 50% on a 4gb system. Not quite there, but also, not even close to the total record count when I get there. | 13:15 |
cthibert | Time to dig into the application side. Thanks for the help all. | 13:16 |
*** cthibert has left #ingres | 13:28 | |
*** Mud has quit IRC | 13:33 | |
*** Alex| has quit IRC | 13:39 | |
*** zxiiro has quit IRC | 14:01 | |
*** ccsidiot has left #ingres | 14:05 | |
*** mull has quit IRC | 16:00 | |
*** rossand has quit IRC | 16:34 | |
*** zxiiro has joined #ingres | 17:44 | |
*** ChanServ sets mode: +v zxiiro | 17:44 | |
*** mull has joined #ingres | 18:52 | |
*** cytrinox_ has joined #ingres | 19:25 | |
*** cytrinox has quit IRC | 19:37 | |
*** cytrinox_ is now known as cytrinox | 19:37 | |
*** hanje04 has quit IRC | 22:01 | |
*** Alex| has joined #ingres | 22:39 | |
*** ChanServ sets mode: +o Alex| | 22:39 | |
*** gerhard has joined #ingres | 22:49 | |
gerhard | Morning all | 22:52 |
*** sbishop411_ has joined #ingres | 22:54 | |
*** Alex| has quit IRC | 23:07 | |
*** sbishop411 has quit IRC | 23:12 | |
*** Alex| has joined #ingres | 23:26 | |
*** ChanServ sets mode: +o Alex| | 23:26 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!