Re: Different execution plan between PostgreSQL 8.4 and 12.11

2022-10-12 Thread Klint Gore
From: gzh Sent: Wednesday, 12 October 2022 9:30 PM > Who can tell me which solution is better below: > Solution 1: Change the configuration parameters >set enable_seqscan = off > Solution 2: Add DISTINCT clause to SQL >explain analyze select DISTINCT 2 from analyze_word_reports where

Re: Different execution plan between PostgreSQL 8.4 and 12.11

2022-10-11 Thread Klint Gore
From: Bruce Momjian Sent: Wednesday, 12 October 2022 1:30 AM >On Tue, Oct 11, 2022 at 09:59:43AM -0400, Tom Lane wrote: >> David Rowley writes: >> > It feels like something is a bit lacking in our cost model here. I'm >> > just not sure what that is. >> >> The

RE: database "cdf_100_1313" does not exist

2019-09-09 Thread Klint Gore
From: nikhil raj [mailto:nikhilraj...@gmail.com] Sent: Tuesday, 10 September 2019 12:39 AM To: Adrian Klaver Cc: Tom Lane; Rob Sargent; Dan Livingston; Karsten Hilbert; pgsql-general@lists.postgresql.org Subject: Re: database "cdf_100_1313" does not exist >