Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Patches > Re: pg_dump add...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 29 of 48 Topic 3909 of 3930
Post > Topic >>

Re: pg_dump additional options for performance

by tgl@[EMAIL PROTECTED] (Tom Lane) Jul 21, 2008 at 04:38 PM

Stephen Frost <sfrost@[EMAIL PROTECTED]
> writes:
> * Tom Lane (tgl@[EMAIL PROTECTED]
) wrote:
>> As far as the do***entation/definition aspect goes, I think it should
>> just say the parts are
>> * stuff needed before you can load the data
>> * the data
>> * stuff needed after loading the data

> Even that is a lie though, which I guess is what my problem is.

True; the stuff done after is done that way at least in part for
performance reasons rather than because it has to be done that way.
(I think it's not only performance issues, though --- for circular
FKs you pretty much have to load the data first.)

>> I hadn't realized that Simon was using "pre-schema" and "post-schema"
>> to name the first and third parts.  I'd agree that this is confusing
>> nomenclature: it looks like it's trying to say that the data is the
>> schema, and the schema is not!  How about "pre-data and "post-data"?

> Argh.  The command-line options follow the 'data'/'load' line
> (--schema-pre-load and --schema-post-load), and so I think those are
> fine.  The problem was that in the do***entation he switched to saying
> they were "Pre-Schema" and "Post-Schema", which could lead to confusion.

Ah, I see.  No objection to those switch names, at least assuming we
want to stick to positive-logic switches.  What did you think of the
negative-logic suggestion (--omit-xxx)?

			regards, tom lane

-- 
Sent via pgsql-patches mailing list (pgsql-patches@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches
 




 48 Posts in Topic:
pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-19 23:07:49 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-20 05:47:09 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-22 07:35:30 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-20 07:37:42 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-20 17:43:35 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-24 09:56:49 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-26 10:05:04 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-26 11:11:10 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-26 12:24:07 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-26 12:20:04 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-26 12:43:55 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-26 13:43:06 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-27 20:44:26 
Re: pg_dump additional options for performance
jd@[EMAIL PROTECTED] (&q  2008-07-27 19:40:25 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-27 22:50:18 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-26 17:56:42 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-26 13:56:14 
Re: pg_dump additional options for performance
daveg@[EMAIL PROTECTED]   2008-07-26 18:33:51 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-27 20:52:24 
Re: pg_dump additional options for performance
chris <cbbrowne@[EMAIL  2008-08-01 14:02:30 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-08-02 11:24:01 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-27 10:31:48 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-20 22:59:40 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-20 21:18:29 
Re: pg_dump additional options for performance
daveg@[EMAIL PROTECTED]   2008-07-20 18:49:42 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-20 21:58:50 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-20 23:34:35 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-21 07:54:16 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-21 16:38:57 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-21 17:00:57 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-21 19:19:46 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-21 07:11:27 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-21 07:46:39 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-21 07:17:20 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-21 02:47:50 
Re: pg_dump additional options for performance
andrew@[EMAIL PROTECTED]   2008-07-21 11:19:40 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-21 11:38:04 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-21 07:56:02 
Re: pg_dump additional options for performance
jd@[EMAIL PROTECTED] (&q  2008-07-26 11:03:23 
Re: pg_dump additional options for performance
jd@[EMAIL PROTECTED] (&q  2008-07-27 09:57:17 
Re: pg_dump additional options for performance
andrew@[EMAIL PROTECTED]   2008-07-27 19:42:24 
Re: pg_dump additional options for performance
jd@[EMAIL PROTECTED] (&q  2008-07-27 17:24:42 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-27 10:37:34 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-21 20:26:38 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-23 17:40:37 
Re: pg_dump additional options for performance
simon@[EMAIL PROTECTED]   2008-07-23 18:09:47 
Re: pg_dump additional options for performance
sfrost@[EMAIL PROTECTED]   2008-07-23 23:20:47 
Re: pg_dump additional options for performance
tgl@[EMAIL PROTECTED] (T  2008-07-24 03:54:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Aug 21 23:10:12 CDT 2008.