View stunning SlideShares in full-screen with the new iOS app!Introducing SlideShare for AndroidExplore all your favorite topics in the SlideShare appGet the SlideShare app to Save for Later — even offline
View stunning SlideShares in full-screen with the new Android app!View stunning SlideShares in full-screen with the new iOS app!
21.
Copyright 2013 Metro Systems. 21
パッチレビュー(4)
●
レビューしたいけど環境がない！
– レビューワーはVMが無料で借りられます！
As part of an ongoing effort to encourage patch review for the
PostgreSQL project, we will be funding cloud servers for patch reviewers
and testers who need them for CommitFests. That is, if you want to help
with reviewing or testing a patch for a CommitFest, and don't have your
own test server to use, the PostgreSQL project (via our funds at
Software In the Public Interest) will pay for you to use a cloud server
for the duration of your review/testing.
So, if "I don't have anywhere to test it" was your excuse for not
reviewing in the past, time to stop making excuses and start reviewing!
Since these are cloud servers, they won't work well for performance
testing. However, they will be excellent for testing replication.
If you need one of these, please contact me to allocate a VM for you.
2013-07-13 Josh Berkus氏のメールより
36.
Copyright 2013 Metro Systems. 36
改造してみましょう(2)
●
デバッグ時のTips
– elog()でのprintfデバッグ
●
プロトタイプ：elog(level, fmt, ...)
●
例：
int
func(int param)
{
int foo;
elog(WARNING, "%s() called with %d", __FUNCTION__, param);
...
elog(WARNING, "foo = %d before xxx", foo);
exec_xxx(...);
elog(WARNING, "foo = %d after xxx", foo);
...
}
37.
Copyright 2013 Metro Systems. 37
改造してみましょう(3)
●
デバッグ時のTips
– elog()でのprintfデバッグ
●
プロトタイプ：elog(level, fmt, ...)
●
例：
int
func(int param)
{
int foo;
elog(WARNING, "%s() called with %d", __FUNCTION__, param);
...
elog(WARNING, "foo = %d before xxx", foo);
exec_xxx(...);
elog(WARNING, "foo = %d after xxx", foo);
...
}
38.
Copyright 2013 Metro Systems. 38
改造してみましょう(4)
●
デバッグ時のTips
– NodeTag
●
NodeTagオブジェクト種別識別子
●
構造体の先頭にNodeTagを置き、その値でオブジェク
ト種別を識別
/*
* The first field of a node of any type is guaranteed to be the NodeTag.
* Hence the type of any node can be gotten by casting it to Node. Declaring
* a variable to be of Node * (instead of void *) can also facilitate
* debugging.
*/
typedef struct Node
{
NodeTag type;
} Node;
39.
Copyright 2013 Metro Systems. 39
改造してみましょう(5)
– NodeTag（続き）
typedef struct JoinExpr
{
NodeTag type;
JoinType jointype; /* type of join */
bool isNatural; /* Natural join? Will need to shape table */
Node *larg; /* left subtree */
Node *rarg; /* right subtree */
List *usingClause; /* USING clause, if any (list of String) */
Node *quals; /* qualifiers on join, if any */
Alias *alias; /* user-written alias clause, if any */
int rtindex; /* RT index assigned for join, or 0 */
} JoinExpr;
![[A22] SE(SE One)をもっと有効活用しよう(db tech...](http://cdn.slidesharecdn.com/ss_thumbnails/seseone-140625000744-phpapp02-thumbnail.jpg?cb=1404086246)
![[D14] MySQL 5.6時代のパフォーマンスチューニング *db...](http://cdn.slidesharecdn.com/ss_thumbnails/20131110tuningonmysql5-131117180858-phpapp02-thumbnail.jpg?cb=1405950519)
Views
Actions
Embeds 0
Report content