Re: Detect missing combined indexes (automatically)

Hi Julien Rouhaud, powa can handle multi-column indexes now? Great news. This must be a new feature. I checked this roughly one year ago and it was not possible at this time. Thank you very much powa! Regards, Thomas Güttler Am 14.01.19 um 08:42 schrieb Julien Rouhaud: On Mon, Jan 14, 2019

Detect missing combined indexes (automatically)

lable. Regards, Thomas Güttler -- Thomas Guettler http://www.thomas-guettler.de/ I am looking for feedback: https://github.com/guettli/programming-guidelines

Automated bottleneck detection

This sound good. Looks like an automated bootleneck detection could be possible with pg_wait_sampling. Regards, Thomas Am 25.07.2018 um 12:25 schrieb Julien Rouhaud: On Wed, Jul 25, 2018 at 11:14 AM, Thomas Güttler wrote: AFAIK powa is based on pg_stat_statements not on statistical

Re: Profile what the production server is doing

Am 23.07.2018 um 17:16 schrieb Flo Rance: pgobserver might do that as well, particulary useful for functions performances. https://github.com/zalando/PGObserver Thank you for pointing me to this. After googling for "PGObserver powa" I found nice collection of current tools: https://

Re: Profile what the production server is doing

Am 23.07.2018 um 16:01 schrieb Baron Schwartz: I'm biased, but I think VividCortex (my company's product) is amazing at this. Looks goog, but "Contact us for pricing options" from https://www.vividcortex.com/product/pricing Why do you hide your prices? Regards, Thom

Re: Profile what the production server is doing

Am 23.07.2018 um 13:38 schrieb Julien Rouhaud: Hi, On Mon, Jul 23, 2018 at 1:18 PM, Thomas Güttler wrote: Is there a tool which does this for PostgreSQL? Take a "snapshot" of what the server is doing about 10 times per second. Write this to a file. After N hours you can aggregat

Profile what the production server is doing

r is there a better way? Regards, Thomas Güttler -- Thomas Guettler http://www.thomas-guettler.de/ I am looking for feedback: https://github.com/guettli/programming-guidelines

Details after Load Peak was: OT: Performance of VM

Am 05.02.2018 um 14:26 schrieb Andreas Kretschmer: Am 05.02.2018 um 14:14 schrieb Thomas Güttler: What do you suggest to get some reliable figures? sar is often recommended, see https://blog.2ndquadrant.com/in-the-defense-of-sar/. Can you exclude other reasons like vacuum / vacuum

OT: Performance of VM

reliable figures? Regards, Thomas Güttler -- Thomas Guettler http://www.thomas-guettler.de/ I am looking for feedback: https://github.com/guettli/programming-guidelines