Re: using an index worst performances

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-----

In response to

Browse pgsql-performance by date

  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