Received: from smtp-2.ig.com.br (smtp-2.ig.com.br [200.225.157.61] (may be forged)) by postgresql.org (8.11.3/8.11.1) with SMTP id f34MFm806586 for ; Wed, 4 Apr 2001 18:15:48 -0400 (EDT) (envelope-from edipoelder@ig.com.br) Message-Id: <200104042215.f34MFm806586@postgresql.org> Received: (qmail 9098 invoked from network); 4 Apr 2001 22:15:45 -0000 Received: from webmail-9.ig.com.br (HELO localhost) (200.225.157.214) by smtp-2.ig.com.br with SMTP; 4 Apr 2001 22:15:45 -0000 Date: Wed, 4 Apr 2001 19:15:44 -0300 To: pgsql-sql@postgresql.org From: Edipo Elder Fernandes de Melo Cc: X-Originating-IP: [200.19.161.175] X-Mailer: InMail by Insite - www.insite.com.br X-user: edipoelder@ig.com.br Subject: Re: Memory and performance X-Archive-Number: 200104/64 X-Sequence-Number: 2403 Em 05 Apr 2001, Cedar Cox escreveu: >To this I say, remember that you are using a database! I would split this >into 3 tables (people, exams, answers). Then only the 'answers' table >would contain 3M records. Should be a bit faster. You don't want to have >to store the and with each . > >(If this is what you are doing then ignore me. I don't take you for an >idiot :) Yeah... I'm doing this... (I'm not a idiot! :)))) I'm just asking if exist any way to optimize PostgreSQL to handle a great quantity of tuples. (I will try the 7.1. By the way... in the URI http://www.postgresql.org/ftpsite/dev/ we found a RC2 version, but in the URI ftp://ftp.postgresql.org/pub/dev/ don't!) Hugs, Edipo Elder [edipoelder@ig.com.br] _________________________________________________________ Oi! Você quer um iG-mail gratuito? Então clique aqui: http://www.ig.com.br/paginas/assineigmail.html