Re: [pgadmin-support] SQL query timing question

2005-06-03 Thread Andreas Pflug
Dave Lazar wrote: Hi, I have a table with 10 rows, and about 50 columns. Not much need for indexing. When I execute a select * command, it can take 18ms to run the query, but 1300ms for the data retrieval time for example... What controls this data retrieval timing? It seems like my query execu

Re: [pgadmin-support] SQL query timing question

2005-06-03 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Lazar > Sent: 02 June 2005 20:00 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] SQL query timing question > > Hi, > > I have a table with 10 r

[pgadmin-support] SQL query timing question

2005-06-02 Thread Dave Lazar
Hi, I have a table with 10 rows, and about 50 columns. Not much need for indexing. When I execute a select * command, it can take 18ms to run the query, but 1300ms for the data retrieval time for example... What controls this data retrieval timing? It seems like my query executes fast, but the bo