Search Postgresql Archives

Re: vacuumdb did not analyze all tables?=

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Dec 14, 2023 at 12:20 PM Francisco Olarte <folarte@xxxxxxxxxxxxxx> wrote:
Ron:

On Thu, 14 Dec 2023 at 03:39, Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:
...
> Three of the 71 tables were not analyzed.  Why would that be?
...
> vacuumdb -U postgres -h $DbServer --analyze -j6 -t ... -t cds.cdstransaction_rp20_y2021 -t ...
...
>  cds.cdstransaction_rp20_y2021   | 2023-12-13 10:42:09.683143-05 | 2023-11-17 04:11:08.761861-05
>  css.image_annotation_rp20_y2021 | 2023-09-25 20:00:07.831722-04 | 2023-09-25 20:00:07.831793-04
>  tms.document_rp20_y2021         | 2023-12-13 10:42:03.079969-05 | 2023-11-17 04:11:56.583881-05

I'm not sure if you kept the line, but you have ellipsed-out ( is that
a word? )

I think so.
 
the interesting names, so quoted vacuumdb line is useless
for check.
 
71 tables were listed, and didn't want to flood my email with a KB or two of non-essential text.

I verified that all three tables were in the vacuumdb command line.  (The list was generated by a query, and stdout and stderr were redirected to a file, and I grepped it for the table names.)

If you want, I can attach the log file.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux