Re: autovacuum is running but pg_stat_all_tables empty

2018-11-19 Thread Laurenz Albe
Mariel Cherkassky wrote: > I'm trying to understand something that is weird on one of my environments. > When I query pg_stat_all_tables I see that most of the tables dont have any > value in the last_autovacuum/analyze column. In addition the columns > autovacuum_count/analyze_count is set to 0. H

autovacuum is running but pg_stat_all_tables empty

2018-11-19 Thread Mariel Cherkassky
Hi, I'm trying to understand something that is weird on one of my environments. When I query pg_stat_all_tables I see that most of the tables dont have any value in the last_autovacuum/analyze column. In addition the columns autovacuum_count/analyze_count is set to 0. However, when checking the log

Re: PostgreSQL VS MongoDB: a use case comparison

2018-11-19 Thread Stephen Frost
Greetings, * Fabio Pardi (f.pa...@portavita.eu) wrote: > We are open to any kind of feedback and we hope you enjoy the reading. Looks like a lot of the difference being seen and the comments made about one being faster than the other are because one system is compressing *everything*, while PG (q

PostgreSQL VS MongoDB: a use case comparison

2018-11-19 Thread Fabio Pardi
Hi list, For your consideration I'm submitting you a research I made together with my colleague Wouter. We compared the 2 databases for our specific use case on medical data stored using FHIR standard. This is indeed a very restrictive use case, and moreover under read only circumstances. We