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 server
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 &qu
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:
https://stackoverflow.com/questions/4058731/can-postgres
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
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 <
mariel.cher
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_,
> car
There are few things to consider:
- you don't need to use distinct on all columns (and therefore sort all
columns)
- you should try to sort in memory, better than on-disk
- it seems that the planner doesn't predict the good number of rows
Regards,
Florian
On Mon, Sep 9, 2019 at 12:46 PM Justin Pr
