Hello,
I have a SQL function (which I've pasted below) and while testing its
code directly (outside a function), this is the normal, default plan:
http://explain.depesz.com/s/vfP (67 ms)
and this is the plain with enable_seqscan turned off:
http://explain.depesz.com/s/EFP (27 ms)
Disabling
Hello
2012/5/26 Ivan Voras ivo...@freebsd.org:
Hello,
I have a SQL function (which I've pasted below) and while testing its
code directly (outside a function), this is the normal, default plan:
http://explain.depesz.com/s/vfP (67 ms)
and this is the plain with enable_seqscan turned off:
Here is a sample dump that takes a long time to be written by pg_dump:
http://postgresql.1045698.n5.nabble.com/file/n5710183/test.dump.tar.gz
test.dump.tar.gz
(the file above has 2.4Mb, the dump itself has 66Mb)
This database has 2,311 schemas similar to those in my production database.
All