Slow response from 'SELECT * FROM table'

From: Jirka Novak <j(dot)novak(at)netsystem(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Slow response from 'SELECT * FROM table'
Date: 2002-11-11 10:08:08
Message-ID: 3DCF8188.2040001@netsystem.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jakub Ouhrabka 2002-11-11 10:13:01 Re: Slow response from 'SELECT * FROM table'
Previous Message Justin Clift 2002-11-11 07:44:24 Re: Upgrade to dual processor machine?