Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Дата
Msg-id 21524.1087394109@sss.pgh.pa.us
обсуждение исходный текст
Ответ на weired behavior... after pg_resetxlog-> dump->initdb-->reload.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Ответы Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-admin
Дерево обсуждения 
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> rt2=# SELECT name from users group by name having count(*) > 1 limit 20;
> (4 rows)
> rt2=# SELECT name from users group by name having count(*) > 1 ;
> (0 rows)

Weird.  What PG version is this?  What does EXPLAIN show for each of
these queries (maybe EXPLAIN ANALYZE too)?  Can you provide a
self-contained test case?

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Дата:
Сообщение: Re: VARCHAR -vs- CHAR: huge performance difference?
Следующее
От: "C. Bensend"
Дата:
Сообщение: Re: VARCHAR -vs- CHAR: huge performance difference?