Skip site navigation (1) Skip section navigation (2)

Re: Are 50 million rows a problem for postgres ?

From: Christopher Smith <christopherl_smith(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Are 50 million rows a problem for postgres ?
Date: 2003-09-20 14:12:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I have a US zip code look-up table that includes all zip codes within a 300 mile radius.
DATE_PORTAL=# select count(origin) from zips_300 ;
(1 row)

The row count is shown above. I get great , great performance. However with large data sets, you need a lot of space for indexes.  In my production system, I moved the indexes to another disk.  
Postgresql can handle 50 million rows with no problem, just index the data properly.

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

pgsql-admin by date

Next:From: Tom LaneDate: 2003-09-20 16:02:20
Subject: Re: Error with functions
Previous:From: shyamperiDate: 2003-09-20 11:16:28
Subject: Re: Error with functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group