Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL

2004-05-06 Thread Richard Huxton
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, RedShe

Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL

2004-05-06 Thread Shridhar Daithankar
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

Re: [pgsql-advocacy] [PERFORM] MySQL vs PG TPC-H benchmarks

2004-05-06 Thread Grega Bremec
...and on Thu, Apr 22, 2004 at 06:59:10AM -0700, Eduardo Almeida used the keyboard: > > To reference, Sun has java 64bits just to IA64 and > Solaris Sparc 64 not to Opteron. > As I mentioned, that is true for the 1.4.x release of the JVMs. We have been testing some JCA builds of 1.5.0 on x86_64

Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the

2004-05-06 Thread Don Vaillancourt
Here's a question a little off-topic. What would a 32TB database hardware configuration look like.  I'm assuming 200GB hard-drives which would total 160 of them.  Double that if you mirror them. Am I correct? At 04:13 AM 06/05/2004, you wrote: Christopher Kings-Lynne wrote: What's the case of bi

Re: [PERFORM] pg_stat

2004-05-06 Thread Litao Wu
All, Since I have not seen any follow up post, I am wondering if my question is not clear or what. Anyway, my postgres version is 7.3.2, and I want to know: 1. How to determine if some of indexes are used by any queries, like Oracle's: alter index my_index monitoring usage 2. The relationship bet

Re: [PERFORM] INSERT RULE

2004-05-06 Thread Richard Huxton
Pailloncy Jean-Gérard wrote: I try to do: CREATE RULE ndicti AS ON INSERT TO ndict DO INSTEAD INSERT INTO 'ndict_' || (NEW.word_id & 255) VALUES( NEW.url_id, NEW.word_id, NEW.intag); I got an error on 'ndict_' . I did not found the right syntax. In fact I discover that SELECT * FROM / INSER

Re: [pgsql-advocacy] [PERFORM] [OFF-TOPIC] - Known maximum size of

2004-05-06 Thread Gavin Sherry
On Thu, 6 May 2004, Shridhar Daithankar wrote: > 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