Slow response from 'SELECT * FROM table'

Поиск
Список
Период
Сортировка
От Jirka Novak
Тема Slow response from 'SELECT * FROM table'
Дата
Msg-id 3DCF8188.2040001@netsystem.cz
обсуждение исходный текст
Ответы Re: Slow response from 'SELECT * FROM table'
Re: Slow response from 'SELECT * FROM table'
Список pgsql-performance
Hi,

   I have table with 30 columns and 30000..500000 rows. When I make
'SELECT * FROM table' postgresql start doing something and return first
row after 10s (for 30k rows) and after 5min (500k rows). It looks like
it copy whole response to temp space and after that it shows it.
   I don't know why. I tested same table structure and datas on Oracle
and MSSQL and both returned first row immediatly.
   Have someone any idea?

                            Jirka Novak


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Does this matter?
Следующее
От: Jakub Ouhrabka
Дата:
Сообщение: Re: Slow response from 'SELECT * FROM table'