Re: Droping indexes RESOLVED

Hi all,

Thank you very much for your help.

I've found a create.sql script among the millions of files from openNMS installation that has all SQL statements for creating all tables, constraints, indexes and such. :-)

I've just executed a drop table at the guilty table (32GB in size...), recreated it along with all constraints and indexes............and everything is fine now !!

Thank a lot for your support.

All the best,

Mario Behring

----- Original Message ----
From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Sent: Tuesday, January 16, 2007 2:30:31 PM
Subject: Re: [SQL] Droping indexes

At 11:27 AM 1/16/07, Frank Bax wrote:
>At 10:42 AM 1/16/07, Mario Behring wrote:
>>Thank you for your advise..............I was thinking about doing exactly
>>that, I wasn't sure on how to do it though, meaning, considering the info
>>below, how should I use the CREATE INDEX command to create these indexes??
>
>
>This might provide a clue:
>
>pg_dump -t events | grep ^CREATE

Sorry, perhaps this would be better

pg_dump -s -t events | grep ^CREATE

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

____________________________________________________________________________________
8:00? 8:25? 8:40? Find a flick in no time
with the Yahoo! Search movie showtime shortcut.
http://tools.search.yahoo.com/shortcuts/#news