Message-ID: <442FF9C0.2070702@web.de>
Date: Sun, 02 Apr 2006 18:20:16 +0200
From: Jan Kesten <jan.kesten@web.de>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: index not used again
References: <442CF375.2080903@web.de>
	<20060331064252.J61282@megazone.bigpanda.com>
In-Reply-To: <20060331064252.J61282@megazone.bigpanda.com>
OpenPGP: id=82201FC4;
	url=http://gpg-keyserver.de
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig73D473C4F4EAA40FB404890A"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig73D473C4F4EAA40FB404890A
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Stephan Szabo schrieb:

> Did you reset the table contents between these two (remember that
> explain analyze actually runs the query)?  The second appears to be
> changing no rows from the output.

I for myself did not, but as there are runnig automatic jobs
periodically I can't tell, if one ran in the time while I was testing
(but I guess not). At starting my tests all rows contained a zero for
all tokens and there should be no ones at all.

In my case rows with token set to one are really rare, about one of a
thousand rows. I looked for fast way to find therse rows.

I'll try again after a successful run - not resetting the token (not
using analyse this time).

Cheers,
Jan


--------------enig73D473C4F4EAA40FB404890A
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3-cvs (MingW32)
Comment: GnuPT 2.7.6
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEL/nCvvmCkIIgH8QRAn5kAKC2UqgyBKZeH19Ot8htLrJA4kwingCeLTgR
y+PvfErLkni+B6kW5TZ7PeQ=
=JTgs
-----END PGP SIGNATURE-----

--------------enig73D473C4F4EAA40FB404890A--