From: | pradeep pandey <pandeyp(at)hotmail(dot)com> |
---|---|
To: | Alex Balashov <abalashov(at)evaristesys(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Help Needed for pgbench with retry option |
Date: | 2019-11-08 19:59:42 |
Message-ID: | BMXPR01MB3847542EE8E21D98AF5A6522B87B0@BMXPR01MB3847.INDPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Guy's
I need small help on PostgreSQL testing of HA
I am trying to run pgbench but once the primary goes down and secondary comes primary , I want to know know how I can configute pgbench to retry and autoconnect the pgbench workload which I have been running to new Primary .
the idea is to test the Retry feature of pgbench if it exists .
Is pgbeach has Retry fetaure ? if yes then what is parameter for retry needs commands .
can you please help and provide the direction and link
Thanks
Pradeep
________________________________
From: Alex Balashov <abalashov(at)evaristesys(dot)com>
Sent: Thursday, November 7, 2019 7:33 PM
To: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>
Subject: Index degradation
Over a period of some years, particularly in tables whose contents
periodically get swapped out entirely (i.e. lots of dead rows), indexes
slowly degrade, pushing query latency up.
Is there a way to detect this condition short of just monitoring
statement latency, so as to know when to REINDEX / build new indexes?
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2019-11-09 09:19:29 | Re: How to change the TLS certificate/key without restarting the server? |
Previous Message | Bruce Momjian | 2019-11-08 00:16:10 | Re: How to change the TLS certificate/key without restarting the server? |