Re: Speed of SQL statements - Mailing list pgsql-sql

From Mathijs Brands
Subject Re: Speed of SQL statements
Date
Msg-id 20010223154422.B74755@ilse.nl
Whole thread Raw
In response to Speed of SQL statements  ("Kevin Quinlan" <kquinlan@computer.org>)
List pgsql-sql
On Sun, Feb 18, 2001 at 03:42:43PM -0500, Kevin Quinlan allegedly wrote:
> Does anyone have any performance numbers regarding SQL statements,
> specifically SELECT, UPDATE, DELETE, and INSERT?  For instance, on average
> how long does a typical SELECT (UPDATE, DELETE, INSERT) statement take to
> execute?

Performance is not easily expressed in time, since it depends a lot on the
way you've setup your database and your queries (indexes, etc). Of course,
the hardware you use also influences the execution time a lot.

Cheers,

Mathijs
-- 
"It is a great thing to start life with a small number of really good bookswhich are your very own".        Sir Arthur
ConanDoyle  (1859-1930)
 


pgsql-sql by date:

Previous
From: Mathijs Brands
Date:
Subject: Re: Speed of SQL statements
Next
From: Tom Lane
Date:
Subject: Re: insert values