Re: Double prepare

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Igor Korot <ikorot01(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Double prepare
Date: 2026-05-16 13:46:27
Message-ID: 1495292.1778939187@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Igor Korot <ikorot01(at)gmail(dot)com> writes:
> Is there a way to see if the query has been prepared already (in libpq)?

Use the pg_prepared_statements view. I don't think libpq keeps any
client-side state about this.

> Or is it better to run PQprepare for all known parameterized queries
> in the very beginning of the program and just execute them when needed?

Very probably. Querying pg_prepared_statements every time would be
expensive.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2026-05-16 14:07:01 Re: Double prepare
Previous Message Igor Korot 2026-05-16 06:40:32 Double prepare