e*******o
发帖数: 4654 | 1 昨天和今天在
Southern California Linux Expo SCALE 13x
http://www.mitbbs.com/article_t/Programming/31403901.html
听到的几个比较好的talk。
公司出钱，出时间，我出力写个简报。 同时也在这里发一下。
适合会sql，但没想过db 怎么运行的同学。
俺生物转的马工，听这些talk 觉得很受用。大牛见笑。
Explaining the Postgres Query Optimizer
https://momjian.us/main/writings/pgsql/optimizer.pdf
This explain how the postgresql actually execute the query based the
statistics of table available to it.
the statistics are generated while vacuum demon vacuum table.
The idea is pretty easy to understand, select the best algorithm based on
information available of the data.
I decide to go to the scale 13x after see this talk in the schedule and the
speaker's name. I have a book authored by him.
PostgresSQL 9.4: FlexScalePerfSQL
can not understand the title.
the talk is really about what is new (good) in 9.4. the speaker seems know
everything about postgresql.
He said the slides and the code will be in the web soon.
I saw percentile_disc in his demo and find
http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-hig
http://www.postgresql.org/docs/9.4/static/functions-aggregate.h
If they have them in 9.2, I would not spend time write the percentile
function myself.
upgrade to 9.4?
All the Dirt on PostgreSQL's VACUUM
I did know vacuum demon exists before.
basically, when you delete some rows from a table. the rows only marked for
deletion. vacuum do the real job.
also, vacuum will update the table statistics when it detect significant
change in table.
Be Very Afraid: Backup Planning and Disaster Recovery
http://thebuild.com/presentations/backups-pgconfeu-2014.pdf
currently, I am not worry about this. I always reset db when I thought I
have db problem. :)
Fun with Functions, by Example
http://www.joeconway.com/presentations/SCALE13X-fun_with_functi
The speaker talk too much details, not very fun. The sides is very good and
very useful.
all of them are new to me except the one about how to write function.
there are other talks about pgpool, postgtres-XL, but less interesting to me
. |
p*****2
发帖数: 21240 | 2 这东西很烂吧
【在 e*******o 的大作中提到】
: 昨天和今天在
: Southern California Linux Expo SCALE 13x
: http://www.mitbbs.com/article_t/Programming/31403901.html
: 听到的几个比较好的talk。
: 公司出钱，出时间，我出力写个简报。 同时也在这里发一下。
: 适合会sql，但没想过db 怎么运行的同学。
: 俺生物转的马工，听这些talk 觉得很受用。大牛见笑。
: Explaining the Postgres Query Optimizer
: https://momjian.us/main/writings/pgsql/optimizer.pdf
: This explain how the postgresql actually execute the query based the
|
H******7
发帖数: 1728 | 3 postgre不错。
可能二爷没用过，业界最受好评的sql数据库。
【在 p*****2 的大作中提到】
: 这东西很烂吧
|
n******n
发帖数: 12088 | 4 谁的好评？数据在哪里？
【在 H******7 的大作中提到】
: postgre不错。
: 可能二爷没用过，业界最受好评的sql数据库。
|
e*******o
发帖数: 4654 | 5 没比较过 公司用 我就学
MongoDB也用
不过 mongo 经常crash 那才叫烂
【在 p*****2 的大作中提到】
: 这东西很烂吧
|
w****k
发帖数: 6244 | 6 Open source的sql数据库，就mysql和postgres像样。
【在 n******n 的大作中提到】
: 谁的好评？数据在哪里？
|
B*****g
发帖数: 34098 | 7 发错群了
【在 e*******o 的大作中提到】
: 昨天和今天在
: Southern California Linux Expo SCALE 13x
: http://www.mitbbs.com/article_t/Programming/31403901.html
: 听到的几个比较好的talk。
: 公司出钱，出时间，我出力写个简报。 同时也在这里发一下。
: 适合会sql，但没想过db 怎么运行的同学。
: 俺生物转的马工，听这些talk 觉得很受用。大牛见笑。
: Explaining the Postgres Query Optimizer
: https://momjian.us/main/writings/pgsql/optimizer.pdf
: This explain how the postgresql actually execute the query based the
|
B*****g
发帖数: 34098 | 8 zkss怎样crash？
【在 e*******o 的大作中提到】
: 没比较过 公司用 我就学
: MongoDB也用
: 不过 mongo 经常crash 那才叫烂
|
r***y
发帖数: 4379 | 9 微信泡多了
【在 B*****g 的大作中提到】
: 发错群了
|
