Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5BABC2E0242 for ; Thu, 13 Dec 2007 09:16:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20101-05-3 for ; Thu, 13 Dec 2007 09:16:37 -0400 (AST) Received: from mx2.imatech.net (mx2.imatech.net [81.255.215.243]) by postgresql.org (Postfix) with ESMTP id 060542E00F1 for ; Thu, 13 Dec 2007 09:14:46 -0400 (AST) Received: from mx.imatech.net ([81.255.215.253]:1895) by mx2.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Wed, 12 Dec 2007 13:35:29 +0100 X-AuthUser: olivier.boissard@cerene.fr Received: from [200.200.200.34] ([195.6.193.141]:45855) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Thu, 13 Dec 2007 14:14:36 +0100 Message-ID: <47613061.9000004@cerene.fr> Date: Thu, 13 Dec 2007 14:15:13 +0100 From: olivier boissard User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: "A.Burbello" CC: pgsql-admin@postgresql.org Subject: Re: improve performance in a big table References: <222808.5599.qm@web36215.mail.mud.yahoo.com> In-Reply-To: <222808.5599.qm@web36215.mail.mud.yahoo.com> Content-Type: multipart/mixed; boundary="------------070208070507050309010909" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/85 X-Sequence-Number: 27602 This is a multi-part message in MIME format. --------------070208070507050309010909 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit A.Burbello a écrit : > Hi people, > > I have a case and I got a doubt what should be the > best ways. > > One table has more than 150 million of rows, and I > thought that could divided by state. > For each row has person ID, state and other > informations, but the search would be done only by > person ID (number column). > > I can improve the query by putting index in that > column, but is there any other ways? > > Thank you. > > > > > Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! > http://br.mail.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > Hello I also studies how to improve performances on big tables. Like you , I don't know how to improve without index. It's the only way I found . I find postgresql is fast on small table but I got real performance problem when increases the number of rows Do anyone know if there is specific postgresql tuning parameters in .conf file for big tables ? max_fsm_pages ? max_fsm_relations ? Olivier -- Olivier BOISSARD olivier.boissard@cerene.fr CERENE SERVICES SA 3, rue Archimède 10600 La Chapelle-Saint-Luc - France Tel : 33 (0)3 25 74 11 78 Fax : 33 (0)3 25 78 39 67 ---------------------------- "Ce message peut contenir des informations confidentielles et/ou protégées. Il est à l'usage exclusif de son destinataire. Toute utilisation non autorisée peut être illicite. Si vous recevez ce message par erreur, nous vous remercions d'en aviser immédiatement l'expéditeur en utilisant la fonction réponse de votre gestionnaire de courrier électronique." "This email may contain confidential information and/or copyright material. This email is intended for the use of the addressee only. Any unauthorised use may be unlawful. If you receive this email by mistake, please advise the sender immediately by using the reply facility in your email software." --------------070208070507050309010909 Content-Type: text/x-vcard; charset=utf-8; name="olivier_boissard.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="olivier_boissard.vcf" begin:vcard fn:Olivier Boissard n:Boissard;Olivier org;quoted-printable:CERENE SERVICES;d=C3=A9veloppement adr:;;3 rue archimede;La Chapelle Saint Luc;AUBE;10600;FRANCE email;internet:olivier.boissard@cerene.fr tel;work:+33.3.25.74.11.78 tel;fax:+33.3.25.78.39.67 note;quoted-printable:"Ce message peut contenir des informations confidentielles et/ou=0D=0A= prot=C3=A9g=C3=A9es. Il est =C3=A0 l'usage exclusif de son destinataire.= Toute=0D=0A= utilisation non autoris=C3=A9e peut =C3=AAtre illicite. Si vous recevez= ce=0D=0A= message par erreur, nous vous remercions d'en aviser imm=C3=A9diatement=0D=0A= l'exp=C3=A9diteur en utilisant la fonction r=C3=A9ponse de votre gestionn= aire=0D=0A= de courrier =C3=A9lectronique."=0D=0A= =0D=0A= "This email may contain confidential information and/or copyright=0D=0A= material. This email is intended for the use of the addressee only.=0D=0A= Any unauthorised use may be unlawful. If you receive this email by=0D=0A= mistake, please advise the sender immediately by using the reply=0D=0A= facility in your email software." url:www.cerene.fr version:2.1 end:vcard --------------070208070507050309010909--