Обсуждение: REINDEX VERBOSE DATABASE not working
Hello %
Regarding the Docs
https://www.postgresql.org/docs/11/sql-reindex.html
and due to the REINDEX syntax, I should be able to specify VERBOSE when I run the REINDEX command, to print a progress report.
(postgres@[local]:55000)[knowledgebase]> \h REINDEX
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
But it is not working.
(postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE knowledgebase;
ERROR: syntax error at or near "VERBOSE"
LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
^
Can somebody help me out regarding this issue.
Cheers
William
Disclaimer:
Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Вложения
I forgot to mention the version.
It is PostgreSQL 11.4 on Redhat 7.6
From: Sescu William (SW0)
Sent: Mittwoch, 3. Juli 2019 16:10
To: pgsql-admin@postgresql.org
Subject: REINDEX VERBOSE DATABASE not working [mail signed OK]
Hello %
Regarding the Docs
https://www.postgresql.org/docs/11/sql-reindex.html
and due to the REINDEX syntax, I should be able to specify VERBOSE when I run the REINDEX command, to print a progress report.
(postgres@[local]:55000)[knowledgebase]> \h REINDEX
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
But it is not working.
(postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE knowledgebase;
ERROR: syntax error at or near "VERBOSE"
LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
^
Can somebody help me out regarding this issue.
Cheers
William
Disclaimer:
Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Вложения
Hello %
Regarding the Docs
https://www.postgresql.org/docs/11/sql-reindex.html
and due to the REINDEX syntax, I should be able to specify VERBOSE when I run the REINDEX command, to print a progress report.
(postgres@[local]:55000)[knowledgebase]> \h REINDEX
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
But it is not working.
(postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE knowledgebase;
ERROR: syntax error at or near "VERBOSE"
LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
^
Can somebody help me out regarding this issue.
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <william.sescu@suva.ch> escreveu:Hello %
Regarding the Docs
https://www.postgresql.org/docs/11/sql-reindex.html
and due to the REINDEX syntax, I should be able to specify VERBOSE when I run the REINDEX command, to print a progress report.
(postgres@[local]:55000)[knowledgebase]> \h REINDEX
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
But it is not working.
(postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE knowledgebase;
ERROR: syntax error at or near "VERBOSE"
LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
^
Can somebody help me out regarding this issue.
Your syntax is wrong. Try:REINDEX (VERBOSE) DATABASE knowledgebase;Regards--Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
That looks like a pretty bad syntax to require brackets around a keyword that has no contextual ambiguity.
Thanks for clarification. The REINDEX (VERBOSE) DATABASE xxx; works.
However, the syntax is not intuitive, from my point of view.
And TAB completion does not show you the (VERBOSE) option either.
e.g. if you press two times TAB, it does not show you the VERBOSE option
(postgres@[local]:55000)[knowledgebase]> REINDEX [TAB] [TAB]
DATABASE INDEX SCHEMA SYSTEM TABLE
Would it not be possible to allow 2 options. One with (VERBOSE) for backward compatibility and one with VERBOSE
Von: David G. Johnston [mailto:david.g.johnston@gmail.com]
Gesendet: Mittwoch, 3. Juli 2019 18:22
An: Avin Kavish <avinkavish@gmail.com>
Cc: Fabrízio de Royes Mello <fabrizio@timbira.com.br>; Sescu William (SW0) <william.sescu@suva.ch>; pgsql-admin@postgresql.org
Betreff: Re: REINDEX VERBOSE DATABASE not working
On Wed, Jul 3, 2019 at 8:56 AM Avin Kavish <avinkavish@gmail.com> wrote:
That looks like a pretty bad syntax to require brackets around a keyword that has no contextual ambiguity.
Future pacing and overall consistency.
Here's a link to the relevant discussion:
David J.
Disclaimer:
Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Вложения
Thanks for clarification. The REINDEX (VERBOSE) DATABASE xxx; works.
However, the syntax is not intuitive, from my point of view.
Would it not be possible to allow 2 options. One with (VERBOSE) for backward compatibility and one with VERBOSE
Hello David
Yes, I did read the thread. However, I still don’t see the advantage of running:
REINDEX ( VERBOSE ) DATABASE xxx;
Instead of:
REINDEX VERBOSE DATABASE xxx;
And coming back to the TAB completion thing, which is a fantastic feature, by the way, does not show you the option
which comes in parentheses. I don’t know if this is by design or not.
>REINDEX [TAB] [TAB]
DATABASE INDEX SCHEMA SYSTEM TABLE
I would expect with the current syntax implementation:
>REINDEX [TAB] [TAB]
(VERBOSE) DATABASE INDEX SCHEMA SYSTEM TABLE
Nevertheless, thanks everyone.
I think I will switch to the command line tool reindexdb. ;-) This one is more intuitive from my point of view:
reindexdb --verbose --dbname=xxx
Cheers,
William
Von: David G. Johnston [mailto:david.g.johnston@gmail.com]
Gesendet: Mittwoch, 3. Juli 2019 22:33
An: Sescu William (SW0) <william.sescu@suva.ch>
Cc: pgsql-admin@postgresql.org
Betreff: REINDEX VERBOSE DATABASE not working
On Wednesday, July 3, 2019, William Sescu (Suva) <william.sescu@suva.ch> wrote:
Thanks for clarification. The REINDEX (VERBOSE) DATABASE xxx; works.
However, the syntax is not intuitive, from my point of view.
Would it not be possible to allow 2 options. One with (VERBOSE) for backward compatibility and one with VERBOSE
Its possible but such a patch would never be committed (did you read the email thread?). Intuitiveness isn’t a huge concern here. Especially for a command that isn’t intended to be run manually often.
The learning curve for PostgreSQL includes knowing where to find command syntax and how to read it. Its a complex language that is constantly being added to.
David J.
Disclaimer:
Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.