and checkpoints are
always timed. The machine is well provisioned, load isn't too high, and cpu
io wait is under 1%.
any suggestions on what I should check more?
Thanks in advance.
--
Bruno da Silva
400, bruno da silva wrote:
> > I'm investigating an issue on a PostgresSql 9.5.21 installation that
> > becomes unusable in an intermittent way. Simple queries like "select
> > now();" could take 20s. commits take 2s. and all gets fixed after an
> engine
> > re
The issue started a month ago.
On Thu, Jul 21, 2022 at 3:59 PM bruno da silva wrote:
> Thanks for the quick response.
>
> OS/version: CentOS release 6.9 (Final)
>
> Hardware(non dedicated to the db, other services and app run the same
> server):
>
> Xeon(R)
Thanks, I will check it out.
On Thu, Jul 21, 2022 at 4:21 PM Justin Pryzby wrote:
> On Thu, Jul 21, 2022 at 03:59:30PM -0400, bruno da silva wrote:
> > OS/version: CentOS release 6.9 (Final)
>
> How are these set ?
>
> tail /sys/kernel/mm/ksm/run
> /sys/kernel/mm/tran
/transparent_hugepage/khugepaged/defrag <==
[yes] no
==> /proc/sys/vm/zone_reclaim_mode <==
0
On Thu, Jul 21, 2022 at 4:32 PM bruno da silva wrote:
> Thanks, I will check it out.
>
> On Thu, Jul 21, 2022 at 4:21 PM Justin Pryzby
> wrote:
>
>> On Thu, Jul 21, 2022 a
0
wal_sender_timeout 0
work_mem 8192
On Thu, Jul 21, 2022 at 2:37 PM bruno da silva wrote:
> Hello.
>
> I'm investigating an issue on a PostgresSql 9.5.21 installation that
> becomes unusable in an
distress
in the postmaster log, like complaints about being unable to write
pgss_query_texts.stat? *no, just complaints for reading it. *
Thanks
On Tue, Aug 2, 2022 at 11:59 AM Tom Lane wrote:
> bruno da silva writes:
> > After more investigation, we found that pgss_query_texts.stat of a
writable.*
Thanks
On Tue, Aug 2, 2022 at 1:25 PM Tom Lane wrote:
> bruno da silva writes:
> > Do you have a lot of especially long statements being tracked
> > in the pg_stat_statements view?* well, the view was showing the query
> > column null.*
> > * but looking on pgss
tat_statement
processing
than leading to slower query responses with a 32bit PG? I'm thinking in
reducing pg_stat_statements.max from 10k to 3k
Thanks
On Tue, Aug 2, 2022 at 3:14 PM Tom Lane wrote:
> I wrote:
> > bruno da silva writes:
> >> Do you have a lot of espe
is: is it safe to assume that because the gc of
pgss_query_texts.stat requires a global lock this is a limitation of
pg_stat_statements current implementation?
Thanks
On Wed, Aug 3, 2022 at 11:17 AM Tom Lane wrote:
> bruno da silva writes:
> > *Question: *Besides the gc issue t
t of churn?
Thanks
--
Bruno da Silva
This problem is more acute when the FK Table stores a small number of rows
like types or codes.
I think in those cases an enum type should be used instead of a column with
a FK.
Thanks.
On Thu, Sep 14, 2023 at 7:23 AM Alvaro Herrera
wrote:
> On 2023-Sep-13, bruno da silva wrote:
>
>
12 matches
Mail list logo
