Re: Slow performance on Windows .NET and OleDb

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Slow performance on Windows .NET and OleDb
Дата
Msg-id op.s66aqgokcigqcu@apollo13
обсуждение исходный текст
Ответ на Re: Slow performance on Windows .NET and OleDb  ("Greg Quinn" <greg@officium.co.za>)
Список pgsql-performance
> 3000 Rows - 7 seconds - very slow

    On my PC (athlon 64 3000+ running Linux), selecting 3000 rows with 4
columns out of a 29 column table takes about 105 ms, including time to
transfer the results and convert them to native Python objects. It takes
about 85 ms on a test table with only those 4 columns.

    There is definitely a problem somewhere on your system.

    I'd suggest running this query in an infinite loop. Logically, it should
use 100% processor, with postgres using some percentage (30% here) and
your client using some other percentage (70% here). Is your processor used
to the max ?

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

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: Slow performance on Windows .NET and OleDb
Следующее
От: Gábriel Ákos
Дата:
Сообщение: statistics buffer is full