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:	So many of the things we build depend on a DBMS to keep our data safe, and retrieve it quickly. We know indexes can make that faster, but... how do they work? When should you use them? What should I index? 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

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