ive/option-archive-async
--
Don Seiler
www.seiler.us
abling that first (since it doesn't require a DB
restart like changing wal_buffers does). I imagine enabling wal_compression
would save some IO.
I'm interested to hear what you folks think about either or both of these
suggestions.
Thanks,
Don.
--
Don Seiler
www.seiler.us
le overall in the
> next tick. So a flood of new connections were created within that 15 second
> interval (probably all within the same second) and more or less abandoned.
Don.
--
Don Seiler
www.seiler.us
e been in a similar scenario with anecdotes to share.
Thanks,
Don.
--
Don Seiler
www.seiler.us
oreign key child tables but they never run
deletes on those and they are very small. I did mention it to the app team
as a best practice in the meantime but I don't think it would play a part
in our current issue.
Don.
--
Don Seiler
www.seiler.us
ts have been added recently or if any foreign key indexes may have
> inadvertently been removed. Indexing the foreign keys resolved our issue.
>
Interesting, I'll run a check for any. Thanks!
Don.
--
Don Seiler
www.seiler.us
d, Jan 06, 2021 at 12:06:27PM -0600, Don Seiler wrote:
> > On Wed, Jan 6, 2021 at 10:51 AM Joshua Drake
> wrote:
> >
> > Looking at the Azure portal metric, we are nowhere close to the
> advertised
> > maximum IOPS or MB/s throughput (under half of the maximum IOPS an
y until you get a terabyte it
seems like a real drop-off as far as Azure storage goes.
I'd be interested to hear what others might have configured on their
write-heavy cloud databases.
[1] https://azure.microsoft.com/en-us/pricing/details/managed-disks/
Don.
--
Don Seiler
www.seiler.us
his
virtualization removes any guarantee of true separation.
I'm wondering if others have experience running self-managed PG in a cloud
setting (especially if in MS Azure) and what they might have seen/done in
cases like this.
Thanks,
Don.
--
Don Seiler
www.seiler.us
On Mon, Apr 13, 2020 at 9:58 AM Justin Pryzby wrote:
> On Mon, Apr 13, 2020 at 09:46:22AM -0500, Don Seiler wrote:
> > ==> /sys/kernel/mm/ksm/run <==
> > 0
>
> Was it off to begin with ?
> If not, you can set it to "2" to "unshare" pages.
>
ays madvise [never]
==> /sys/kernel/mm/transparent_hugepage/defrag <==
always madvise [never]
--
Don Seiler
www.seiler.us
n see:
# dmesg | grep -i numa
[0.00] No NUMA configuration found
We are using HugePages and things look good there as well. Curious what
would be causing kswapd to run hot like it is, or if it is a red herring as
I look into high CPU usage on this box (although, again, it is the
single-high
e're looking
at. I'd be interested in learning for either case.
Don.
--
Don Seiler
www.seiler.us
lso be interested in hearing how others have configured their
PostgreSQL instances for VMs (if there's anything special to think about).
Don.
--
Don Seiler
www.seiler.us
I'm assuming you never analyzed the table after creation & data load? What
does this show you:
select * from pg_stat_all_tables where relname='xyz';
Don.
--
Don Seiler
www.seiler.us
15 matches
Mail list logo
