Re: [GENERAL] identifying performance hits: how to ???
От | Jim Mercer |
---|---|
Тема | Re: [GENERAL] identifying performance hits: how to ??? |
Дата | |
Msg-id | 20000112140611.V4188@reptiles.org обсуждение исходный текст |
Ответ на | Re: [GENERAL] identifying performance hits: how to ??? (tayers@bridge.com) |
Список | pgsql-general |
On Wed, Jan 12, 2000 at 01:09:08PM -0500, tayers@bridge.com wrote: > J> nagoss=> \h vacuum > J> Command: vacuum > J> Description: vacuum the database, i.e. cleans out deleted records, updates statistics > J> Syntax: > J> VACUUM [VERBOSE] [ANALYZE] [table] > J> or > J> VACUUM [VERBOSE] ANALYZE [table [(attr1, ...attrN)]]; > > J> what is the correct syntax for doing a vacuum analyse? > > The correct syntax as shown in the help message is > 'vacuum analyze'. Notice the alternative spelling of analyse with a > 'z' not an 's'. > > Hope you have a very nice day, :-) [ picture of jim slapping himself in the forehead ] geez. i know it was right in front of me, but, grrrr. [ in his best homer simpson voice ] Doh! -- [ Jim Mercer jim@reptiles.org +1 416 506-0654 ] [ Reptilian Research -- Longer Life through Colder Blood ] [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
В списке pgsql-general по дате отправления: