Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level

Поиск
Список
Период
Сортировка
От Gabriel Muñoz
Тема Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
Дата
Msg-id CAP8pxBYAbBRKRaS47nar6hd9oTZfD0VVaD+dDKc_gHQHr+i2wQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level  (Shams Khan <shams.khan22@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Shams Khan
Дата:
Сообщение: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: PostgreSQL Performance Tuning / Postgresql.conf and on OS Level