Re: Vacuum Questions

2025-05-02 Thread John Naylor
a degree of parallelism? There is no way to ask the system to estimate the runtime or other resource usage. Also for future reference, please note that we discourage top-posting (quoting an entire message in a reply). -- John Naylor Amazon Web Services

Re: Performance degradation with CTEs, switching from PG 11 to PG 15

2023-11-22 Thread John Naylor
On Wed, Nov 22, 2023 at 6:39 PM Jean-Christophe Boggio wrote: > > Hello, > > I just switched from PG11 to PG15 on our production server (Version is > 15.5). Just made a vacuum full analyze on the DB. Note that "vacuum full" is not recommended practice in most situations. Among the downsides, it r