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
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 in
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:
On Tue, 2007-01-16 at 07:51, Mario Behring wrote:
> Hi all,
>
> Please, if I drop all indexes from a table, can I recreate them after
> performing a vacuum full at this table? I mean, I do not know details
> about the indexes, so what I am asking is if I issue a REINDEX on this
> table, will it c
Mario Behring wrote:
Hi Alvaro,
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??
Have you read the documentation?
htt
uei)
Restrictions of foreing key:
"fk_nodeid6" FOREIGN KEY (nodeid) REFERENCES node(nodeid) ON DELETE CASCADE
Thank you.
Best regards,
Mario Behring
- Original Message
From: Alvaro Herrera <[EMAIL PROTECTED]>
To: Mario Behring <[EMAIL PROTECTED]>
Cc: Toma
Mario Behring wrote:
> Hi Tomas,
>
> Thank you.
>
> Please help me here.I am not a database guy...how do I use this
> CLUSTER command and what does it do? Please keep in mind that I do not have
> disk space left.
If the disk is full you cannot use CLUSTER anyway. Suggestio
t; btree (eventuei)
Restrictions of foreing key:
"fk_nodeid6" FOREIGN KEY (nodeid) REFERENCES node(nodeid) ON DELETE CASCADE
Thanks.
Mario Behring
- Original Message
From: Tomas Vondra <[EMAIL PROTECTED]>
To: Mario Behring <[EMAIL PROTECTED]>
Sent: Tuesd
Hi all,
Please, if I drop all indexes from a table, can I recreate them after
performing a vacuum full at this table? I mean, I do not know details about the
indexes, so what I am asking is if I issue a REINDEX on this table, will it
create the proper indexes again?
Please advise.
Thanks in
