On Sat, 2021-10-23 at 11:29 +, Laura Smith wrote:
> Given an upcoming server upgrade, I'm contemplating moving away from XFS to
> ZFS
> (specifically the ZoL flavour via Debian 11).
> BTRFS seems to be falling away (e.g. with Redhat deprecating it etc.), hence
> my preference for ZFS.
>
> Ho
Thanks Tom.
Regards,
Ninad Shah
On Sat, 23 Oct 2021 at 20:12, Tom Lane wrote:
> Ninad Shah writes:
> > Would keepalive setting address and mitigate the issue?
>
> [ shrug... ] Maybe; nobody else has more information about this
> situation than you do. I suggested something to experiment wit
Greetings,
* Mladen Gogala (gogala.mla...@gmail.com) wrote:
> On 10/23/21 23:12, Lucas wrote:
> >This has proven to work very well for me. I had to restore a few backups
> >already and it always worked. The bad part is that I need to stop the
> >database before performing the Snapshot, for data in
On Mon, Oct 25, 2021 at 10:18 AM Laurenz Albe
wrote:
> On Sat, 2021-10-23 at 11:29 +, Laura Smith wrote:
> > Given an upcoming server upgrade, I'm contemplating moving away from XFS
> to ZFS
> > (specifically the ZoL flavour via Debian 11).
> > BTRFS seems to be falling away (e.g. with Redhat
On 10/25/21 13:13, Stephen Frost wrote:
No, it's not- you must also be sure to archive any WAL that's generated
between the pg_start_backup and pg_stop_backup and then to be sure and
add into the snapshot the appropriate signal files or recovery.conf,
depending on PG version, to indicate that y
On 10/25/2021 10:13 AM, Stephen Frost wrote:
Greetings,
* Mladen Gogala (gogala.mla...@gmail.com) wrote:
On 10/23/21 23:12, Lucas wrote:
This has proven to work very well for me. I had to restore a few backups
already and it always worked. The bad part is that I need to stop the
database bef
On 26/10/2021, at 6:13 AM, Stephen Frost wrote:
>
> Greetings,
>
> * Mladen Gogala (gogala.mla...@gmail.com) wrote:
>> On 10/23/21 23:12, Lucas wrote:
>>> This has proven to work very well for me. I had to restore a few backups
>>> already and it always worked. The bad part is that I need to sto
On 10/25/21 15:43, E-BLOKOS wrote:
what about BTRFS since it's the successor of ZFS?
BTRFS is NOT the successor to ZFS. It never was. It was completely new
file system developed by Oracle Corp. For some reason, Oracle seems to
have lost interest in it. Red Hat has deprecated and, in all li
On 10/25/21 1:40 PM, Mladen Gogala wrote:
This is probably not the place
to discuss the inner workings of snapshots, but it is worth knowing that
snapshots drastically increase the IO rate on the file system - for
every snapshot. That's where the slowness comes from.
I have recent anecdotal e
In my opinion, ext4 will solve any and all problems without a very deep
understanding of file system architecture. In short, i would stick with
ext4 unless you have a good reason not to. Maybe there is one. I have done
this a long time and never thought twice about which file system should
support
Hello,
As we need to use the plpython3u extension, we tried to install the
plpython3 package but showed that we needed to install python3-libs,
but python36-libs was already installed for patroni usage.
1. Will installing python3-libs affect current python36-libs usage?
2. If we can do some confi
Hi Team,
Please have a look on the below problem statement and suggest us if there
are any ways to make the planner pick PARALLEL INDEX SCAN and PARALLEL
APPEND
*Problem Statement :*
We have a partitioned table with a partition key column (crdt -->
timestamp). A SELECT query on this table that d
12 matches
Mail list logo
