Tags
Language
Tags
April 2024
Su Mo Tu We Th Fr Sa
31 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 1 2 3 4

A Tour of PostgreSQL By Rob Sullivan [repost]

Posted By: ParRus
A Tour of PostgreSQL By Rob Sullivan [repost]

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

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
Screenshots

A Tour of PostgreSQL By Rob Sullivan [repost]

A Tour of PostgreSQL By Rob Sullivan [repost]

A Tour of PostgreSQL By Rob Sullivan [repost]

Exclusive eLearning Videos ParRus-blogadd to bookmarks

A Tour of PostgreSQL By Rob Sullivan [repost]