PostgreSQL 101 Webinar Comparing SQL Server and PostgreSQL - Q&A Session | Redgate
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.
If you missed the full webinar, catch-up on demand here: https://rd.gt/43yUWqc
Subscribe to our YouTube channel for the latest updates: @redgate
For more updates follow us on:
LinkedIn: / red-. .
Twitter: / redgate
Website: https://www.red-gate.com
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?