On 2/21/23 17:18, Cathy Xie wrote:
On Wed, Feb 22, 2023 at 6:54 AM Adrian Klaver
Hi Adrian,
Thanks for your email!
1) How did you build it?
I installed ActivateState Perl, Bison, and Flex. Then I ran the command
```build Debug``` under directory postgres/src/tools/msvc
2) Ope
On Wed, Feb 22, 2023 at 8:35 AM Michael Arnold wrote:
>
> Am looking for guidance on how to fix a memory leak when using libpq
> PQExecParams(). Memory leaks through CRYPTO_zalloc() and arises when using
> json_agg(). None-JSON based PQExecParams() calls are not leaking.
>
> Using Postgresql 1
Hi,
Am looking for guidance on how to fix a memory leak when using libpq
PQExecParams(). Memory leaks through CRYPTO_zalloc() and arises when using
json_agg(). None-JSON based PQExecParams() calls are not leaking.
Using Postgresql 13.6 (Ubuntu 13.6-0ubuntu0.21.10.1) on
x86_64-pc-linux-gnu, comp
>>-Исходное сообщение-
>>От: Laurenz Albe
>>Отправлено: 22 февраля 2023 г. 12:52
>>Кому: Neethu P ; pgsql-general
>>
>>Тема: Re: Event Triggers unable to capture the DDL script executed
>>On Wed, 2023-02-22 at 07:57 +, Neethu P wrote:
>>> We are using event triggers to capture the
On Wed, 2023-02-22 at 07:57 +, Neethu P wrote:
> We are using event triggers to capture the DDL changes in a postgres database.
> However, we are unable to get the column information & the actual DDL script
> executed, while a table is altered.
> Also, in the postgres documentation for pg_even
Let’s say we have to run a PostgreSQL instance on top of a copy on write
filesystem like ZFS or BTRFS. In adittion to set full_page_writes = off, what
other optimizations can be done on the PostgreSQL side?
Regards,
Héctor
Hi team,
We are using event triggers to capture the DDL changes in a postgres database.
However, we are unable to get the column information & the actual DDL script
executed, while a table is altered.
Also, in the postgres documentation for pg_event_trigger_ddl_commands ()- it is
mentioned as b