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: 20030920141208.20848.qmail@web14104.mail.yahoo.com (view raw or flat)
Thread:
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 ;
   count   
-----------
 201021979
(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-2014 The PostgreSQL Global Development Group