2008-02-20T00:29:48 *** greg-g has quit IRC 2008-02-20T07:33:16 http://dojocampus.org/ 2008-02-20T07:36:42 *** stompro has joined #openils-evergreen 2008-02-20T08:16:40 *** greg-g has joined #openils-evergreen 2008-02-20T08:19:17 *** edc_detached is now known as ecorrado 2008-02-20T08:43:47 *** stompro has quit IRC 2008-02-20T09:22:16 *** djfiander has joined #OpenILS-Evergreen 2008-02-20T09:22:24 test 2008-02-20T09:22:27 bah 2008-02-20T09:22:32 *** djfiander has left #OpenILS-Evergreen 2008-02-20T09:22:44 *** djfiander has joined #OpenILS-Evergreen 2008-02-20T09:22:45 test 2008-02-20T09:22:46 there 2008-02-20T09:24:11 *** dbs has joined #OpenILS-Evergreen 2008-02-20T09:24:59 omg yo what's with all these clones from adsl-217-104-225.asm.bellsouth.net??? ;_ 2008-02-20T09:25:01 ;) 2008-02-20T09:25:13 I AM NOT A CLONE! 2008-02-20T09:25:16 I don't wear glasses 2008-02-20T09:25:28 thank god... if there were 2 dan's... 2008-02-20T09:25:33 I'd be out of work, for one thing... 2008-02-20T09:26:56 *** pmurray_away is now known as pmurray 2008-02-20T09:31:41 dbs: you will soo enough 2008-02-20T09:54:05 djfiander: {"order_by":"create_time, edit_time DESC", "limit":10, "offset":0} 2008-02-20T09:54:14 djfiander: order_by's can be simple as well.. {"order_by":"create_time"} 2008-02-20T09:54:28 cool 2008-02-20T10:09:55 *** ibbo has joined #OpenILS-Evergreen 2008-02-20T10:38:14 berick: that won't work with trunk/acq cstore, I think 2008-02-20T10:39:23 let me get the syntax... 2008-02-20T10:49:28 eeevil: seems to be working 2008-02-20T10:49:29 *** pmurray is now known as pmurray_away 2008-02-20T10:50:09 hrm... it shouldn't work in trunk.... 2008-02-20T10:50:11 well 2008-02-20T10:50:17 maybe that's just in json_query 2008-02-20T11:08:00 ecorrado: I'll be packaging up 1.2.1.4 today with a fix to unbreak the "fix" for the libxslt versioning issue that you(?) discovered about 3 weeks ago. after I do that, do you think you could try it on your box? 2008-02-20T11:15:18 *** Karen_ has joined #OpenILS-Evergreen 2008-02-20T11:15:30 djfiander: open-ils.acq.provider.org.retrieve 2008-02-20T11:16:20 limit_perm 2008-02-20T11:20:50 eeevil: i probably could give it atry depending on how long it will take me to try it. I am swampped the next few days before code4lib 2008-02-20T11:23:29 ecorrado: k ... no biggie right now 2008-02-20T11:29:35 djfiander: request open-ils.acq open-ils.acq.po_lineitem.retrieve "a4346fd11dda0fb301b24177688455e8", 19, {"flesh_li_details":1,"clear_marc":1, "flesh_li_attrs":1} 2008-02-20T11:32:00 gar... anybody for pizzahut? 2008-02-20T11:32:16 sure. ecorrado can make the run 2008-02-20T11:33:07 it's not digiorno, it's delivery 2008-02-20T11:34:11 pizza hut? only if we get the craziest stuffed-crust blot-the-grease-off-the-top-with-napkins turn-your-stomach variation possible 2008-02-20T11:34:28 sounds like a meat lovers with extra cheese? 2008-02-20T11:34:45 i'll have thin crust veggie pls :) 2008-02-20T11:35:31 djfiander: I'm from New Jersey.... we eat real pizza here, not mass-produced chain stuff 2008-02-20T11:35:55 ecorrado: sounds like even a better plan that pizzahut. start moving 2008-02-20T11:36:13 garg... 2008-02-20T11:36:29 * ecorrado needs to sell his house so he can move 2008-02-20T11:36:40 .me not sure if Binghamton NY has real pizza 2008-02-20T11:37:31 * ecorrado goes to see if stupid Ariel machine is still working 2008-02-20T11:37:36 it's big enough... somebody should know how to make some 2008-02-20T11:37:41 ecorrado: did you see the update for the import stuff on the wiki? 2008-02-20T11:37:59 dbs: I saw the paste in the scrollback 2008-02-20T11:38:12 http://open-ils.org/dokuwiki/doku.php?id=importing:holdings:import_via_staging_table is a little more refined 2008-02-20T11:38:28 I'll look for it on the wiki when I get a chance to work with evergreen again (which might not be until tommorow) 2008-02-20T11:38:34 dbs: thanks 2008-02-20T11:39:32 * ecorrado also has to contact people who offered some other options via e-mail soon 2008-02-20T11:39:43 * ecorrado really goes to check on Ariel machine now 2008-02-20T11:40:58 garg... http://www.johnnyspizza.com/menus/114.pdf? 2008-02-20T12:03:47 * dmcmorris_esi likes this: http://www.linux-ha.org/BadThingsWillHappen 2008-02-20T12:53:34 *** EGUEST789 has joined #openils-evergreen 2008-02-20T12:54:38 *** EGUEST789 has quit IRC 2008-02-20T12:59:10 *** ecorrado is now known as edc_mtg 2008-02-20T13:05:25 *** ibbo has quit IRC 2008-02-20T13:46:30 *** phase_bb has quit IRC 2008-02-20T14:03:20 *** pmurray_away is now known as pmurray 2008-02-20T15:23:30 *** edc_mtg is now known as ecorrado 2008-02-20T15:48:15 *** sarabee has quit IRC 2008-02-20T15:50:55 *** sarabee has joined #openils-evergreen 2008-02-20T15:59:14 *** sarabee has quit IRC 2008-02-20T16:02:02 *** sarabee has joined #openils-evergreen 2008-02-20T16:06:11 we got us a special visitor 2008-02-20T16:09:18 *** Karen_ has left #OpenILS-Evergreen 2008-02-20T16:15:50 *** sarabee has quit IRC 2008-02-20T16:18:31 *** sarabee has joined #openils-evergreen 2008-02-20T16:46:55 1/2 done ;) 2008-02-20T16:51:02 *** pmurray is now known as pmurray_away 2008-02-20T17:02:25 *** phase_bb has joined #openils-evergreen 2008-02-20T17:10:13 http://science.nasa.gov/headlines/y2008/13feb_lunareclipse.htm 2008-02-20T17:10:23 some of ya might be interested, I figured 2008-02-20T17:10:34 holy cow, that's tonight 2008-02-20T17:23:17 Anyone there who can advise me on how I might improve performance on a particular box--the searches do return results, but it's literally 10 minutes or more. I don't want to VACCUUM ANALYZE the whole DB if I don't have to (it takes a couple of hours). Is there any way to see query plan info so I can see if one table's indexes need to be ANALYZEd or reindexed? It may be that this test box... 2008-02-20T17:23:19 ...just isn't up to the size of DB (2.7 M bibs), but advice on how to tune would be most appreciated. 2008-02-20T17:25:55 query plan info comes from EXPLAIN 2008-02-20T17:26:06 eeevil just left the building, unfortunately 2008-02-20T17:27:48 Thanks dbs. 2008-02-20T17:27:50 Is gggood still there? 2008-02-20T17:27:51 (sorry) 2008-02-20T17:28:30 dmcmorris_esi: So are you folks going to have clear enough skies to enjoy the eclipse? It's like to be snowing lightly here.... 2008-02-20T17:30:29 I take it back. The SC doesn't show results.... It returns results when I run the query that the SC generates.... So far no joy on the SC (although Postgres says the query has finished--[expletive deleted]!). 2008-02-20T17:36:27 *** bruwal has joined #OpenILS-Evergreen 2008-02-20T17:49:40 time for din-dins 2008-02-20T17:51:12 *** djfiander has left #OpenILS-Evergreen 2008-02-20T17:52:41 Hmmm. Looks like it just wasn't dealing well with a search that returned thousands of rows.... If I add more keywords, it does work. (That is a major relief!) 2008-02-20T17:52:57 Now we gotta figure out how to get some more RAM available in this box.... 2008-02-20T18:00:39 dbs: So, are you in Atlanta? 2008-02-20T18:04:33 agJohn: yes I am - but heading out to dinner (sorry, was heads down finding a spot to sleep tonight) 2008-02-20T18:05:52 Not a problem. Eat some dinner for me and have a good week! 2008-02-20T18:09:15 *** ecorrado is now known as edc_detached 2008-02-20T18:22:44 *** dbs has quit IRC 2008-02-20T19:13:29 *** sarabee has quit IRC 2008-02-20T19:16:35 *** sarabee has joined #openils-evergreen 2008-02-20T19:35:33 *** sarabee has quit IRC 2008-02-20T19:38:10 *** sarabee has joined #openils-evergreen 2008-02-20T20:35:58 *** dbs has joined #OpenILS-Evergreen 2008-02-20T21:57:32 *** dbs has quit IRC 2008-02-20T21:57:42 *** dbs has joined #OpenILS-Evergreen 2008-02-20T22:59:46 *** dbs has quit IRC