[DOCS] DTrace docs, Open Items and Performance
Robert Lor and Josh Berkus have taken up my offer to assist in documenting the new Dynamic Trace facility more fully, which was the one remaining item on the 8.2 Open Items list. I'm planning to - add a new section to Performance Tips chapter called Dynamic Tracing - rename the chapter Performance & Tuning. - add some further intro stuff on chapter header page Comments? -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] DTrace docs, Open Items and Performance
Simon Riggs wrote: > I'm planning to > - add a new section to Performance Tips chapter called Dynamic > Tracing - rename the chapter Performance & Tuning. > - add some further intro stuff on chapter header page In my mind it's a little late for revising the documentation structure. I'd also think that DTrace is not a tuning tool but a monitoring tool which might place it closer to the description of the statistics collector. I think the original plan even placed it into the Internals part. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] DTrace docs, Open Items and Performance
On Tue, 2006-11-28 at 12:09 +0100, Peter Eisentraut wrote: > Simon Riggs wrote: > > I'm planning to > > - add a new section to Performance Tips chapter called Dynamic > > Tracing - rename the chapter Performance & Tuning. > > - add some further intro stuff on chapter header page > > In my mind it's a little late for revising the documentation structure. > I'd also think that DTrace is not a tuning tool but a monitoring tool > which might place it closer to the description of the statistics > collector. I think the original plan even placed it into the Internals > part. An additional chapter then, in the internals section? Dynamictrace.sgml Or a subsection in the Monitoring.sgml chapter? (with the statistics collector stuff) -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [DOCS] DTrace docs, Open Items and Performance
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Simon Riggs wrote: >> I'm planning to >> - add a new section to Performance Tips chapter called Dynamic > In my mind it's a little late for revising the documentation structure. > I'd also think that DTrace is not a tuning tool but a monitoring tool > which might place it closer to the description of the statistics > collector. I think the original plan even placed it into the Internals > part. I was about to say the same. In my mind DTrace is primarily a hacker's tool --- I do not foresee the average DBA using it. So it does not belong in the Performance Tips chapter. A new chapter under Internals is probably as good as anything. regards, tom lane ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [DOCS] [HACKERS] pg_dump -t broken for mixed case table names in beta3?
On Tue, Nov 28, 2006 at 02:43:17PM -0500, Tom Lane wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: > > Unless I'm missing something, pg_dump is not allowing selective dump of > > a table where the table name is mixed case. > > You do it like this: > > $ pg_dump -s -t '"DbTranLogRecord"' dtr > > A bit ugly but the conflict between shell and SQL quoting rules > sometimes forces us into compromises :-( > > Perhaps it's worth having an example for this in the pg_dump man page? Please find enclosed a patch which adds this :) Cheers, D -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778AIM: dfetter666 Skype: davidfetter Remember to vote! Index: doc/src/sgml/ref/pg_dump.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v retrieving revision 1.91 diff -c -r1.91 pg_dump.sgml *** doc/src/sgml/ref/pg_dump.sgml 23 Oct 2006 18:10:32 - 1.91 --- doc/src/sgml/ref/pg_dump.sgml 28 Nov 2006 22:50:15 - *** *** 805,810 --- 805,818 +To dump a single table named camelCaseTable: + + + $ pg_dump -t '"camelCaseTable"' mydb > db.sql + + + + To dump all tables whose names start with emp in the detroit schema, except for the table named employee_log: ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] [HACKERS] pg_dump -t broken for mixed case table names in beta3?
David Fetter <[EMAIL PROTECTED]> writes: > On Tue, Nov 28, 2006 at 02:43:17PM -0500, Tom Lane wrote: >> Perhaps it's worth having an example for this in the pg_dump man page? > Please find enclosed a patch which adds this :) Already done, thanks. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend
