Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uH3Ai-00CXa3-VP for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 16:17:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uH3Ai-00H0uj-3p for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 16:17:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uH3Ah-00H0rG-NR for pgsql-general@lists.postgresql.org; Mon, 19 May 2025 16:16:59 +0000 Received: from mail-oi1-x234.google.com ([2607:f8b0:4864:20::234]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uH3Af-002bKd-0V for pgsql-general@lists.postgresql.org; Mon, 19 May 2025 16:16:58 +0000 Received: by mail-oi1-x234.google.com with SMTP id 5614622812f47-3fbc00143d6so3782162b6e.3 for ; Mon, 19 May 2025 09:16:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747671417; x=1748276217; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=x8Qq80lrm17heZQ9JVzLa0wfq1kGhSeYRk6rkO+NaYY=; b=hvncREJLpuqCo7Z5wdGyjcbavlLSHTv8MpYaHaXTIo/CvA/fP2iRwcKaOflv/Um6hy 5IRjSNf/xomTuF6Na/vYtW5c4EBxx8s9n96VXcqZdFTVJcKyh6aZjRTaXe7x62SA0pT3 5qKELxU20hggl8ao2x/Pu78jZ5x4bSLNfMl6NjQq1hrn8jM1e9lDdKO8dKIIFJ2ClkV4 aB6iXLagB3AQxlw+tc+pYtdrvxCMbpHCcTnPHUYBd4gdr4e2JUxQJOceAzIWNdIf7koi QPPfcSZ5TitlEwPKE5IUSnzR5FiYCRic1qOne0V6f0QtofOpwIXL6+FncC5lM/If8iXK BlNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747671417; x=1748276217; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=x8Qq80lrm17heZQ9JVzLa0wfq1kGhSeYRk6rkO+NaYY=; b=QXD9dlalO4WgcnDuk5Yrc9S6uRpaIeQ36ipRiHJ04x8WzjtRHjnUZXS5K3hj47VQX7 XJJJBD2GRiT8dPmQw3JDc+sQjgX+IH7nzK5oEPK4pI+OlhIVWXUN2NOyxAidPSfhaAjf JKZ2/+7cfcPj9lW+HIS+5wIWSQmWT4no/f2+/hOERRAbQZnk/otpL9xrqhdPC+qa4Oro +jP4E1awK12hk3l/dyIYtGWHQvOBqCBHYXC+vngvxoXpxvqZjtkr/DdbctfXz3+kHOYY y0Onr8kpqMS+GKESVa7gdBafaNRmGUElk0dQSNViQS8Py3Ncx5kZHvGSA5O2mSmyb/1n vljA== X-Gm-Message-State: AOJu0Yz8ulwmumXpapbKDfiDjGDxIJyP6f/uypGCf2pvLIOaEqTreoar dTx5wCKSZfxjb40pi4Qd9uBZRut3ujBSJsAnZ0nVQGdV2l0EMksVzZxD/+z1xClQi/oiBKLqvBC RhKOlYW1AiAXDcXdxNvlylYUgMsHkCLw= X-Gm-Gg: ASbGncupJPI5faoZBOHFNIbWn6LB5uoGCQh72BpAA/Z6BECo+UtyNiASlgFd2A7Ph+z BMlg3zRkGPVCGgPviuQMryBtmdpUcUrE5K1xX9d09trW9+W/Ksgv/2qHkZm6+r/3j5UQRUseQu9 hmMNhi3Z9Cs45PvSXpquwUW+U7o354iRTV+Xr1jw== X-Google-Smtp-Source: AGHT+IHg7/vlHzRDYsXUQxEObfRF+Mi0qpsYQ+mMC7ShH9aXcHxCzj5R85/qHiHv/h+l6i2FlXWXpco88BtY7IyBwPw= X-Received: by 2002:a05:6808:3307:b0:404:ee81:e012 with SMTP id 5614622812f47-404ee81e56dmr3987072b6e.36.1747671417092; Mon, 19 May 2025 09:16:57 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:2204:b0:5c9:f01c:52e7 with HTTP; Mon, 19 May 2025 09:16:56 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Mon, 19 May 2025 09:16:56 -0700 X-Gm-Features: AX0GCFt7Oq-WoOxe-kEUMNCwPjT3OOaX-j8l1Sj7e5AelO6slS6m5S7UL-4bOM8 Message-ID: Subject: Re: get speed help To: Dias Thomas Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ffff2106357f759c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ffff2106357f759c Content-Type: text/plain; charset="UTF-8" On Monday, May 19, 2025, Dias Thomas wrote: > Hello all, > Could i get a help, postgres 1 billion records indexed table, search > speed in a normal machine, no parallel processing ... for a knowledge ?? > https://wiki.postgresql.org/wiki/Slow_Query_Questions David J. --000000000000ffff2106357f759c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, May 19, 2025, Dias Thomas <dsthomas500@gmail.com> wrote:
Hello all,
=C2=A0Could i get a help, postgres 1 bill= ion records indexed table, search speed in a normal machine, no parallel pr= ocessing ... for a knowledge ??


=
David J.

--000000000000ffff2106357f759c--