On Sat, 22 Apr 2023, Tom Lane wrote:
>Wen Yi writes:
>> [ use calloc to replace zeroing fields individually ]
[…]
>People have complained about this practice off-and-on, but no one has
>provided any evidence that there's a significant performance cost.
>The maintenance benefits are real though.
Thorsten Glaser writes:
> On Sat, 22 Apr 2023, Tom Lane wrote:
>> The maintenance benefits are real though.
> Oh, interesting ;-) Thanks for this explanation.
> Another data point is: calloc is not correct for pointer fields,
> you have to manually assign NULL to them afterwards still, because
>
Hi,
I have large centralized master database for which I created a few
materialized views exclusively used by Web sites running in different
regions on their own servers.
To avoid having to connect to and pull data from across the globe I am
thinking about running small postgres instances in each
hi.
alter table t1 rename col1 to id.
Is it possible to use an event trigger to capture the new column name "id"?
On Mon, Apr 24, 2023 at 10:46 AM jian he
wrote:
>
> hi.
> alter table t1 rename col1 to id.
>
> Is it possible to use an event trigger to capture the new column name
> "id"?
>
>
>
sorry for the noise.
I figured it out.
substring(_object_identity FROM (LENGTH(_object_identity) + 2 -
STRPOS(REVERSE
