not pick up the right index
On Thu, 10 Jan 2019 at 01:55, Abadie Lana wrote:
> The other query suggested by D.Rowley has the same issue : still swap
> activity is higher.
> explain analyze select 'BUIL-B36-VA-RT-RT1:CL0001-2-ABW',
> c.smpl_time,c.nanosecs,c.float_v
On Thu, 10 Jan 2019 at 01:55, Abadie Lana wrote:
> The other query suggested by D.Rowley has the same issue : still swap
> activity is higher.
> explain analyze select 'BUIL-B36-VA-RT-RT1:CL0001-2-ABW',
> c.smpl_time,c.nanosecs,c.float_val,c.num_val,c.str_val,c.datatype,c.array_val
> from sampl
-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
On Mon, Jan 07, 2019 at 04:09:50PM +, Abadie Lana wrote:
> "channel_pkey" PRIMARY KEY, btree (channel_id)
> "unique_chname" UNIQUE CONSTRAINT, btree (name)
> "channel_name_channel_id_idx" btree (name, channel_id)
Note, the third index is more or less redundant.
> I would say that
-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
On Fri, Jan 04, 2019 at 08:58:57AM +, Abadie Lana wrote:
> SELECT (SELECT sum(x) FROM unnest(most_common_freqs) x) frac_MCV, tablename,
> attname, null_frac, n_distinct, array_length(most_common_vals,1) n_mcv,
> array_length(histogram_bounds,1) n_hist FROM pg_stats WHERE attname='...' AND
>
@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 parameters : effective_cache_size : 4GB, shared_buffers 4GB,
> work_mem 4MB
I doubt it will help much, but you should consider increasing work_mem, unless
yo
-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
On Thu, Jan 03, 2019 at 12:57:27PM +, Abadie Lana wrote:
> Main parameters : effective_cache_size : 4GB, shared_buffers 4GB, work_mem 4MB
I doubt it will help much, but you should consider increasing work_mem, unless
you have many expensive queries running at once.
Could you also send the res
On Fri, 4 Jan 2019 at 02:20, Abadie Lana wrote:
> > From: David Rowley
> > Sent: 03 January 2019 14:01
> Right, so you need to check your indexes on sample_ctrl_year and
> sample_buil_year. You need an index on (channel_id, smpl_time) on those.
> These indexes exist already
That's interesting.
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
> From: David Rowley
> Sent: 03 January 2019 14:01
> That's surprisingly slow. Can you share the EXPLAIN (ANALYZE, BUFFERS) of
> that?
>
> explain (analyze,buffers) select
> 'BUIL-B36-VA-RT-RT1:CL0001-2-ABW',c.smpl_time,c.nanosecs,c.float_val,c.num_val,c.str_val,c.datatype,c.array_val
> from sa
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
On Fri, 4 Jan 2019 at 01:57, Abadie Lana wrote:
> 4) name is unique, constraint and index created. Right index is picked up and
> query time is rather constant there 40sec.
That's surprisingly slow. Can you share the EXPLAIN (ANALYZE, BUFFERS) of that?
--
David Rowley http:
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
On Thu, 3 Jan 2019 at 05:28, Abadie Lana wrote:
> 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.cha
On Wed, Jan 02, 2019 at 04:28:41PM +, Abadie Lana wrote:
> css_archive_3_0_0=# explain analyze 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 wh
20 matches
Mail list logo
