Thread: 90 million rows in one table...
Hi We're writing an application which is going to create a table with around 90 million rows... Has anyone done something like this with PostgreSQL? Will the DB run, or will it choke.. In addition, what kind of effect does turning multi-byte support have on database stability and speed? Any repercussions at all? Thanks in advance! --Arsalan ------------------------------------------------- WAR IS PEACE FREEDOM IS SLAVERY IGNORANCE IS STRENGTH
On Thursday 20 September 2001 17:35, you wrote: > Hi > > We're writing an application which is going to create a table with around > 90 million rows... > > Has anyone done something like this with PostgreSQL? Will the DB run, or > will it choke.. > > > In addition, what kind of effect does turning multi-byte support have on > database stability and speed? Any repercussions at all? Why don't you just try? Create a dummy data base, dummy table and fill it with dummy data to get some real life timings on your own hardware. Wouldn't take more than one afternoon to do a little bit of testing Horst
Arsalan Zaidi wrote: > Hi > > We're writing an application which is going to create a table with around 90 > million rows... > > Has anyone done something like this with PostgreSQL? Will the DB run, or > will it choke.. For what it is worth, I am runnig very happily with >20M rows. Allan.
Allan Engelhardt wrote: > > Arsalan Zaidi wrote: > > > Hi > > > > We're writing an application which is going to create a table with around 90 > > million rows... > > > > Has anyone done something like this with PostgreSQL? Will the DB run, or > > will it choke.. > > For what it is worth, I am runnig very happily with >20M rows. so am I -- Mathieu Arnold