On Wed, Nov 25, 2020 at 03:59:06PM +0100, Laurenz Albe wrote:
> On Tue, 2020-11-24 at 11:34 -0600, Ron wrote:
> > And if you're afraid of autovacuum and autoanalyze stealing resources, then
> > disable them (at the table level).
>
> Ugh, bad advice.
>
> Better would be to VACUUM (FREEZE) these s
On 11/25/20 8:59 AM, Laurenz Albe wrote:
On Tue, 2020-11-24 at 11:34 -0600, Ron wrote:
And if you're afraid of autovacuum and autoanalyze stealing resources, then
disable them (at the table level).
Ugh, bad advice.
Better would be to VACUUM (FREEZE) these static table once, then autovacuum
wo
On Tue, 2020-11-24 at 11:34 -0600, Ron wrote:
> And if you're afraid of autovacuum and autoanalyze stealing resources, then
> disable them (at the table level).
Ugh, bad advice.
Better would be to VACUUM (FREEZE) these static table once, then autovacuum
won't ever perform resource consuming acti
On 11/24/20 8:36 AM, David Gauthier wrote:
Hi:
11.3 on linux
I've come up with a plan to archive data from my main DB which involves
creating other DBs on the same server. But even though there will be zero
activity on the archive DBs in terms of insert/update/delete, and almost
no activity
On 11/24/20 7:33 AM, David Gauthier wrote:
Ok, thanks.
I was also planning on manually running vacuum, reindex and analyze on
the main DB after removing the data from the main DB after archiving.
Does that sound necessary and reasonable ?
Sounds reasonable.
On Tue, Nov 24, 2020 at 10:15
On Tue, Nov 24, 2020 at 10:33:46AM -0500, David Gauthier wrote:
> Ok, thanks.
>
> I was also planning on manually running vacuum, reindex and analyze on the
> main
> DB after removing the data from the main DB after archiving. Does that sound
> necessary and reasonable ?
This blog entry summar
Ok, thanks.
I was also planning on manually running vacuum, reindex and analyze on the
main DB after removing the data from the main DB after archiving. Does
that sound necessary and reasonable ?
On Tue, Nov 24, 2020 at 10:15 AM Adrian Klaver
wrote:
> On 11/24/20 6:36 AM, David Gauthier wrote:
On 11/24/20 6:36 AM, David Gauthier wrote:
Hi:
11.3 on linux
I've come up with a plan to archive data from my main DB which involves
creating other DBs on the same server. But even though there will be
zero activity on the archive DBs in terms of insert/update/delete, and
almost no activity
On Tue, Nov 24, 2020 at 7:36 AM David Gauthier
wrote:
> Hi:
>
> 11.3 on linux
>
> I've come up with a plan to archive data from my main DB which involves
> creating other DBs on the same server. But even though there will be zero
> activity on the archive DBs in terms of insert/update/delete, an
Hi:
11.3 on linux
I've come up with a plan to archive data from my main DB which involves
creating other DBs on the same server. But even though there will be zero
activity on the archive DBs in terms of insert/update/delete, and almost no
activity in terms of select, I'm still worried that the
10 matches
Mail list logo
