Thread: 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
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@sympatico.ca>
To: pgsql-sql@postgresql.org
Sent: Tuesday, January 16, 2007 2:30:31 PM
Subject: Re: [SQL] Droping indexes
From: Frank Bax <fbax@sympatico.ca>
To: pgsql-sql@postgresql.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
>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
Don't be flakey. Get Yahoo! Mail for Mobile and
always stay connected to friends.