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?
Auf dieser Seite können Sie das Online-Video PostgreSQL 101 Webinar Comparing SQL Server and PostgreSQL - Q&A Session | Redgate mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Redgate Software 19 Juni 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 912 Mal angesehen und es wurde von 17 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!