X-Original-To: pgsql-performance@postgresql.org Received: from sccrmhc02.attbi.com (sccrmhc02.attbi.com [204.127.202.62]) by postgresql.org (Postfix) with ESMTP id 8314E475461 for ; Mon, 17 Mar 2003 18:14:51 -0500 (EST) Received: from ladamski (12-236-241-34.client.attbi.com[12.236.241.34]) by sccrmhc02.attbi.com (sccrmhc02) with SMTP id <2003031723145300200rpt5le>; Mon, 17 Mar 2003 23:14:53 +0000 From: "Lucas Adamski" To: "'Kendrick C. Wilson'" , Subject: Re: postgresql meltdown on PlanetMath.org Date: Mon, 17 Mar 2003 15:15:04 -0800 Message-ID: <000e01c2ecdb$0bafd1a0$0200a8c0@LADAMSKI> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300 In-Reply-To: X-Archive-Number: 200303/127 X-Sequence-Number: 1425 Or at least restrict TCP/IP connections from localhost only, and use SSH tunnels if you must have direct external access (for pgAdmin, etc.) to the DB. Lucas. -----Original Message----- From: Kendrick C. Wilson [mailto:kendrick_wilson@hotmail.com] Sent: Monday, March 17, 2003 2:47 PM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] postgresql meltdown on PlanetMath.org What is the structure of you table? Is the data types in the table the same as in the SQL.... Did you create the index after the loading the table? cluster the table around the most used index.... Is you web site on the same box you database is on? telnet www.planetmath.org 5432 oh, $hit... never mind........ If you have another box, please put the database on it. The web server maybe killing the database but this depends on the amount of traffic. and block the port......... How fast is you hard drive? 5400rpm :S, k=n^r/ck, SCJP _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html