SKU: 11624925007

PostgreSQL: Up and Running

Sale price$191.25 Regular price$212.50
Save 10%

Pay in installments of $53.12 with ShopPay, AfterPay and Klarna

Shipping Estimate
USA
  • USA
  • CAN

Ships within 48 hours · Estimated delivery Aug 16 - Aug 21

Promo Codes Available:

For Your Every Summer RSVP, with Code: SUMMER15

Description

PostgreSQL: Up and RunningIf youre thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQLs unique features. Not only will you learn about the enterprise class features in the 9. 2 release, youll also discover that PostgeSQL is more than just a database systemits also an impressive application platform."color: rgb(8, 113, 135); font family: Verdana; font size: 11px; text

If youre thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQLs unique features. Not only will you learn about the enterprise class features in the 9.2 release, youll also discover that PostgeSQL is more than just a database systemits also an impressive application platform."color: rgb(8, 113, 135); font-family: Verdana; font-size: 11px; text-align: justify;"With numerous examples throughout this book, youll learn how to achieve tasks that are difficult or impossible in other databases. If youre an existing PostgreSQL user, youll pick up gems you may have missed along the way.
Learn basic administration tasks, such as role management, database creation, backup, and restore
Apply the psql command-line utility and the pgAdmin graphical administration tool
Explore PostgreSQL tables, constraints, and indexes
Learn powerful SQL constructs not generally found in other databases
Use several different languages to write database functions
Tune your queries to run as fast as your hardware will allow
Query external and variegated data sources with Foreign Data Wrappers
Learn how to replicate data, using built-in replication features
Chapter 1 The Basics
Where to Get PostgreSQL
Administration Tools
Whats New in Latest Versions of PostgreSQL?
Database Drivers
Server and Database Objects
Where to Get Help
Chapter 2 Database Administration
Configuration Files
Setting Up Groups and Login Roles (Users)
Databases and Management
Extensions and Contribs
Backup
Restore
Managing Disk Space with Tablespaces
Verboten
Chapter 3 psql
Interactive psql
Non-Interactive psql
Session Configurations
psql Gems
Importing and Exporting Data
Basic Reporting
Chapter 4 Using pgAdmin
Getting Started
pgAdmin Features
pgScript
Graphical Explain
Job Scheduling with pgAgent
Chapter 5 Data Types
Numeric Data Types
Arrays
Character Types
Temporal Data Types
XML
Custom and Composite Data Types
Chapter 6 Of Tables, Constraints, and Indexes
Tables
Constraints
Indexes
Chapter 7 SQL: The PostgreSQL Way
SQL Views
Window Functions
Common Table Expressions
Constructions Unique to PostgreSQL
Chapter 8 Writing Functions
Anatomy of PostgreSQL Functions
Writing Functions with SQL
Writing PL/pgSQL Functions
Writing PL/Python Functions
Trigger Functions
Aggregates
Chapter 9 Query Performance Tuning
EXPLAIN and EXPLAIN ANALYZE
Writing Better Queries
Guiding the Query Planner
Caching
Chapter 10 Replication and External Data
Replication Overview
Setting Up Replication
Foreign Data Wrappers (FDW)
Appendix Install, Hosting, and Command-Line Guides
Installation Guides and Distributions
Where to Host PostgreSQL
PostgreSQL Packaged Command-Line Tools

Shipping Notes
  • Free Standard Shipping on $100+ Orders to the USA.
  • Except Preorder products are shipped in 48 hours.
  • Delivery to the USA:
  1. Standard Shipping : 3-10 business days
  • If time is of the essence, please consider selecting expedited delivery for faster service.
Exchange/Return Notes
  • We offer a 30-day return/exchange service after receiving.
  • Final sale items are not eligible for returns or exchanges.
  • To process your return/exchange, please contact us at [email protected]
  • Please click here for more details>>> Return & Exchange Policy
SKU: 11624925007

Discover Niche Categories That Outsell

Top-Converting Item to Boost Your Average Order

4.8 ★★★★★
Based on 12 reviews
Sort
Highest Rating
Newest First
Oldest First
Product Reviews
N
Verified Purchase
Nikki
Waukegan, US
★★★★★ 5
Comfortable all night
Size: Queen, Color: White
So cozy! The cooling effect is nice. The pillow case is super soft and my favorite part. Made well. I personally wish it was just a little thicker, but overall recommend it!
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on May 13, 2026
T
Verified Purchase
Tara
Phoenix, US
★★★★★ 5
Love it
Size: Queen, Color: White
This is such a nice pillow protector. It is super soft, the zipper works great, it has a decent weight to it, and definitely keeps the pillow cooler. I’m very impressed.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on April 14, 2026
J
Verified Purchase
Julie Lopp
Los Angeles, US
★★★★★ 5
Great product! I love the feel of these.
Size: Queen, Color: White
“I recently purchased the Serta Power Chill Cooling Pillow Protectors, and they have been a game-changer for my sleep comfort. These pillow protectors have exceeded my expectations in several ways. First and foremost, the cooling technology is fantastic. I tend to sleep hot, especially during the summer months, and these pillow protectors have made a noticeable difference. They keep my pillows cool and comfortable throughout the night, which has led to more restful and uninterrupted sleep. The fit is also excellent. They easily slip over my standard-sized pillows and stay securely in place without any annoying bunching, wrinkles or slipping during the night. And the zipper is amazing. Having no wrinkles in my cover is easier on my hair. What’s great about these protectors is that they not only keep my pillows cool but also protect them from spills, stains, and allergens. It gives me peace of mind knowing that my pillows are safeguarded while I enjoy a cool and refreshing sleep environment. There is no noise when sleeping on this cover, it’s soft. Cleaning is a breeze. They are machine-washable and maintain their cooling properties even after multiple washes. The quality of the materials used is evident. These protectors feel durable and well-made, promising long-lasting use. While they are slightly more expensive than basic pillow protectors, the added cooling benefits and protection they offer are well worth the investment. They’ve made a significant difference in my sleep quality, and I highly recommend the Serta Power Chill Cooling Pillow Protectors to anyone seeking a cooler and more comfortable night’s sleep.”
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on October 6, 2023
B
Verified Purchase
Birdie
Los Angeles, US
★★★★★ 4
Loose on standard pillow.
Size: Queen, Color: White
Too large for standard pillow. It would fit a queen size pillow much better. It does stay cool.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on November 20, 2025
A
Verified Purchase
AmazonSmile
Louisville, US
★★★★★ 5
Soft and cool. Very cool. 🧊
Size: Queen, Color: White
I bought these for my memory foam pillow and they’re excellent for cooling it. I use 2 of these on the pillow for maximum chill factor and it works. They’re very soft, the zippers are high quality. Easy to put on with a bit of stretch- generously sized. They’re stain resistant. I’m glad they’re NOT waterproof because they’d be too hot then. They’re very durable. Wash on delicate setting in a mesh bag and air dry and they last long. They’re very quiet- smooth and silky. Definitely recommend!
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on January 15, 2026

recommand products