On Fri, Oct 19, 2012 at 8:07 AM, Shaun Thomas <sthomas@xxxxxxxxxxxxxxxx> wrote: > On 10/19/2012 10:05 AM, Jeff Janes wrote: > >> http://www.postgresql.org/docs/9.0/static/sql-altertablespace.html > > > Yep. I realized my error was not checking the ALTER page after going through > CREATE. I swore I remembered seeing it in the past, but was surprised it > wasn't there. When I didn't see it under CREATE, I went to the docs page for the global page_cost settings, and that page directed me to the ALTER for the tablespace specific ones. It does seem like a statement in the CREATION page indicating that more options are available only via the ALTER of an already existing tablespace would be beneficial. > I keep forgetting Postgres prefers a CREATE + ALTER style than overloading > every CREATE with all ALTER options. Though in my opinion that just adds > extra unnecessary steps. I was surprised by the absence of the option in CREATE. I didn't recognize that as a general pgsql pattern though, I just thought it was peculiar to tablespaces. But I haven't surveyed the universe of create and alter commands. Cheers, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
