| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: EXPLAIN ANALYZE on 8.2 |
| Date: | 2006-12-14 16:11:42 |
| Message-ID: | 21146.1166112702@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> writes:
> Running the same query on pg 8.2 through EXPLAIN ANALYZE takes 4x-10x time as running it without it.
If your machine has slow gettimeofday() this is not surprising. 8.2 is
no worse (or better) than any prior version.
Some quick arithmetic from your results suggests that gettimeofday() is
taking about 3.3 microseconds, which is indeed pretty awful. What sort
of machine is this exactly?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Evgeny Gridasov | 2006-12-14 16:29:20 | Re: EXPLAIN ANALYZE on 8.2 |
| Previous Message | Tom Lane | 2006-12-14 15:58:56 | Re: Operator class group proposal |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew O'Connor | 2006-12-14 16:16:14 | Re: New to PostgreSQL, performance considerations |
| Previous Message | Ron | 2006-12-14 16:03:08 | Re: New to PostgreSQL, performance considerations |