Re: select distinct runs slow on pg 10.6

2019-09-09 Thread Flo Rance
On Mon, Sep 9, 2019 at 10:38 AM yash mehta wrote: > In addition to below mail, we have used btree indexes for primary key > columns. Below is the query: > > select distinct shipmentre0_.FIN_IDas FIN1_53_0_, > workflowst10_.FIN_ID as FIN1_57_1_, >

Re: Trying to handle db corruption 9.6

2019-05-20 Thread Flo Rance
Hi, First of all, as stated in the wiki, you'll need to do a filesystem level copy of the database files and put them on another drive before attempting to do anything else ! https://wiki.postgresql.org/wiki/Corruption regards, Flo On Mon, May 20, 2019 at 4:40 PM Mariel Cherkassky <

Re: Planner not choosing GIN index

2019-03-13 Thread Flo Rance
Yep, honestly this is far beyond my knowledge. On Wed, Mar 13, 2019 at 2:56 PM Corey Huinker wrote: > On Wed, Mar 13, 2019 at 5:11 AM Flo Rance wrote: > >> It is an expected behavior. You can see the list of array operators with >> which a GIN index can be used in th

Re: Planner not choosing GIN index

2019-03-13 Thread Flo Rance
It is an expected behavior. You can see the list of array operators with which a GIN index can be used in the doc: https://www.postgresql.org/docs/current/indexes-types.html And a very good and detailed explanation about any operator here:

Re: Profile what the production server is doing

2018-07-25 Thread Flo Rance
3.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 "PG

Re: Profile what the production server is doing

2018-07-23 Thread Flo Rance
pgobserver might do that as well, particulary useful for functions performances. https://github.com/zalando/PGObserver On Mon, Jul 23, 2018 at 1:18 PM, Thomas Güttler < guettl...@thomas-guettler.de> wrote: > Is there a tool which does this for PostgreSQL? > > Take a "snapshot" of what the