资源描述:
《When PostgreSQL Can_t, You Can Presentation.pdf》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、WhenPostgreSQLCan't,YouCan●KeithFiske●DBA@OmniTIhttp://www.omniti.comkeith@omniti.comhttp://www.keithf4.com@keithf4OmniTI,Inc●Full-stacksupportforhigh-trafficwebsites&applications–Millionsofusers–Terabytesofdata–Gilt,Etsy,Ora.TV,Freelotto●SurgeConference-http://omniti.com/surge
2、–DisasterPorn–AnnuallyinSept●We'rehiring!–http://www.omniti.com/is/hiringPostgreSQLCommunity●OpenSourceRDBMS●BSD-typeLicense●StartedatUCBerkley1986,opensourcedin1996●MailingLists,IRC,Wiki,planet.postgresql.org,Conferences●Third-partypluginsupport–ProceduralLanguages●C,Java,Pyth
3、on,Perl,PHP,RRuby–Extensions(morelater)–BackgroundWorkerPGExtractor●pg_dump/pg_restorelimitations(-t,-n,-P)●Filterbyschema,table,view,function,type,owner●Dumpseachdatabaseobjecttoitsownfile●Alsodumpsequences,triggers,rules,defaultprivileges●Regexmatching●Pythonclass(requirespyt
4、hon3)Extensions●Introducedin9.1●Logicallygroupedsetofdatabaseobjects–CREATEEXTENSIONpg_partman;●Versioned–ALTEREXTENSIONpg_partmanUPDATETO'1.7.0';–Updateandrevertchangespredictably.PGJobmon●PostgreSQLExtension●Autonomousfunctions●Logstepsofrunningfunction●Monitorloggedfunctions
5、toensurecompletion●If/whentheyfail,whereandwhyPGJobmonadd_job('jobname');add_step(job_id,'Whatthisstepwilldo');…dosomestuff...update_step(step_id,'good_status','Whatthisstepdidsuccessfully');add_step(job_id,'Whatthisnextstepwilldo');...dosomestuffinaloop...update_step(step_id,'
6、good_status','updateeveryloopiterationtotrackprogress');add_step(job_id,'Onelaststep');…dojustabitmorestuff...update_step(step_id,'good_status','Jobfinishedok');close_job(job_id);EXCEPTIONWHENOTHERSTHENupdate_step(step_id,'bad_status','Uh..oh...:'
7、
8、coalesce(SQLERRM,'wat'));fail
9、_job(job_id);PGJobmonshow_job('myjobname',[int]);-[RECORD3]-----------------------------job_id
10、10owner
11、keithjob_name
12、PG_JOBMONTESTBADJOBstart_time
13、2012-09-1500:55:44.742176-04end_time
14、2012-09-1500:55:44.851514-04status
15、CRITICAL-[RECORD1]+------------------------------pid
16、5848jo
17、b_id
18、9-[RECORD4]-----------------------------step_id
19、1