Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
Christopher Kings-Lynne wrote: What's the case of bigger database PostgreSQL (so greate and amount of registers) that they know??? Didn't someone say that RedSheriff had a 10TB postgres database or something? From http://www.redsheriff.com/us/news/news_4_201.html According to the company, RedSheriff processes 10 billion records a month and the total amount of data managed is more than 32TB. Griffin said PostgreSQL has been in production for 12 months with not a single database fault in that time The stability of the database can not be questioned. Needless to say, we are extremely happy. I think it's safe to assume this is not on a spare Dell 600SC though. -- Richard Huxton Archonet Ltd ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
Richard Huxton wrote: Christopher Kings-Lynne wrote: What's the case of bigger database PostgreSQL (so greate and amount of registers) that they know??? Didn't someone say that RedSheriff had a 10TB postgres database or something? From http://www.redsheriff.com/us/news/news_4_201.html According to the company, RedSheriff processes 10 billion records a month and the total amount of data managed is more than 32TB. Griffin said PostgreSQL has been in production for 12 months with not a single database fault in that time The stability of the database can not be questioned. Needless to say, we are extremely happy. I think it's safe to assume this is not on a spare Dell 600SC though. I think we should have a case study for that. And publish it on our regular news/press contacts(Can't imagine the flame war on /...Umm Yummy..:-)). It would make a lot of noise and gain visibility for us. Of course Red Sherrif need to co-operate and spell the details and/or moderate what we write, but all in all, 32TB database is uber-cool..:-) Shridhar ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
On Sat, 2004-06-05 at 11:55, Carlos Eduardo Smanioto wrote: What's the case of bigger database PostgreSQL (so greate and amount of registers) that they know??? You might want to fix the month on your system time. With respect to how big PostgreSQL databases can get in practice, these are our two biggest implementations: - 0.5 Tb GIS database (this maybe upwards of 600-700Gb now, I didn't check) - 10 Gb OLTP system with 70 million rows and a typical working set of 2-3 Gb. Postgres is definitely capable of handling large pretty databases with ease. There are some narrow types of workloads that it doesn't do so well on, but for many normal DBMS loads it scales quite well. j. andrew rogers ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
On Sat, 5 Jun 2004, Carlos Eduardo Smanioto wrote: Hello all, What's the case of bigger database PostgreSQL (so greate and amount of registers) that they know??? http://www.postgresql.org/docs/faqs/FAQ.html#4.5 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL
What's the case of bigger database PostgreSQL (so greate and amount of registers) that they know??? Didn't someone say that RedSheriff had a 10TB postgres database or something? Chris ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org