Re: Recommended Training and Books for PostgreSql

I've tested postgres partitioning....it comes to conclusion that it will perform well up to 1024 partitions per table.

I;ve tested more than 23k partitions per table, simple select with pk was very slow.

On Fri, Aug 19, 2016 at 8:58 PM, Igor Neyman <igor.neyman_at_gmail.com> wrote:

>
> Partitioning: not as rich as in Oracle (you're right, there is no global
> indexes), but it serves the purpose of the applications I'm using it with.
> There are many contributors: individuals and companies, other than
> EnterpriseDB, besides community version is being used much wider than
> EnterpriseDB.
> All-in-all, PG has its place and usage, not "every nail needs a huge
> hammer" like Oracle.
>
> Igor N.
>
>
>
>

-- 
regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab

--
http://www.freelists.org/webpage/oracle-l