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

Jirka,

>   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?

I can think of any number of reasons why.   However, I need more detail
from you:

1) Why are you selecting 500,000 rows at once?

2) Is "SELECT * FROM table_a" the entirety of your query, or was there
more to it than that?

3) Are you talking about PSQL, or some other interface?

-Josh Berkus