Re: From Simple to Complex

To: Merlin Moncure <mmoncure@xxxxxxxxx>
Subject: Re: From Simple to Complex
From: Alessandro Gagliardi <alessandro@xxxxxxxx>
Date: Thu, 2 Feb 2012 11:38:13 -0800
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <CAHyXU0y5RaM6amFXnR-m=hQ0QmPsAA+Tw_erFe80JPY3_7iphQ@mail.gmail.com>
References: <CAAB3BB+TB+SkR4cnySdkhzC9VNxaZ4MBcba8SMfz6KP1Pi8mxg@mail.gmail.com> <CAAB3BBKxBK1suf9GcKUibWaK_WT7+V5rrLp+FPR7HXoC7EFHQQ@mail.gmail.com> <CAAB3BBJwKV2UpzHFfXXMxLAfOx4QiCpJ3r1QE0BpQeLSeZ7PjQ@mail.gmail.com> <CAAB3BB+tgVjObo5tt3XM2yyvxQyqKNEyu+NdtrcTD806WJYoYg@mail.gmail.com> <CAAB3BBJuFOEX77bzxNTpxTzVmyJ5cUssVKbo9o=diK1wz11FRQ@mail.gmail.com> <CAOR=d=10PeWnfRjJARMfj+qa_Fs8ZHn8qz96Eqd1FkXGNcyB1Q@mail.gmail.com> <CAAB3BB+8-7CQi+CmbFBsUZ1RRkKPvCnr4aPW6s48i1fC-ZKb6g@mail.gmail.com> <CAHyXU0y5RaM6amFXnR-m=hQ0QmPsAA+Tw_erFe80JPY3_7iphQ@mail.gmail.com>

On Thu, Feb 2, 2012 at 6:52 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:

also, is effective_cache_size set to a reasonable value?

Yeah, it's 1530000kB

References:
- From Simple to Complex
  - From: Alessandro Gagliardi
- Re: From Simple to Complex
  - From: Alessandro Gagliardi
- Re: From Simple to Complex
  - From: Alessandro Gagliardi
- Re: From Simple to Complex
  - From: Alessandro Gagliardi
- Re: From Simple to Complex
  - From: Alessandro Gagliardi
- Re: From Simple to Complex
  - From: Scott Marlowe
- Re: From Simple to Complex
  - From: Alessandro Gagliardi
- Re: From Simple to Complex
  - From: Merlin Moncure