Re: SELECT constant; takes 15x longer on 9.0?

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: SELECT constant; takes 15x longer on 9.0?
Дата
Msg-id 157174C9-CA95-474A-B263-D26D74FD0C4C@kineticode.com
обсуждение исходный текст
Ответ на Re: SELECT constant; takes 15x longer on 9.0?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SELECT constant; takes 15x longer on 9.0?
Список pgsql-hackers
On Apr 6, 2010, at 11:15 AM, Tom Lane wrote:

>> By stupidly having configured with --enable-cassert --enable-debug without realizing it. I've just rebuilt without
themand run the tests again using the default postgresql.conf and I'm back down to 57s and 46s over two runs. 
>
> Huh.  I'm still curious, because in my test the overhead of those
> options seemed to be about 3x.  So there's still something considerably
> different between what you did and what I did.

Are you doing this on a Mac?

> Are you testing a separate connection per ping query?  I think I
> neglected to compare that case with and without assert overhead.

No, should be one connection for the entire test suite.

Best,

David

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: SELECT constant; takes 15x longer on 9.0?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Remaining Streaming Replication Open Items