Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id F3DA59FB1CD
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 16 Jan 2007 12:57:44 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 34980-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 16 Jan 2007 12:57:29 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web30008.mail.mud.yahoo.com (web30008.mail.mud.yahoo.com
	[209.191.69.25]) by postgresql.org (Postfix) with SMTP id C6C5B9FB1BA
	for <pgsql-sql@postgresql.org>; Tue, 16 Jan 2007 12:57:29 -0400 (AST)
Received: (qmail 74166 invoked by uid 60001); 16 Jan 2007 16:57:28 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID;
	b=qYc71OcJWXBk87JEhjT1Dfysw4wdFxXOx8XNd9AE66YOuDdZY0H0tGQUg1AJTSmYSOQRgS1Oz2bdXbmUdNNsZt62TQc+Qm4EdyaQzry7NaIvmG0TU426BLGhIeAhuyOzA6brq8BHBhD1Tjj5BBiboqNPFhk+sIXSpKbs4LU0T1Y=;
Received: from [200.161.5.135] by web30008.mail.mud.yahoo.com via HTTP;
	Tue, 16 Jan 2007 08:57:28 PST
X-Mailer: YahooMailRC/368.3 YahooMailWebService/0.6.132.7
Date: Tue, 16 Jan 2007 08:57:28 -0800 (PST)
From: Mario Behring <mariobehring@yahoo.com>
Subject: Re: Droping indexes RESOLVED
To: Frank Bax <fbax@sympatico.ca>
Cc: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-2074107685-1168966648=:72691"
Message-ID: <791260.72691.qm@web30008.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/63
X-Sequence-Number: 27215

--0-2074107685-1168966648=:72691
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all,=0A=0AThank you very much for your help. =0A=0AI've found a create.s=
ql script among the millions of files from openNMS installation that has al=
l SQL statements for creating all tables, constraints, indexes and such.  :=
-)=0A=0AI've just executed a drop table at the guilty table (32GB in size..=
.), recreated it along with all constraints and indexes............and ever=
ything is fine now !!=0A=0AThank a lot for your support.=0A=0AAll the best,=
=0A=0AMario Behring=0A=0A=0A=0A=0A=0A=0A----- Original Message ----=0AFrom:=
 Frank Bax <fbax@sympatico.ca>=0ATo: pgsql-sql@postgresql.org=0ASent: Tuesd=
ay, January 16, 2007 2:30:31 PM=0ASubject: Re: [SQL] Droping indexes=0A=0AA=
t 11:27 AM 1/16/07, Frank Bax wrote:=0A>At 10:42 AM 1/16/07, Mario Behring =
wrote:=0A>>Thank you for your advise..............I was thinking about doin=
g exactly =0A>>that, I wasn't sure on how to do it though, meaning, conside=
ring the info =0A>>below, how should I use the CREATE INDEX command to crea=
te these indexes??=0A>=0A>=0A>This might provide a clue:=0A>=0A>pg_dump -t =
events | grep ^CREATE=0A=0A=0ASorry, perhaps this would be better=0A=0Apg_d=
ump -s -t events | grep ^CREATE =0A=0A=0A---------------------------(end of=
 broadcast)---------------------------=0ATIP 9: In versions below 8.0, the =
planner will ignore your desire to=0A       choose an index scan if your jo=
ining column's datatypes do not=0A       match=0A=0A=0A=0A=0A=0A=0A=0A =0A_=
___________________________________________________________________________=
________=0A8:00? 8:25? 8:40? Find a flick in no time =0Awith the Yahoo! Sea=
rch movie showtime shortcut.=0Ahttp://tools.search.yahoo.com/shortcuts/#new=
s
--0-2074107685-1168966648=:72691
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial,helvetica,sans-serif;font-size:10p=
t"><div style=3D"font-family: arial,helvetica,sans-serif; font-size: 10pt;"=
>Hi all,<br><br>Thank you very much for your help. <br><br>I've found a cre=
ate.sql script among the millions of files from openNMS installation that h=
as all SQL statements for creating all tables, constraints, indexes and suc=
h.&nbsp; :-)<br><br>I've just executed a drop table at the guilty table (32=
GB in size...), recreated it along with all constraints and indexes........=
....and everything is fine now !!<br><br>Thank a lot for your support.<br><=
br>All the best,<br><br>Mario Behring<br><br><br><br><br><br><br><div style=
=3D"font-family: times new roman,new york,times,serif; font-size: 12pt;">--=
--- Original Message ----<br>From: Frank Bax &lt;fbax@sympatico.ca&gt;<br>T=
o: pgsql-sql@postgresql.org<br>Sent: Tuesday, January 16, 2007 2:30:31 PM<b=
r>Subject: Re: [SQL]
 Droping indexes<br><br><div>At 11:27 AM 1/16/07, Frank Bax wrote:<br>&gt;A=
t 10:42 AM 1/16/07, Mario Behring wrote:<br>&gt;&gt;Thank you for your advi=
se..............I was thinking about doing exactly <br>&gt;&gt;that, I wasn=
't sure on how to do it though, meaning, considering the info <br>&gt;&gt;b=
elow, how should I use the CREATE INDEX command to create these indexes??<b=
r>&gt;<br>&gt;<br>&gt;This might provide a clue:<br>&gt;<br>&gt;pg_dump -t =
events | grep ^CREATE<br><br><br>Sorry, perhaps this would be better<br><br=
>pg_dump -s -t events | grep ^CREATE <br><br><br>--------------------------=
-(end of broadcast)---------------------------<br>TIP 9: In versions below =
8.0, the planner will ignore your desire to<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp; choose an index scan if your joining column's datatypes do not<br>=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; match<br></div></div><br></div></div><=
br>=0A=0A<hr size=3D1>Don't be flakey. <a href=3D"http://us.rd.yahoo.com/ev=
t=3D43909/*http://mobile.yahoo.com/mail">Get Yahoo! Mail for Mobile</a> and=
 <br><a href=3D"http://us.rd.yahoo.com/evt=3D43909/*http://mobile.yahoo.com=
/mail">always stay connected</a> to friends.</body></html>
--0-2074107685-1168966648=:72691--