Re: Make recently inserted/updated records available in the buffer/cache
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Make recently inserted/updated records available in the buffer/cache
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Tue, 3 Dec 2019 10:29:18 -0700
Cc
: Hüseyin Demir <demirhuseyinn.94@xxxxxxxxx>, Sachin Divekar <ssd532@xxxxxxxxx>, postgres performance list <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to
: <
d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com
>
References
: <CA+A8H7mJiWaohQv0k6Fv2i-nuRKyzDKu-J8vwp_DS72=zL-eCw@mail.gmail.com> <
CALqEK1cDD5BRXeUkmbLJdbohfE6O0QycYUfm0j3PS96LSojxtQ@mail.gmail.com
> <
d9916d03-8ba1-4e83-816e-2a6157161cce@sqlexec.com
>
"I am going to use it as a queue"
You may want to look at lowering fillfactor if this queue is going to have frequent updates, and also make autovacuum/analyze much more aggressive assuming many updates and deletes.
Follow-Ups
:
Re: Make recently inserted/updated records available in the buffer/cache
From:
MichaelDBA
References
:
Make recently inserted/updated records available in the buffer/cache
From:
Sachin Divekar
Re: Make recently inserted/updated records available in the buffer/cache
From:
Hüseyin Demir
Re: Make recently inserted/updated records available in the buffer/cache
From:
MichaelDBA
Prev by Date:
Re: [External] Join queries slow with predicate, limit, and ordering
Next by Date:
Re: Make recently inserted/updated records available in the buffer/cache
Previous by thread:
Re: Make recently inserted/updated records available in the buffer/cache
Next by thread:
Re: Make recently inserted/updated records available in the buffer/cache
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
