John Gage wrote: > Unfortunately, it prompts a new question. I am using 8.4.2 which I > assume is new enough to trigger a "yes" response to "If you have a > version new enough to have synchronize_seqscans...". I have > absolutely no idea how to turn that off. Perhaps the best thing > would be to direct me to the documentation where turning it off is > described so that I can become more autonomous. However, > accompanying that with explicit directions would be welcome too.
See postgresql.conf, but you probably want to leave it turned on in general and turn it off only for the specific case of this usage. (Using the SET command, or ALTER ROLE, or ALTER DATABASE). See here http://www.postgresql.org/docs/8.4/static/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
