| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | Igor Neyman <ineyman(at)perceptron(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: seqscan for 100 out of 3M rows, index present |
| Date: | 2013-06-26 20:12:02 |
| Message-ID: | CAHnozTijV0A64pcM+NtU+ZpPjwtADroiJ9kzZ5CEX6ZRqNoraw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, Jun 26, 2013 at 9:30 PM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:
>
> How much RAM you have on this machine?
>
16 GB
> What else is this machine is being used for (besides being db server)?
>
It's my laptop by now, but i was working on a server before that. The
laptop gives me some liberties to play around.
I could reproduce it well on my laptop, so i thought it would do.
> And, what is your setting for effective_cache_size? It looks like you
> didn't change it from default (128MB).
> You need to adjust effective_cache_size so somewhat between 60%-75% of
> RAM, if the database is the main process running on this machine.
>
correct, it was 128GB, changed it to 12GB, to no avail.
>
>
>
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2013-06-26 20:31:29 | Re: seqscan for 100 out of 3M rows, index present |
| Previous Message | Igor Neyman | 2013-06-26 19:30:17 | Re: seqscan for 100 out of 3M rows, index present |