posgresql (2) 썸네일형 리스트형 [Theorem] Differences between conn.commit and conn.autocommit In PostgreSQL, all user activity occurs in a transaction. If autocommit mode is enabled, each SQL statement forms a single transcation on its on. In this case, no rollback is possible. Source from : https://stackoverflow.com/questions/51880309/what-does-autocommit-mean-in-postgresql-and-psycopg2 https://stackoverflow.com/questions/57761557/is-there-any-reason-not-to-use-autocommit https://stacko.. [psycopg2] More efficient Index Scan 1. Bitmap Index/Heap Scan Index Scan has the advantage of showing much faster efficiency that Seq Scan. In SQL, there are cases where a WHERE cluase uses a compound conditional statement rather than a single conditional statement. At this time, if one column is designated as INDEX and the other column is not designated as INDEX, it can be seen that the nested structure of Bitmap Index Scan and B.. 이전 1 다음