Re: Bitmap Heap scan 8.1/8.2 - Mailing list pgsql-general

From Martin Marques
Subject Re: Bitmap Heap scan 8.1/8.2
Date
Msg-id 471D0FC6.5000408@bugs.unl.edu.ar
Whole thread Raw
In response to Re: Bitmap Heap scan 8.1/8.2  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: Bitmap Heap scan 8.1/8.2  ("Pavel Stehule" <pavel.stehule@gmail.com>)
List pgsql-general
Pavel Stehule wrote:
> 2007/10/22, Martin Marques <martin@bugs.unl.edu.ar>:
>> Pavel Stehule wrote:
>>> Hello
>>>
>>> I am unsure, did you check config values?
>> Don't know which ones you are talking about, but all enable_* are set to on.
>>
>> Anything else?
>>
>
> shared_buffers

8.1:

  16000


8.2:

  400MB


> work_mem

8.1:

  8192

8.2:

  4MB


> effective_cache_size

8.1:

  1000

8.2:

  128MB


--
  21:50:04 up 2 days,  9:07,  0 users,  load average: 0.92, 0.37, 0.18
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
     del Litoral             |   Administrador
---------------------------------------------------------

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: unicode searches failing that use % and LIKE operators
Next
From: Gregory Stark
Date:
Subject: Re: unicode searches failing that use % and LIKE operators