veyepar: PostgreSQL Indexing : How, why, and when.

Author(s):	Curtis Maloney
Location	C3.3
Date	aug Fri 24	Days Raw Files
Start	14:50	First Raw Start	14:24
Duration	0:30:0	Offset	0:25:16
End	15:20	Last Raw End	15:24
Chapters	00:00 0:05:08
Total cuts_time	31 min.

https://2018.pycon-au.org/talks/42913-postgresql-indexing-how-why-and-when/
raw-playlist raw-mp4-playlist encoded-files-playlist host tweet mp4 svg png

assets release.pdf PostgreSQL_Indexing_How_why_and_when.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:

markdown

Comment:

production notes

2018-08-24/14_24_44.ts Apply: 14:24:44 - 14:39:35 ( 00:14:51 ) S: 14:24:44 - E: 14:54:43 D: 00:29:59 (End: 891.0) show more...

vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c33/2018-08-24/14_24_44.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:24:44		seconds: 0.0 Wall: 14:24:44
Duration	00:29:59
	14:54:43		seconds: 891.0 Wall: 14:39:35
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-08-24/14_24_44.ts Apply: 14:39:35 - 14:49:35 ( 00:10:00 ) S: 14:24:44 - E: 14:54:43 D: 00:29:59 (Start: 891.0) (End: 1491.0) show more...

vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c33/2018-08-24/14_24_44.ts :start-time=0891.0 --audio-desync=0

	Raw File	Cut List
	14:24:44		seconds: 891.0 Wall: 14:39:35
Duration	00:29:59
	14:54:43		seconds: 1491.0 Wall: 14:49:35
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-08-24/14_24_44.ts Apply: 14:49:35 - 14:54:43 ( 00:05:08 ) S: 14:24:44 - E: 14:54:43 D: 00:29:59 (Start: 1491.0) show more...

vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c33/2018-08-24/14_24_44.ts :start-time=01491.0 --audio-desync=0

	Raw File	Cut List
	14:24:44		seconds: 1491.0 Wall: 14:49:35
Duration	00:29:59
	14:54:43		seconds: 0.0 Wall: 14:24:44
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-08-24/14_54_44.ts Apply: 14:54:44 - 15:20:53 ( 00:26:09 ) S: 14:54:44 - E: 15:24:44 D: 00:30:00 (End: 1569.0) show more...

vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c33/2018-08-24/14_54_44.ts :start-time=00.0 --audio-desync=0

	Raw File	Cut List
	14:54:44		seconds: 0.0 Wall: 14:54:44
Duration	00:30:00
	15:24:44		seconds: 1569.0 Wall: 15:20:53
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete

2018-08-24/14_54_44.ts Apply: 15:20:53 - 15:24:44 ( 00:03:51 ) S: 14:54:44 - E: 15:24:44 D: 00:30:00 (Start: 1569.0) show more...

vlc ~/Videos/veyepar/pyconau/pyconau_2018/dv/c33/2018-08-24/14_54_44.ts :start-time=01569.0 --audio-desync=0

	Raw File	Cut List
	14:54:44		seconds: 1569.0 Wall: 15:20:53
Duration	00:30:00
	15:24:44		seconds: 0.0 Wall: 14:54:44
Comments:
mp4 mp4.m3u	dv.m3u	Split: Sequence:: delete