Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-18 Thread Igor Neyman
t; From: Kirk Wythers [mailto:kwyth...@umn.edu] > Sent: Friday, January 18, 2013 11:15 AM > To: Igor Neyman > Cc: Kirk Wythers; pgsql-general@postgresql.org > Subject: Re: [GENERAL] speeding up a join query that utilizes a view > > > On Jan 18, 2013, at 10:05 AM, Igor Neyman >

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-18 Thread Kirk Wythers
Wythers [mailto:kwyth...@umn.edu] >> Sent: Friday, January 18, 2013 10:50 AM >> To: Igor Neyman >> Cc: Kirk Wythers; pgsql-general@postgresql.org >> Subject: Re: [GENERAL] speeding up a join query that utilizes a view >> >> >> On Jan 18, 2013, at

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-18 Thread Igor Neyman
013 10:50 AM > To: Igor Neyman > Cc: Kirk Wythers; pgsql-general@postgresql.org > Subject: Re: [GENERAL] speeding up a join query that utilizes a view > > > On Jan 18, 2013, at 8:10 AM, Igor Neyman > wrote: > > > Yes, my mistake, I meant to ask about fifteen_min_

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-18 Thread Kirk Wythers
On Jan 18, 2013, at 8:10 AM, Igor Neyman wrote: > Yes, my mistake, I meant to ask about fifteen_min_stacked_view definition, > and Postgres parameters from postgresql.conf configuration file, at least > those - modified from default setting and related to "resource consumption" > and "query t

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-18 Thread Igor Neyman
; -Original Message- > From: Kirk Wythers [mailto:kwyth...@umn.edu] > Sent: Thursday, January 17, 2013 5:05 PM > To: Igor Neyman > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] speeding up a join query that utilizes a view > > > On Jan 17, 2013, at 3:51 PM

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-17 Thread Kirk Wythers
tement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv CFLAGS_SL = LDFLAGS = -arch x86_64 -pipe -Os -g -Wall -Wno-deprecated-declarations -Wl,-dead_strip_dylibs LDFLAGS_EX = -mdynamic-no-pic LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-17 Thread Igor Neyman
@postgresql.org > Subject: Re: [GENERAL] speeding up a join query that utilizes a view > > > > > Not enough information: > > > > Postgres version? > > OS? > > Some Postgres configuration parameters, specifically related to > "RESOURCE USAGE&q

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-17 Thread Kirk Wythers
> > Not enough information: > > Postgres version? > OS? > Some Postgres configuration parameters, specifically related to "RESOURCE > USAGE" and " QUERY TUNING"? > Table structures (including indexes) for: fifteen_min_stacked_propper, > fifteen_min, and data_key? > View definition for fifteen_m

Re: [GENERAL] speeding up a join query that utilizes a view

2013-01-17 Thread Igor Neyman
> -Original Message- > From: Kirk Wythers [mailto:kwyth...@umn.edu] > Sent: Thursday, January 17, 2013 12:16 AM > To: pgsql-general@postgresql.org > Subject: speeding up a join query that utilizes a view > > I am looking for advice on a performance problem. I'm pretty sure that > the culpr

[GENERAL] speeding up a join query that utilizes a view

2013-01-16 Thread Kirk Wythers
I am looking for advice on a performance problem. I'm pretty sure that the culprit of my slow performance is a view that is several hundred million records in size. Because it is a view, I can only index the underlying table, but because the view generates an "un-pivoted" version of the underlyi