-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > Also re: Raymond's request, I tried humoring myself with the EXPLAIN output, > and I actually don't see anything useful-looking at all when I run it on a > stored function like I'm using. Is there any way to utilize EXPLAIN on a > query embedded in a stored function? I could run it just fine on the raw > sql, but the raw sql wasn't what was running slow, so I'm not sure if it's > even helpful to do that. I wrote a blog article about this: Google for "Why is my function slow?" - -- Greg Sabino Mullane greg@xxxxxxxxxxxx End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201005131251 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkvsLjQACgkQvJuQZxSWSsjgzwCfSxAeq4m6KUInlYSoBQECMASe 1psAoLJ8zrzrR4O9V0UZdOr0YHjCbxXj =80ur -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
