From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: using an index worst performances |
Date: | 2004-08-22 10:08:47 |
Message-ID: | 412870AF.5050202@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Rod Taylor wrote:
|>>What are the times without the index, with the index and with the higher
|>>statistics value when using a prepared query?
|>
|>Using a prepared query:
|>
|>Without index and default stat 10 : 1.12 ms
|>Without index and default stat 1000 : 1.25 ms
|>With index and default stat 10: 1.35 ms
|>With index and default stat 1000: 1.6 ms
|>
|>that values are the average obtained after the very first one,
|>on 20 execution.
|
|
| Most interesting. And the plans chosen with the 2 different default stat
| targets are the same? Sorry if I missed the post indicating they were.
|
| If the plans are the same, it would be interesting to get a profile on
| the 2 different cases with that index in place across 100k iterations of
| the prepared query.
Do you have an advice on the profiler to use ?
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBKHBg7UpzwH2SGd4RAmGCAKDOZ3xXNPFhhGSMN89MssR7UZnY3ACg6sAY
mWKo4uAZzv1ZtmBsfQZ2SBc=
=NQf/
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | my thi ho | 2004-08-23 14:33:10 | postgresql 8.0 beta - fail to collect statsistic |
Previous Message | Brad Bulger | 2004-08-21 01:02:48 | Re: Query Performance |