Re: postgres index usage count too high

2021-04-28 Thread Laurenz Albe
On Wed, 2021-04-28 at 18:41 -0400, Ayub M wrote: > There is a table in the db, whose index_scan count from pg_stat_all_tables > for this > table seems to be too high, there are not that many queries being executed > against > this table. Wondering how this count can be too high. The table cont

postgres index usage count too high

2021-04-28 Thread Ayub M
There is a table in the db, whose index_scan count from pg_stat_all_tables for this table seems to be too high, there are not that many queries being executed against this table. Wondering how this count can be too high. 1. The db is up since 80 days so I assume these are cumulative stats si

Re: pgbouncer configuration

2021-04-28 Thread Chris Stephens
I had to install pam-devel before reinstalling pgbouncer. appears to be working now. thanks for pointing me in the right direction Laurenz! On Wed, Apr 28, 2021 at 7:09 AM Chris Stephens wrote: > huh. you are right. i originally installed pgbouncer with yum but removed > with just "yum remove pg

Re: pgbouncer configuration

2021-04-28 Thread Chris Stephens
huh. you are right. i originally installed pgbouncer with yum but removed with just "yum remove pgbouncer" before following "Building from Git" section at http://www.pgbouncer.org/install.html. i just ran "make uninstall" -> reinstalled with 403 21-04-28 06:58:32 git submodule init 404 21-0

Re: Oracle vs. PostgreSQL - a comment

2021-04-28 Thread Ludovico Caldara
Sorry for this reply, but I feel it is necessary to make it clear what is reality and what is FUD against Oracle from Paul's e-mails in this thread... (Note: I work for Oracle now, but I've had 20 years experience as multi-platform database consultant) Paul Förster wrote: > Oracle requires 161