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 1pxDWq-0001Ro-K5 for pgsql-general@arkaria.postgresql.org; Thu, 11 May 2023 21:08:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pxDWo-0003sh-FC for pgsql-general@arkaria.postgresql.org; Thu, 11 May 2023 21:08:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pxDWo-0003sV-4n for pgsql-general@lists.postgresql.org; Thu, 11 May 2023 21:08:46 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pxDWl-0023IZ-2l for pgsql-general@lists.postgresql.org; Thu, 11 May 2023 21:08:45 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-55dc3431c64so66464107b3.2 for ; Thu, 11 May 2023 14:08:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1683839321; x=1686431321; h=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=XKQqPilreqb+TaEARghGRSl/MKizYd88cjmnFPbq17c=; b=oar8MvU4zyIyKZ//Tg1N0s8fao12mpcIScXQDRiMFskzOWr6aJhPKiykS0dAcHqfIZ v8+BNACQhCeRozsDn+kGSln3Tihd6VJl6YESNaEtdhqj2TqRMmVzj0gmoudOcel/eK1K 3RKsk9836XDeHWHzcPG78lt0O3z9KPM9KQPMhRtyBkkbGERxVW3N4TD5I6kUGCWOt+vp wwYjOBxd1ZEwXkzvjQG+bQ5oVcVMZbToOmWb96RoPaz/t9BJlockEGno/5dSPtKhin/R RIqdSkmjLCJJa0f7qsR5GwqgBlqMzN8wfUy1m8TRWdqiIQSH8Btmxnv77Lndjgt9sJDt 3LCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683839321; x=1686431321; h=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=XKQqPilreqb+TaEARghGRSl/MKizYd88cjmnFPbq17c=; b=a2CtVaNh5PgvOc/Ex41xrIXt9qliv5mQ9gvLxYfBHNPq1DXkZoj54E2EzrCzBIG+U7 9TBAwdE7QbyKfxd7KqCGFYO+/WZGiv8IB3CW7vz7AeqHjCD17SZ24r7/O7X+GykHdkxt YFK6v4mfc5vqXWHJhSGwfO0lt2+DidRKXvsG8gW+W0zwF+NfmOMVi7QQRxSz1/Tuahd0 0Ixg0zQ/2X/bOKYytkcK30A8+8mZxycUQbnrFwmF0YOnyQzuV5aS/VsXPvxs4KsCtQY8 mgfATLIVWIdyIhlgDG8YGXzvYYotZ9KXfXmWs/cS6Ls4DxQXbL5Z6y3fvbD/2BgpyDB/ SL/A== X-Gm-Message-State: AC+VfDwzuQuzbUAd1gRSRlw3+SDqAC7C5NCyJ4QDpVdzRSe0rH+2UBqb 28Q6K7AVZdRvk7RGFLx3T6pj1u/2QEo= X-Google-Smtp-Source: ACHHUZ6K090WUrUKTcJMubgvjzMzHalOfwo7s+SmaqWhls7VrpfyZmnO7dgbf8LmzduGmWCreojSdw== X-Received: by 2002:a0d:e405:0:b0:54e:ffbc:7ac2 with SMTP id n5-20020a0de405000000b0054effbc7ac2mr24898405ywe.45.1683839321098; Thu, 11 May 2023 14:08:41 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:2cdc:7b7a:1a0:3910? ([2600:1700:bd2c:b810:2cdc:7b7a:1a0:3910]) by smtp.googlemail.com with ESMTPSA id x186-20020a81a0c3000000b0054eff15530asm5200659ywg.90.2023.05.11.14.08.40 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 11 May 2023 14:08:40 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------yyNE1NFkBO7Ggx0FzwiPW5Zz" Message-ID: Date: Thu, 11 May 2023 16:08:38 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: order by Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------yyNE1NFkBO7Ggx0FzwiPW5Zz Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 5/11/23 09:55, Marc Millas wrote: > Thanks, > > I do know about index options. > > that table have NO (zero) indexes. If the table has no indices, then why did you write "it looks like there is something different within the *b-tree operator* class of varchar"?  After all, you only care about b-trees when you have b-tree indices. -- Born in Arizona, moved to Babylonia. --------------yyNE1NFkBO7Ggx0FzwiPW5Zz Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 5/11/23 09:55, Marc Millas wrote:
Thanks,

I do know about index options.

that table have NO (zero) indexes.

If the table has no indices, then why did you write "it looks like there is something different within the b-tree operator class of varchar"?  After all, you only care about b-trees when you have b-tree indices.

--
Born in Arizona, moved to Babylonia.
--------------yyNE1NFkBO7Ggx0FzwiPW5Zz--