veyepar: Postgres Performance for Humans

Author(s):	Craig Kerstiens
Location	Suzanne Scharer
Date	jul Sat 29	Days Raw Files
Start	16:00	First Raw Start	14:28
Duration	00:50:00	Offset	1:31:33
End	16:50	Last Raw End	15:55
Chapters	00:00 0:28:07
Total cuts_time	41 min.

http://pyohio.org/schedule/presentation/260/
raw-playlist raw-mp4-playlist encoded-files-playlist host archive mp4 svg png

assets release.pdf Postgres_Performance_for_Humans_2.json
logs
Admin: episode episode list cut list raw files day marks day marks day image_files

State:
Locked:	clear this to unlock
Locked by:	user/process that locked.
Start:	initially scheduled time from master, adjusted to match reality
Duration:	length in hh:mm:ss
Name:	Video Title (shows in video search results)
Emails:	email(s) of the presenter(s)
Released:	has someone authorised pubication
Normalise:
Channelcopy:	m=mono, 01=copy left to right, 10=right to left, 00=ignore.
Thumbnail:	filename.png
Description:	To many developers the database is a black box. You expect to be able to put data into your database, have it to stay there, and get it out when you query it... hopefully in a performant manner. We'll go from basics to the more advanced of what you need to know to keep things running smoothly. markdown
Comment:	production notes

2017-07-29/14_28_27.ts Apply: 14:28:27 - 14:41:49 ( 00:13:22 ) S: 14:28:27 - E: 14:58:27 D: 00:30:00 (End: 802.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/suzanne_scharer/2017-07-29/14_28_27.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:28:27		seconds: 0.0 Wall: 14:28:27
Duration	00:30:00
	14:58:27		seconds: 802.0 Wall: 14:41:49
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_28_27.ts Apply: 14:41:49 - 14:50:46 ( 00:08:57 ) S: 14:28:27 - E: 14:58:27 D: 00:30:00 (Start: 802.0) (End: 1339.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/suzanne_scharer/2017-07-29/14_28_27.ts :start-time=0802.0 --audio-desync=0

	Raw File	Cut List
	14:28:27		seconds: 802.0 Wall: 14:41:49
Duration	00:30:00
	14:58:27		seconds: 1339.0 Wall: 14:50:46
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_28_27.ts Apply: 14:50:46 - 14:58:27 ( 00:07:41 ) S: 14:28:27 - E: 14:58:27 D: 00:30:00 (Start: 1339.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/suzanne_scharer/2017-07-29/14_28_27.ts :start-time=01339.0 --audio-desync=0

	Raw File	Cut List
	14:28:27		seconds: 1339.0 Wall: 14:50:46
Duration	00:30:00
	14:58:27		seconds: 0.0 Wall: 14:28:27
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_58_27.ts Apply: 14:58:27 - 15:00:19 ( 00:01:52 ) S: 14:58:27 - E: 15:28:26 D: 00:29:59 (End: 112.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/suzanne_scharer/2017-07-29/14_58_27.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:58:27		seconds: 0.0 Wall: 14:58:27
Duration	00:29:59
	15:28:26		seconds: 112.0 Wall: 15:00:19
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/14_58_27.ts Apply: 15:00:19 - 15:28:26 ( 00:28:07 ) S: 14:58:27 - E: 15:28:26 D: 00:29:59 (Start: 112.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/suzanne_scharer/2017-07-29/14_58_27.ts :start-time=0112.0 --audio-desync=0

	Raw File	Cut List
	14:58:27		seconds: 112.0 Wall: 15:00:19
Duration	00:29:59
	15:28:26		seconds: 0.0 Wall: 14:58:27
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/15_28_27.ts Apply: 15:28:27 - 15:41:35 ( 00:13:08 ) S: 15:28:27 - E: 15:55:52 D: 00:27:25 (End: 788.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/suzanne_scharer/2017-07-29/15_28_27.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	15:28:27		seconds: 0.0 Wall: 15:28:27
Duration	00:27:25
	15:55:52		seconds: 788.0 Wall: 15:41:35
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2017-07-29/15_28_27.ts Apply: 15:41:35 - 15:55:52 ( 00:14:17 ) S: 15:28:27 - E: 15:55:52 D: 00:27:25 (Start: 788.0) show more...

vlc ~/Videos/veyepar/pyohio/pyohio_2017/dv/suzanne_scharer/2017-07-29/15_28_27.ts :start-time=0788.0 --audio-desync=0

	Raw File	Cut List
	15:28:27		seconds: 788.0 Wall: 15:41:35
Duration	00:27:25
	15:55:52		seconds: 0.0 Wall: 15:28:27
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

Rf filename:	root is .../show/dv/location/, example: 2013-03-13/13:13:30.dv
Sequence:
get this:	check and save to add this