Re: limiting query time and/or RAM

From: Alan McKay <alan(dot)mckay(at)gmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: limiting query time and/or RAM
Date: 2009-09-17 19:19:22
Message-ID: 844129e80909171219vfe19044k989e2638bf7c765f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Generally speaking work_mem limits ram used.  What are your
> non-default postgresql.conf settings?

This cannot be right because we had queries taking 4G and see our
setting is such :

work_mem = 2MB # min 64kB

I'll have to find a copy of the default file to figure out what my
non-defaults are

--
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-09-17 19:23:02 Re: limiting query time and/or RAM
Previous Message Jonathan 2009-09-17 19:16:34 haversine formula with postgreSQL