Re: An self-contained example "expanded" C data type

Hi pá 5. 11. 2021 v 4:47 odesílatel Michel Pelletier < pelletier.mic...@gmail.com> napsal: > The docs for expanded data types are good, but for a working example you > have to go trolling through the array data type source code, which is > enlightening but a pretty heavy lift for me especially if

An self-contained example "expanded" C data type

The docs for expanded data types are good, but for a working example you have to go trolling through the array data type source code, which is enlightening but a pretty heavy lift for me especially if I have to come back to it after some time. So I decided to distill what I could glean from the so

Re: to_date() and to_timestamp() with negative years

On 11/4/21 10:29 AM, Bryn Llewellyn wrote: /adrian.kla...@aklaver.com wrote:/ Not sure how this can be handled in a totally predictable way given the unpredictable ways in which datetime strings are formatted? The only thing I can say it is it points out tha

Re: Streaming replication versus Logical replication

> On Nov 4, 2021, at 12:16, Alanoly Andrews wrote: > > Thanks, Ninad, for the response. > So, am I to understand that when there is a long-running query on the > subscriber, the vacuumed data updates from the publisher are held over on the > subscriber until the query completes? If so, where

RE: Streaming replication versus Logical replication

Thanks, Ninad, for the response. So, am I to understand that when there is a long-running query on the subscriber, the vacuumed data updates from the publisher are held over on the subscriber until the query completes? If so, where and how are they held over, and what does it mean in terms of di

Re: ZFS filesystem - supported ?

Right... which is why you do pg_basebackup infrequently. It also captures WALs when conducting the backup. The tradeoff is that if you have a huge amount of WAL files then running a restore can be quite time-consuming. There isn't really a clear win here though. You trade off a long time backup tha

Re: Streaming replication versus Logical replication

Yes, it is going to resolve the issue because streaming is completely a slave(with few exceptions). Even the VACUUM operation gets replicated through the master, which is not a case with logical replication. In logical replication, only data from a few tables gets replicated. In terms of database a

Re: to_date() and to_timestamp() with negative years

> adrian.kla...@aklaver.com wrote: > > Not sure how this can be handled in a totally predictable way given the > unpredictable ways in which datetime strings are formatted? > > The only thing I can say it is it points out that when working with datetimes > settling on a standard format is your

Streaming replication versus Logical replication

We are currently running some long-running SELECT queries on the replication database in a streaming replication pair. Some of these queries can run for 1 hour or more. To avoid errors related to "data no more being available" on the replication due to vacuuming of old data on the primary databa

Re: Error with Insert from View with ON Conflict

Steve, Peter, thanks . Below query works. the view is used to generate the stats and not using the table http_ping_uptime_stats . So my interpretation was that I need to alias the view for the UPDATE to know where the value is coming from as both have the same name. That obviously did not work. I