Oups wrong copy and paste. I did run your query with equal instead of in but it
resulted in the same plan
From: David Rowley
Sent: 09 January 2019 17:41:24
To: Abadie Lana
Cc: Justin Pryzby; pgsql-performance@lists.postgresql.org
Subject: Re: select query does
-Original Message-
From: Justin Pryzby
Sent: 08 January 2019 09:15
To: Abadie Lana
Cc: David Rowley ;
pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
On Mon, Jan 07, 2019 at 04:09:50PM +, Abadie Lana wrote:
> "chan
-Original Message-
From: Justin Pryzby
Sent: 05 January 2019 05:24
To: Abadie Lana
Cc: David Rowley ;
pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
On Fri, Jan 04, 2019 at 08:58:57AM +, Abadie Lana wrote:
> SELECT (SELECT su
-Original Message-
From: pgsql-performance-owner+m22888-112...@lists.postgresql.org
On Behalf Of
Abadie Lana
Sent: 04 January 2019 09:18
To: Justin Pryzby
Cc: David Rowley ;
pgsql-performance@lists.postgresql.org
Subject: [Possible Spoof] RE: select query does not pick up the right
-Original Message-
From: Justin Pryzby
Sent: 04 January 2019 00:48
To: Abadie Lana
Cc: David Rowley ;
pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
On Thu, Jan 03, 2019 at 12:57:27PM +, Abadie Lana wrote:
> Main paramet
-Original Message-
From: David Rowley
Sent: 03 January 2019 22:42
To: Abadie Lana
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
On Fri, 4 Jan 2019 at 02:20, Abadie Lana wrote:
> > From: David Rowley
> > Sent: 03 Jan
Message-
From: pgsql-performance-owner+m22888-112...@lists.postgresql.org
On Behalf Of
Abadie Lana
Sent: 03 January 2019 14:21
To: David Rowley
Cc: pgsql-performance@lists.postgresql.org
Subject: [Possible Spoof] RE: select query does not pick up the right index
Warning: This message was sent by
Message-
From: David Rowley
Sent: 03 January 2019 14:18
To: Abadie Lana
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
> From: David Rowley
> Sent: 03 January 2019 14:01
> That's surprisingly slow. Can you share the EXPLAIN (AN
Message-
From: David Rowley
Sent: 03 January 2019 14:01
To: Abadie Lana
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
On Fri, 4 Jan 2019 at 01:57, Abadie Lana wrote:
> 4) name is unique, constraint and index created. Right index is pic
Message-
From: Justin Pryzby
Sent: 02 January 2019 17:45
To: Abadie Lana
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
On Wed, Jan 02, 2019 at 04:28:41PM +, Abadie Lana wrote:
> css_archive_3_0_0=# explain analyze select t.n
Message-
From: David Rowley
Sent: 03 January 2019 01:16
To: Abadie Lana
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: select query does not pick up the right index
On Thu, 3 Jan 2019 at 05:28, Abadie Lana wrote:
> I would appreciate any hints as this problem looks to me rather stra
Hi all
I would appreciate any hints as this problem looks to me rather strange...I
tried to google it but in vain.
select t.name,
c.smpl_time,c.nanosecs,c.float_val,c.num_val,c.str_val,c.datatype,c.array_val
from sample c, channel t where t.channel_id=c.channel_id and
t.name='BUIL-B36-VA-RT-RT1
12 matches
Mail list logo
