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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qkCt3-00DXWz-Ey
	for pgsql-admin@arkaria.postgresql.org; Sun, 24 Sep 2023 00:22:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qkCs3-003S0G-Ib
	for pgsql-admin@arkaria.postgresql.org; Sun, 24 Sep 2023 00:21:11 +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 <matt_gibbins@fastmail.com.au>)
	id 1qkCs3-003Rzb-6D
	for pgsql-admin@lists.postgresql.org; Sun, 24 Sep 2023 00:21:11 +0000
Received: from wout4-smtp.messagingengine.com ([64.147.123.20])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <matt_gibbins@fastmail.com.au>)
	id 1qkCrw-006HSD-FC
	for pgsql-admin@lists.postgresql.org; Sun, 24 Sep 2023 00:21:10 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailout.west.internal (Postfix) with ESMTP id 778363200392;
	Sat, 23 Sep 2023 20:21:02 -0400 (EDT)
Received: from mailfrontend1 ([10.202.2.162])
  by compute5.internal (MEProxy); Sat, 23 Sep 2023 20:21:02 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fastmail.com.au;
	 h=cc:cc:content-type:content-type:date:date:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:sender:subject:subject:to:to; s=fm2; t=1695514861; x=
	1695601261; bh=ym/uM9whaePHBSeAhv1rjMNYLMqD57lFo8gCsw5Ap1Q=; b=c
	IQeVkHp/5iHhYfWasKbNvtkCtaXiC5IiTWaKsPzYJZtjGjwg/btq/RT4lLQwg8SP
	HftK3AuYgVTQH9Qg6Qt+5b7akLsBmvSG3vEm+iogVbqVIrNcWsneb2IgjXZCGz/2
	FYW2+onk8hDzluPR8UwR2LkqwTR78Xs2xn+ewL5K+gd1PxScioZzIDo9Ycov4CS5
	gnvPAHsmK2ic2ydQl4/ZLmNJuOPOg7e00if2DvTzCniDqATvUd0/MVMR4i8AJRG8
	vqJmmKZ4+CG89AOe//icocLB3pBJnELxM3kaaFDWY6IIrCnBLxeoe2iMlklBJRoy
	ykQmFCMOoWWK83coiAZ/Q==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-type:content-type:date:date
	:feedback-id:feedback-id:from:from:in-reply-to:in-reply-to
	:message-id:mime-version:references:reply-to:sender:subject
	:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender
	:x-sasl-enc; s=fm2; t=1695514861; x=1695601261; bh=ym/uM9whaePHB
	SeAhv1rjMNYLMqD57lFo8gCsw5Ap1Q=; b=F0gnZF1dv50zl3Y3iakjJgQ5/xjEc
	Zk8KPYAX2YeoqEWAWlYMxSOvfLeD5UmRUPnS+5AkiSGNTLINsBU/LrHkZtiLEMPf
	Tm+UkUXpNxjur7S/7juNKRXGacBNdwdNP5xiIYYFk0ty6tfKySDpwSHu//TuUizg
	+M7FqG/Z403ccBNiK+x6a+Vu9lzPQyROCp+S+d1GJoBcRpyD39jncSYnUgGnVTIf
	aJCcGZQTCAZCUkfUbydxyFsyKv7yMBA1bs427YgVaTjPZrZNOcA202B8A4JvIDWQ
	FPTHBueuw3JPtLgton1HPaeJxK9b59gsDG+ysTXWpkMYF7FO3BrR+6T2A==
X-ME-Sender: <xms:7YAPZTuDGItwINwqQbcI4zgPH402I-dT5IpXcrEJpkaLjyj6hT7VWg>
    <xme:7YAPZUf-sKt2SMuKhLS1SyZmdSYQBFyxMGPMgl3GfChivHu6mtLH1ZtCkBKMXD-RM
    k2FEq8aLcSu59ksZP8>
X-ME-Received: 
 <xmr:7YAPZWxmpBF3r-Li1XC4lAo20qqC1yTeeAMfZQLO8SVS5nbamaEI6uip0KNWEVhEABolFwa4Vf7fLpYje6M_rjLPOHIMxWK0zI0>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgedviedrudeluddgfeegucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucenucfjughrpegtkfffgggfuffvvehfhfgjsegrtd
    erredtvdejnecuhfhrohhmpeforghtthcuifhisggsihhnshcuoehmrghtthgpghhisggs
    ihhnshesfhgrshhtmhgrihhlrdgtohhmrdgruheqnecuggftrfgrthhtvghrnhepfeduve
    evhffftdffvdfhueelledthfffgeejjeffudefffejjeffvdeggedtjeefnecuvehluhhs
    thgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhgrthhtpghgihgssg
    hinhhssehfrghsthhmrghilhdrtghomhdrrghu
X-ME-Proxy: <xmx:7YAPZSMQeI9Un7y9PIehdNjzVocDLmRipketHRbIT9uj_fc1py8ilg>
    <xmx:7YAPZT8VJmsX3kc2E2wf2OkMcs9hIAOtD7gaxRUeDZAlmHRo-VYCcQ>
    <xmx:7YAPZSVCSI9rH0ZmshzvknkvSPZvHV9831OObNTDG5mYmoYg66IiGw>
    <xmx:7YAPZQFlt2tZAY_JG6JH80hFIEQCARfELtSyibkYLGbSPRcZQTw5Yg>
Feedback-ID: i6d194797:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat,
 23 Sep 2023 20:21:00 -0400 (EDT)
Content-Type: multipart/alternative;
 boundary="------------tuT4nkQbtdLgQpj4o59F597z"
Message-ID: <017d9317-3b88-412c-bdc1-3e0a37ed53ff@fastmail.com.au>
Date: Sun, 24 Sep 2023 10:20:57 +1000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Segmentation fault when running queries in sequence
Content-Language: en-AU
To: abbas alizadeh <ramkly@yahoo.com>
Cc: pgsql-admin@lists.postgresql.org
References: <728d1797-efdd-4298-8ab2-042a28ddaae2@fastmail.com.au>
 <E87AF61A-F0AD-4510-8B73-8160933187D5@yahoo.com>
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
In-Reply-To: <E87AF61A-F0AD-4510-8B73-8160933187D5@yahoo.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/017d9317-3b88-412c-bdc1-3e0a37ed53ff%40fastmail.com.au>
Precedence: bulk

This is a multi-part message in MIME format.
--------------tuT4nkQbtdLgQpj4o59F597z
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 23/9/23 21:38, abbas alizadeh wrote:
> He Matt
> Most of time segment fault is because of broken index, reindex the 
> table (or if you can whole db) it might help get rid of segment faults
>
> Regards
> Abbas

Abbas

Thanks for the tip.

Unfortunately reindexing the database did not resolve the issue.

Matt.

--------------tuT4nkQbtdLgQpj4o59F597z
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 23/9/23 21:38, abbas alizadeh wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:E87AF61A-F0AD-4510-8B73-8160933187D5@yahoo.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div style="direction: ltr;">He Matt</div>
      <div style="direction: ltr;">Most of time segment fault is because
        of broken index, reindex the table (or if you can whole db) it
        might help get rid of segment faults </div>
      <div dir="ltr"><br>
      </div>
      <div dir="ltr">Regards</div>
      <div dir="ltr">Abbas</div>
    </blockquote>
    <p>Abbas</p>
    <p>Thanks for the tip. <br>
    </p>
    <p>Unfortunately reindexing the database did not resolve the issue.</p>
    <p>Matt.<br>
    </p>
  </body>
</html>

--------------tuT4nkQbtdLgQpj4o59F597z--