Hi, I have a tool that is trying to collect stats from postgres (v9.1.13). postgres attempts to allocate more memory than is allowed: SELECT mode, count(mode) AS count FROM pg_locks GROUP BY mode ORDER BY mode; ERROR: invalid memory alloc request size 1459291560 Memory-related configs from the server: shared_buffers = 10000MB work_mem = 15MB maintenance_work_mem = 400MB effective_cache_size = 50000MB max_locks_per_transaction = 9000 max_pred_locks_per_transaction = 40000 The machine is running CentOS 6, a 32-core AMD 6276 processor, and is configured with 64GB of memory. Transparent Huge Pages are disabled :-) Thanks in advance for your time and expertise. Dave Owens -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
