pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Large database 2+ messages / 2 participants [nested] [flat]
* Large database @ 2004-06-04 17:02 todhunter <todhunter@interia.pl> 0 siblings, 1 reply; 2+ messages in thread From: todhunter @ 2004-06-04 17:02 UTC (permalink / raw) To: pgsql-admin I'm considering using Postgresql for an application which could very likely require a database to grow up to about 200 000 000 records in one table. 1. Is this possible with Postresql on Linux? 2. What's the biggest known database currently running on Postgresql? Thanks for your help! ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Large database @ 2004-06-06 20:39 Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk> parent: todhunter <todhunter@interia.pl> 0 siblings, 0 replies; 2+ messages in thread From: Sam Barnett-Cormack @ 2004-06-06 20:39 UTC (permalink / raw) To: todhunter <todhunter@interia.pl>; +Cc: pgsql-admin On Fri, 4 Jun 2004, todhunter wrote: > I'm considering using Postgresql for an application which could very > likely require a database to grow up to about 200 000 000 records in > one table. > > 1. Is this possible with Postresql on Linux? Given that there are no theoretical limits of table length (IIRC), then yes. Performance may suffer. > 2. What's the biggest known database currently running on Postgresql? Well, UKMS is running a database that has a table with one record for every file or page served to any user. It's pretty big, at least of the order you describe. The size on disk of the database is 167GiB. It runs just fine, and that's on linux on intel hardware. -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-06-06 20:39 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-06-04 17:02 Large database todhunter <todhunter@interia.pl> 2004-06-06 20:39 ` Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox