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?
On this page of the site you can watch the video online PostgreSQL 101 Webinar Comparing SQL Server and PostgreSQL - Q&A Session | Redgate with a duration of hours minute second in good quality, which was uploaded by the user Redgate Software 19 June 2023, share the link with friends and acquaintances, this video has already been watched 912 times on youtube and it was liked by 17 viewers. Enjoy your viewing!
