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

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: SELECT constant; takes 15x longer on 9.0?
Дата
Msg-id 922B93A7-6783-4859-A881-5ADBF0850F3E@kineticode.com
обсуждение исходный текст
Ответ на Re: SELECT constant; takes 15x longer on 9.0?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Apr 6, 2010, at 7:28 AM, Tom Lane wrote:

> There's something wrong with your test setup.  Or, if you'd like me to
> think that there isn't, provide a self-contained test case.  I ran a
> small program that does
> 
>     for (i = 0; i < 10000; i++)
>     {
>         res = PQexec(conn, "SELECT 'DBD::Pg ping test'");
>         PQclear(res);
>     }
> 
> and I only see a few percent difference between HEAD and 8.4.3,
> on two different machines.  (It does appear that HEAD is a bit slower
> for this, which might or might not be something to worry about.)

I'm going to see if I can replicate it on a second box today.

Best,

David



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Remaining Streaming Replication Open Items
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Proposal: Add JSON support