PostgreSQL 101 Webinar Comparing SQL Server and PostgreSQL - Q&A Session | Redgate

preview_player
Показать описание
For those of you who joined our 'PostgreSQL 101: Comparing SQL Server and PostgreSQL - 10 key differences' webinar, this is a follow up video with the questions we received during our live Q&A session.

Subscribe to our YouTube channel for the latest updates: @redgate

For more updates follow us on:

0:39 How much memory does each connection take in PostgreSQL?
2:53 What is the difference between VACUUM and ANALYZE?
6:11 If every UPDATE creates a new row, does that hold true when an update doesn't change the data?
8:11 Is there something similar to a CTE in PostgreSQL?
10:10 Does PostgreSQL have a built -in full text search?
12:49 Which version of SQL Monitor supports PostgreSQL?
14:10 Can PostgreSQL backups be encrypted?
16:02 How are security patches handled as part of the release cycle?
18:09 Are there in-memory OLAP and Columnstore-like indexes?
20:28 Is there something similar to DMVs to help analyze memory performance?
22:38 What is the first problem to solve when moving from SQL Server to PostgreSQL?
25:20 What is the equivalent of a Linked Server in PostgreSQL?
27:49 Any suggestions for migrating from SQL Server to PostgreSQL?
Рекомендации по теме
Комментарии
Автор

watched first two

both statement about SQL Server are not technically accurate

#1 SQL Server can grant up to 1/4 of available buffer pool to a single query
#2 tempdb is used for version store by default. SQL Server 2022 can store in a database instead of tempdb
#3 When you do triggers, SQL Server has inserted and deleted table. There is no updated table. The same as in PostgreSQL

MichaelKarpenko