Implicit query plan caching within a connection

Поиск
Список
Период
Сортировка
От Xikui Wang
Тема Implicit query plan caching within a connection
Дата
Msg-id CAN-bgPqznO45pHHcvnOQG0YQAN6ksjTEv1Q4s_mBWg02u4gTxg@mail.gmail.com
обсуждение исходный текст
Список psycopg
Hi Devs,

I'm working on a performance test using Psycopg2 + Postgres. My workload is to do a spatial join to use one data point joining two reference tables by repeatedly issuing a query string with different coordinates. The average query execution time that I got is 0.5 ms, which is surprisingly fast. I started a pgsql terminal and analyzed the same query multiple times. The overall execution time is around 1.5ms with ~1ms in planning and 0.5ms in execution. That makes me is that because psycopg2 implicitly cached the plan. Is there any implicit optimization there? Thanks in advance!

Best,
Xikui

В списке psycopg по дате отправления:

Предыдущее
От: Daniele Varrazzo
Дата:
Сообщение: Psycopg 2.8 beta 1 released
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: Psycopg 2.8 beta 2 released