Re: [GENERAL] Maximum number of tables

2011-03-16 Thread Dmitriy Igrishin
Hey Manos, 2011/3/16 Manos Karpathiotakis > Let me explain a few things about our dataset. We are using a system named > Sesame [1] that stores and queries RDF data. In our case, it uses Postgres > as a relational backend. In RDF, data are triples. Here is an example of an > RDF triple: > > ex:P

Re: [GENERAL] Maximum number of tables

2011-03-16 Thread Manos Karpathiotakis
Let me explain a few things about our dataset. We are using a system named Sesame [1] that stores and queries RDF data. In our case, it uses Postgres as a relational backend. In RDF, data are triples. Here is an example of an RDF triple: ex:Postgres rdf:type ex:RDBMS Triples are stored in Postgre

Re: [GENERAL] Maximum number of tables

2011-03-15 Thread Tom Lane
Manos Karpathiotakis writes: > Hi all, > I am using postgres 9.0 under CentOS 5.5 (Dual Xeon Quad Core @ 2,44 GHz, > 64GB RAM, 2TB RAID 5). In my case, postgres is used as a backend for the RDF > store Sesame. > I am trying to store a dataset that consists of approximately 900.000.000 > insertions

[GENERAL] Maximum number of tables

2011-03-15 Thread Manos Karpathiotakis
Hi all, I am using postgres 9.0 under CentOS 5.5 (Dual Xeon Quad Core @ 2,44 GHz, 64GB RAM, 2TB RAID 5). In my case, postgres is used as a backend for the RDF store Sesame. I am trying to store a dataset that consists of approximately 900.000.000 insertions (organized in either 10 tables, or in an

Re: [GENERAL] Maximum number of tables per database and slowness

2005-12-10 Thread Tom Lane
William Yu <[EMAIL PROTECTED]> writes: > Benjamin Arai wrote: >> What is the current maximum number of tables per database? Also, does >> having more tables slow down performance in any way? > For most cases, the answer is no. However, once you get near 6 figure > table counts, pg_catalog ends

Re: [GENERAL] Maximum number of tables per database and slowness

2005-12-10 Thread William Yu
Benjamin Arai wrote: What is the current maximum number of tables per database? Also, does having more tables slow down performance in any way? For most cases, the answer is no. However, once you get near 6 figure table counts, pg_catalog ends up being pretty massive. The problem is that the

[GENERAL] Maximum number of tables per database and slowness

2005-12-10 Thread Benjamin Arai
What is the current maximum number of tables per database? Also, does having more tables slow down performance in any way? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster