Re: Bitmap Heap scan 8.1/8.2

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bitmap Heap scan 8.1/8.2
Date: 2007-10-22 21:01:58
Message-ID: 471D0FC6.5000408@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule wrote:
> 2007/10/22, Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)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
---------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-10-22 21:25:50 Re: unicode searches failing that use % and LIKE operators
Previous Message Tom Lane 2007-10-22 21:01:45 Re: unicode searches failing that use % and LIKE operators