| From: | Mathijs Brands <mathijs(at)ilse(dot)nl> |
|---|---|
| To: | Kevin Quinlan <kquinlan(at)computer(dot)org> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Speed of SQL statements |
| Date: | 2001-02-23 14:44:22 |
| Message-ID: | 20010223154422.B74755@ilse.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 books
which are your very own".
Sir Arthur Conan Doyle (1859-1930)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-02-23 15:14:08 | Re: insert values |
| Previous Message | Mathijs Brands | 2001-02-23 14:42:44 | Re: Speed of SQL statements |