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 1uH361-00CWAG-Td for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 16:12:10 +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 1uH361-00GvFz-0S for pgsql-general@arkaria.postgresql.org; Mon, 19 May 2025 16:12:09 +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 1uH360-00GvBK-M2 for pgsql-general@lists.postgresql.org; Mon, 19 May 2025 16:12:08 +0000 Received: from mail-pf1-x433.google.com ([2607:f8b0:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uH35y-002bHe-0s for pgsql-general@lists.postgresql.org; Mon, 19 May 2025 16:12:07 +0000 Received: by mail-pf1-x433.google.com with SMTP id d2e1a72fcca58-742b614581dso3093421b3a.3 for ; Mon, 19 May 2025 09:12:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747671126; x=1748275926; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=MR2kDJn0mi3C3Dp1VAnlerAuD0xOeGmOqZqwPCcDqzk=; b=Sq7UZKUHUI5IvWMeOl5vi9SgIK7HhbJk/FnEDhbNpal+5qNmZSLi1gpwzqmgN5knEH hGcNzQ5tSTPDF7tq1sFCADhICPXq8a868ICF9jCr2ANUjjaDNWPXS+E0nVDoWljRSr/4 t9DaiQjiymQWzSZLUSp8z/CT3JYYa6suBbuCbSnkfY25hn0Rvk7cG2mZ+A1ihD+yRtS5 3J52BKrwjGzmbafYxefX/uXpikHdpSYYjZZGFSM0PB8KtNMcj5Zmh4Lo7rvkadO6f1W7 GTYEEEI1pTf6e9vKmwMnX8+LyAMnuKfjhTetOUmtMVnkvP0bnGaOQ7QrsMoRGG6hYf9P ezbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747671126; x=1748275926; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=MR2kDJn0mi3C3Dp1VAnlerAuD0xOeGmOqZqwPCcDqzk=; b=chkM9EHMJ/r/ikSuQaG1EkoEo9BPw2DN0IksCKoHJSrYJz9KMl8UkgGZoXIUD4zPdY Xzo5ZZRWnzOv51ICLaXspg9D2BELfIXKIgCQ54VHgacXlq4ZivdXnNpCuH0C+kkdFgNT Gq1YdvOZ0Ss8CeuV0LUiddRoBua34CKf9XDB74yUkN89gLsh8hrd/X1+yLBnQ8iZ9H/r tlOMn0FmwRNM7IGdeevCEBfYM4DX5ZwBw8LPitw3R9BM9oIOyRUXKVMZFqCLb3kn5wr7 j3NL2E41Cd0QtCtCOa64Dm+QgNcfYZUyRdCWDWUpfLWXI5Hn08of/CniUMVGrzrKR+2Q LiHw== X-Gm-Message-State: AOJu0Yz0XzJo3v1iVWzfmg+EspnmMTJE5vmmNtu0YLgEJ6la9GAngsRf tGJvnXlMesIokq9TUAMH2vWnYXZ8LBUghhs4KAN/AHXpfQlmwAqlhofMFr3jkHUUTV5J5RGgGEm J15oSYOHCp9tRthzQHT4IbLiY9kcMXx5iVaNHIsk= X-Gm-Gg: ASbGncv64CUs/wnOp34IHxCOREzJtorolkHA8g7IN3SVilILb6jyzuHjAktGK3tVYoZ ge17Q5FVuyDAcztgP3UxtjrcsuCoee/Sp0GpSKxKocNknpc4q1xkjzVL1g/CHp03eOFlUnj91xs vgoX7pI8Cb7Jj6/wLeMEbtkRTS8xWu6i8DDCpG0R1Wu/fBqK7OpqjP7P4K3VGUoxJ7QNw= X-Google-Smtp-Source: AGHT+IFuhsk4QpwOhz/x51fDPWXhiA3kPrUbr9TY136s7RItLeRO9uNqlOrMFAmFLwbDq5HOn9TxOaF4JtvFVjfaxQE= X-Received: by 2002:a05:6a00:1994:b0:736:46b4:bef2 with SMTP id d2e1a72fcca58-742accc6d5fmr16391810b3a.6.1747671125866; Mon, 19 May 2025 09:12:05 -0700 (PDT) MIME-Version: 1.0 From: Dias Thomas Date: Mon, 19 May 2025 21:41:53 +0530 X-Gm-Features: AX0GCFvsJ1vIdGzzaUa4qwCnhlw1vz3UZCL5oqaqTGtQ3gHDs9c6-UL-1s7fRPY Message-ID: Subject: get speed help To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000a43ab906357f6429" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a43ab906357f6429 Content-Type: text/plain; charset="UTF-8" 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 ?? regards, Dias Thomas --000000000000a43ab906357f6429 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello all,
=C2=A0Could i get a help, postgres 1 billion= records indexed table, search speed in a normal machine, no parallel proce= ssing ... for a knowledge ??

regards,
Dias Thomas
--000000000000a43ab906357f6429--