Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Implement table partitioning

git.postgresql.org

Post reply on HN
Print view View original

1–10 of 60 posts

Re: Implement table partitioning

#3

Post by aidos »

rachbelaid wrote: post #2

The conversation on the patches are really interesting: https://www.postgresql.org/message-id/flat/55D3093C.5010800@... https://www.postgresql.org/message-id/flat/ad16e2f5-fc7c-cc2...

I'm always amazed by the PG community - it seems like such a constructive place.

Those patches are absolutely insane. Makes you remember how much hard work goes into building the software you use on a day to day basis.

https://www.postgresql.org/message-id/attachment/45478/0001-...

Re: Implement table partitioning

#5

Post by MarHoff »

aidos wrote: post #3
rachbelaid wrote: post #2

The conversation on the patches are really interesting: https://www.postgresql.org/message-id/flat/55D3093C.5010800@... https://www.postgresql.org/message-id/flat/ad16e2f5-fc7c-cc2...

I'm always amazed by the PG community - it seems like such a constructive place. Those patches are absolutely insane. Makes you remember how much hard work goes into building the software you use on a day to day basis. https://www.postgresql.org/message-id/attachment/45478/0001-...

I've been professionally focused on PostgreSQL based works for the last 5 years. At the highest point of the BigData hype I sometimes felt a little bit off-track, because I never got the time to investigate NoSQL solutions...

Only recently did I realize that being focused on actual data and how to process it inside PostgreSQL was maybe the best way I could spend my working time. I really can't say what's the best part of PostgreSQL, the hyperactive community, the rock solid and clear documentation or the constant roll-out of efficient, non-disruptive, user-focused features...

Re: Implement table partitioning

#6

Post by reactor »

aidos wrote: post #3
rachbelaid wrote: post #2

The conversation on the patches are really interesting: https://www.postgresql.org/message-id/flat/55D3093C.5010800@... https://www.postgresql.org/message-id/flat/ad16e2f5-fc7c-cc2...

I'm always amazed by the PG community - it seems like such a constructive place. Those patches are absolutely insane. Makes you remember how much hard work goes into building the software you use on a day to day basis. https://www.postgresql.org/message-id/attachment/45478/0001-...

I could see good amount of quality engineering there, kudos.

Re: Implement table partitioning

#8

Post by fabian2k »

ktopaz wrote: post #7

I don't get it? Table partition is already supported in PostgreSQL now and has been for a long time now (at least since 8.1); Where I work we utilize table partitioning with PostgreSQL 9.4 on the product we're developing. https://www.postgresql.org/docs/current/static/ddl-partition...

As far as I understand, this is about declarative partioning. So you don't have to implement all the details yourself anymore, you just declare how a table should be partioned instead of defining tables, triggers, ...

Re: Implement table partitioning

#9

Post by vemv »

While seemingly extensive, I don't quite like the commit message.

I doesn't say what TP is, and what its use cases would be. That's the first thing you should say, else how am I going to understand / keep interest in the rest of the text?

Re: Implement table partitioning

#10

Post by SideburnsOfDoom »

egeozcan wrote: post #4

If you also didn't know what exactly partitioned tables are, here's a nice introduction from Microsoft: https://technet.microsoft.com/en-us/library/ms190787(v=sql.1... It is for the SQL server but I assume it would be mostly relevant. Please correct me if I'm wrong.

So this is all about partitioning data into different storage files on the same server? What is the main benefit of that?
Post reply on HN