Re: Choice of bitmap scan over index scan - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Choice of bitmap scan over index scan
Date
Msg-id 4B49A586020000250002E142@gw.wicourts.gov
Whole thread Raw
In response to Choice of bitmap scan over index scan  (Mathieu De Zutter <mathieu@dezutter.org>)
List pgsql-performance
I wrote:

> work_mem = 32MB

Hmmm...  With 100 connections and 2 GB RAM, that is probably on the
high side, at least if you sometimes use a lot of those connections
at the same time to run queries which might use sorts or hashes. It's
probably safer to go down to 16MB or even back to where you had it.

Sorry I missed that before.

-Kevin



pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Choice of bitmap scan over index scan
Next
From: Robert Haas
Date:
Subject: Re: PG optimization question