| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | John Gage <jsmgage(at)numericable(dot)fr> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Row ordering after CREATE TABLE AS...SELECT regexp_split_to_table(source_text, regexp) AS new_column |
| Date: | 2010-02-24 14:20:06 |
| Message-ID: | 20100224142006.GF3790@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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).
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitesh Patel | 2010-02-24 14:20:54 | bugs reporting |
| Previous Message | Alvaro Herrera | 2010-02-24 14:02:19 | Re: pg_buffercache's usage count |