Slow response from 'SELECT * FROM table' - Mailing list pgsql-performance

From Jirka Novak
Subject Slow response from 'SELECT * FROM table'
Date
Msg-id 3DCF8188.2040001@netsystem.cz
Whole thread Raw
Responses Re: Slow response from 'SELECT * FROM table'  (Jakub Ouhrabka <jouh8664@ss1000.ms.mff.cuni.cz>)
Re: Slow response from 'SELECT * FROM table'  ("Josh Berkus" <josh@agliodbs.com>)
List 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 by date:

Previous
From: Neil Conway
Date:
Subject: Re: Does this matter?
Next
From: Jakub Ouhrabka
Date:
Subject: Re: Slow response from 'SELECT * FROM table'