Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level - Mailing list pgsql-admin

From Gabriel Muñoz
Subject Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
Date
Msg-id CAP8pxBYAbBRKRaS47nar6hd9oTZfD0VVaD+dDKc_gHQHr+i2wQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level  (Shams Khan <shams.khan22@gmail.com>)
List pgsql-admin
Tree view
Maybe

explain analyze select count(distinct a.subsno )  from subsexpired a where a.subsno not in (select b.subsno from subs b  where b.subsno>75043 and b.subsno<=112565) and a.subsno>75043 and a.subsno<=112565;

Give you more information about real excecuting time.


About postgres.conf

checkpoint_segments = 64


Gabriel.

On Fri, Dec 14, 2012 at 4:23 PM, Shams Khan <shams.khan22@gmail.com> wrote:
explain select count(distinct a.subsno )  from subsexpired a where a.subsno not in (select b.subsno from subs b  where b.subsno>75043 and b.subsno<=112565) and a.subsno>75043 and a.subsno<=112565;

pgsql-admin by date:

Previous
From: Shams Khan
Date:
Subject: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
Next
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level