Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pDLy4-0004NW-DY for pgsql-general@arkaria.postgresql.org; Thu, 05 Jan 2023 08:51:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pDLy1-0007hk-87 for pgsql-general@arkaria.postgresql.org; Thu, 05 Jan 2023 08:51:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pDLy0-0007ha-Kx for pgsql-general@lists.postgresql.org; Thu, 05 Jan 2023 08:51:16 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pDLxu-0002XI-9B for pgsql-general@lists.postgresql.org; Thu, 05 Jan 2023 08:51:15 +0000 Received: by mail-io1-xd33.google.com with SMTP id i83so19231078ioa.11 for ; Thu, 05 Jan 2023 00:51:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=j0sTFxvc+/uuvfdNldyWtPjnE4VZlE+hkN7C80qV9FA=; b=glsg8EWqm7Vq2ofpy2+VO14uq0TR/bbzpQUsJVapuIaek4DzmewG/iBmBM2803Qpmf KbBqqHCVEytlU+ILON80a7DGVu4zYxhcB3feKdbAqzJpSfhVWsvPSkCbbtbROzoxLFq7 QyCEVzP9T9tUjYkeI0maeOjOV0ocdasenNC4qzj6lL34aw5T0giVwU0+DUSa3AaBa34x Yv75hT7LVj6xUiuW4dNqenKJDYvcVziQsc7Uq6lpQvNMoOVd1peNU/HKH6urPz8xSFar M2Qw96SF2blzEVoRMMB40/y62dhpiYCuw8lOjCZ1A+8bECUuBKTLl8BpEfPeFqbBp3dD OPFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=j0sTFxvc+/uuvfdNldyWtPjnE4VZlE+hkN7C80qV9FA=; b=giDdWvYngPK7txLWn7c7GfG/G+mZh+2Aobm/vLW4PK4SGkNaqlS8l8xKy54M0MWcWx 4xjzfpSylm48yq7e8KTG+n6qrP2IbS/y1dkRAW8YomllDeDHdSYA6IWupbfM2qCBDaNV 3nmSh0rbjyYebhb6jPPWpvly2nD9EyUijSyYWUCgLVoXYRxDI4T27IqY3W81v/4Jfp4G 3UbYqfbMOMCebwYzv0GuVzq4+tss1u44ViW43k+iIVVDDhW372FKVrH0urqric8w8Yg/ 4OOwmpO548lfPi4DtsUGHGgfyrWTmEM3Z6bET1gPMbhX8Sxq6yj2BaqydSotRu/jfyiQ 45KA== X-Gm-Message-State: AFqh2kq3Yfs/J6+elgXu7oCcU5RO7XxU6ITcRfR+QR/G4JdqEpjQcowr mMJZa2DL82pIJHiN/BnVQNxsH8rh58U= X-Google-Smtp-Source: AMrXdXu6PLHSKfZFtgUJC5tC+U2Oc+3rct7/QAJT1kh8CKi1MRjEg6x9cpJvyWaid6O3LqdHz1+9xA== X-Received: by 2002:a5e:a609:0:b0:6bc:d715:b935 with SMTP id q9-20020a5ea609000000b006bcd715b935mr30765289ioi.15.1672908669124; Thu, 05 Jan 2023 00:51:09 -0800 (PST) Received: from [192.168.1.115] (h244.184.30.69.dynamic.ip.windstream.net. [69.30.184.244]) by smtp.gmail.com with ESMTPSA id c12-20020a0566022d0c00b006e4e8ad6b2bsm13258273iow.36.2023.01.05.00.51.08 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 05 Jan 2023 00:51:08 -0800 (PST) Message-ID: Date: Thu, 5 Jan 2023 02:51:08 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.0.2 Subject: Re: REINDEX vs VACUUM Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <70615d25-201f-ad4a-1291-806999ca36fb@rblst.info> <4dee765f-2196-90b9-efa1-896859552989@gmail.com> From: Brad White In-Reply-To: <4dee765f-2196-90b9-efa1-896859552989@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/4/2023 9:34 AM, Ron wrote: > I don't think VACUUM FULL (copy the table, create new indices and > other metadata all in one command) actually vacuums tables.  It's a > misleading name. > > Something like REBUILD TABLE would be a better name. Well s***. That explains a lot. Thanks for clearing that up for me.