A Tour of PostgreSQL By Rob Sullivan
WEBRip | English | MP4 | 1024 x 768 | AVC ~506 kbps | 29.970 fps
AAC | 124 Kbps | 44.1 KHz | 2 channels | 2h 14mn | 682.1 MB
Genre: Video Tutorial
WEBRip | English | MP4 | 1024 x 768 | AVC ~506 kbps | 29.970 fps
AAC | 124 Kbps | 44.1 KHz | 2 channels | 2h 14mn | 682.1 MB
Genre: Video Tutorial
In this production, a SQL Server DBA (Rob Sullivan) and a developer (Rob Conery) take a deep dive into PostGreSQL (v9.1). This series was originally about Mono and ASP.NET MVC - but "the Robs" quickly found themselves amazed and surprised by just how capable, intelligent and fast PostGreSQL is. The goal of this production is to introduce people to PostGres who aren't familiar with the system.Content:
Why Should You Care?
The Perils of MySQL
Data Types
Concurrency and the MVCC
Performance Tuning
Querying Text
PSQL
Querying Text
also You can watch my other last: Programming-posts
General
Complete name : 01. Partitioning Part 1.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 66.1 MiB
Duration : 14mn 37s
Overall bit rate mode : Variable
Overall bit rate : 632 Kbps
Encoded date : UTC 2014-01-12 02:07:21
Tagged date : UTC 2014-01-12 02:09:12
Writing application : HandBrake 0.9.8 2012071700
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Baseline@L3.1
Format settings, CABAC : No
Format settings, ReFrames : 2 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 14mn 37s
Bit rate : 506 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate mode : Constant
Frame rate : 29.970 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.021
Stream size : 52.9 MiB (80%)
Writing library : x264 core 120
Encoding settings : cabac=0 / ref=2 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=0 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=0 / weightp=0 / keyint=50 / keyint_min=26 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=3 / qpmax=69 / qpstep=4 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2014-01-12 02:07:21
Tagged date : UTC 2014-01-12 02:09:12
Color range : Limited
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 14mn 37s
Bit rate mode : Variable
Bit rate : 124 Kbps
Maximum bit rate : 148 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 12.9 MiB (20%)
Title : Stereo
Language : English
Encoded date : UTC 2014-01-12 02:07:21
Tagged date : UTC 2014-01-12 02:09:11
Complete name : 01. Partitioning Part 1.mp4
Format : MPEG-4
Format profile : Base Media / Version 2
Codec ID : mp42
File size : 66.1 MiB
Duration : 14mn 37s
Overall bit rate mode : Variable
Overall bit rate : 632 Kbps
Encoded date : UTC 2014-01-12 02:07:21
Tagged date : UTC 2014-01-12 02:09:12
Writing application : HandBrake 0.9.8 2012071700
Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Baseline@L3.1
Format settings, CABAC : No
Format settings, ReFrames : 2 frames
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 14mn 37s
Bit rate : 506 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate mode : Constant
Frame rate : 29.970 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.021
Stream size : 52.9 MiB (80%)
Writing library : x264 core 120
Encoding settings : cabac=0 / ref=2 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=0 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=0 / weightp=0 / keyint=50 / keyint_min=26 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=crf / mbtree=1 / crf=20.0 / qcomp=0.60 / qpmin=3 / qpmax=69 / qpstep=4 / ip_ratio=1.40 / aq=1:1.00
Encoded date : UTC 2014-01-12 02:07:21
Tagged date : UTC 2014-01-12 02:09:12
Color range : Limited
Color primaries : BT.709
Transfer characteristics : BT.709
Matrix coefficients : BT.709
Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 40
Duration : 14mn 37s
Bit rate mode : Variable
Bit rate : 124 Kbps
Maximum bit rate : 148 Kbps
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 KHz
Compression mode : Lossy
Stream size : 12.9 MiB (20%)
Title : Stereo
Language : English
Encoded date : UTC 2014-01-12 02:07:21
Tagged date : UTC 2014-01-12 02:09:11
Screenshots
Exclusive eLearning Videos ParRus-blog ← add to bookmarks