Difference between Netezza and Postgres database

Posted on 2005-05-17
Last Modified: 2011-04-14

This is just a query, Is the Postgres Database is same as Netezza database ?
Does both works equally in Linux ? Are there any significant difference between these two which differentiate them ?

It would be great if some one can answer this query.
Thanks in advance
Question by:kumarv2
    LVL 4

    Expert Comment

    It's firs time I ever heard of them...and at I havent found ANY info about their database :)

    LVL 4

    Expert Comment

    I found their product brochure, but there's very little technical info... They claim to be faster && better than any other RDBMS, but who doesn't?

    LVL 22

    Accepted Solution

    You tell us !

    PostgreSQL is probably better value because it is Open Source Software.  All testbenches are not equal.


    Author Comment

    Netezza, is very fast and is capable of holding very big database, But the way query run in netezza (syntax) i found it quite similar to Postgres. Netezza, as far i know, is not an open source.
    I believe there are difference between postgrs and netezza but not sure in what sense. That's why i asked question.
    LVL 1

    Expert Comment

    From what I've heard from Netezza (I'm currently doing a vendor analysis on EDW vendors) is that they are a EDW appliance vendor. They sell a propietary hardware/software package for extremely fast analytics(24Tb/hr table scan rate) and complex queries. Netezza uses its own software to run the appliance because primarily becase it utilizes a FPGA that sits between the RAM and HDD to filter data before it gets to the CPU. From what I understand, you can still write SQL as you would Postgres and run any data model as well(star, snowflake, 3rd normal).

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Best database to use for Maps is PostgreSQL. This is an open source database. Comes as a package with most Linux OS. For more info visit the following site: ( This requires some add-o…
    Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
    Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now