> 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
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?
In response to
pgsql-performance by date
|Next:||From: Mike Nielsen||Date: 2002-11-11 17:44:44|
|Subject: Query performance discontinuity|
|Previous:||From: Wei Weng||Date: 2002-11-11 17:19:47|
|Subject: Re: Slow response from 'SELECT * FROM table'|