[GENERAL] Limiting postgresql resources

2008-04-05 Thread Joey K.
Hello, Is it possible to limit cpu/memory resources to queries on postgres something akin to limits.conf on Linux? We have a couple of databases (pg 8.2.7) serving 500K - 1M records. For various reasons, users are allowed to run queries against the database via a web based query interface. These

Re: [GENERAL] Limiting postgresql resources

2008-04-05 Thread Tom Lane
Joey K. [EMAIL PROTECTED] writes: So, is it possible to kill a query thats running for x minutes with 50%+ CPU load and using y MB of memory? There's statement_timeout ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make