vacuum an all frozen table

2024-05-21 Thread Senor Cervesa
Hi All, I'd like to understand what's happening here and whether there is anything I can do to improve the situation. PostgreSQL v11.22 (yeah, I know. Needs upgrade) The following 3 autovacuum log entries show a vacuum of an append only table that has not had any changes since the end of

Re: Linked directory or explicit reference

2024-05-01 Thread Senor Cervesa
On 4/30/2024 17:31, Ron Johnson wrote: On Tue, Apr 30, 2024 at 7:00 PM Senor Cervesa wrote: Hi All; When doing an initial install of PostgreSQL on RHEL 7 or 8 derived OS via rpm, what are pros, cons and recommendations of these 2 procedures for utilizing a second disk

Linked directory or explicit reference

2024-04-30 Thread Senor Cervesa
Hi All; When doing an initial install of PostgreSQL on RHEL 7 or 8 derived OS via rpm, what are pros, cons and recommendations of these 2 procedures for utilizing a second disk? Secondary SSD or RAID mounted at /disk2. Option #1 1. install the rpm which creates basic user and home 2.