Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Modern R Programming Cookbook

You're reading from   Modern R Programming Cookbook Recipes to simplify your statistical applications

Arrow left icon
Product type Paperback
Published in Oct 2017
Publisher Packt
ISBN-13 9781787129054
Length 236 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Jaynal Abedin Jaynal Abedin
Author Profile Icon Jaynal Abedin
Jaynal Abedin
Arrow right icon
View More author details
Toc

Table of Contents (10) Chapters Close

Preface 1. Installing and Configuring R and its Libraries 2. Data Structures in R FREE CHAPTER 3. Writing Customized Functions 4. Conditional and Iterative Operations 5. R Objects and Classes 6. Querying, Filtering, and Summarizing 7. R for Text Processing 8. R and Databases 9. Parallel Processing in R

Installing the PostgreSQL database server

PostgreSQL is one of the most powerful database management systems, and is publicly available, and free of cost. This open source database management software runs on every platform, including Windows, Linux, and macOS. Using this database management system, you will be able to store and process very large data. The following table will give you an understanding of how large data can be handled using the PostgreSQL database:

Limit

Value

Maximum database size

Unlimited

Maximum table size

32 TB

Maximum row size

1.6 TB

Maximum field size

1 GB

Maximum row per table

Unlimited

Maximum columns per table

250-1,600 depending on column types

Maximum indexes per table

Unlimited

Capacity of PostgreSQL database (source: https://www.postgresql.org/about/)

In this recipe, you will download and install...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image