Re: [PERFORM] postgres 9.3 vs. 9.4

2014-09-19 Thread Mkrtchyan, Tigran
- Original Message - > From: "Mark Kirkwood" > To: "Tigran Mkrtchyan" > Cc: "Merlin Moncure" , "postgres performance list" > > Sent: Friday, September 19, 2014 8:26:27 AM > Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 > > On 19/09/14 17:53, Mkrtchyan, Tigran wrote: > > > > > > - O

Re: [PERFORM] postgres 9.3 vs. 9.4

2014-09-19 Thread Mark Kirkwood
On 19/09/14 19:24, Mkrtchyan, Tigran wrote: - Original Message - From: "Mark Kirkwood" To: "Tigran Mkrtchyan" Cc: "Merlin Moncure" , "postgres performance list" Sent: Friday, September 19, 2014 8:26:27 AM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On 19/09/14 17:53, Mkrtchyan, Ti

[PERFORM] query a table with lots of coulmns

2014-09-19 Thread Björn Wittich
Hi mailing list, I am relatively new to postgres. I have a table with 500 coulmns and about 40 mio rows. I call this cache table where one column is a unique key (indexed) and the 499 columns (type integer) are some values belonging to this key. Now I have a second (temporary) table (only 2

Re: [PERFORM] query a table with lots of coulmns

2014-09-19 Thread Szymon Guz
On 19 September 2014 13:51, Björn Wittich wrote: > Hi mailing list, > > I am relatively new to postgres. I have a table with 500 coulmns and about > 40 mio rows. I call this cache table where one column is a unique key > (indexed) and the 499 columns (type integer) are some values belonging to >

Re: [PERFORM] query a table with lots of coulmns

2014-09-19 Thread Björn Wittich
Hi Szymon, yes I have indexes on both columns (one in each table) which I am using for join operation. Am 19.09.2014 14:04, schrieb Szymon Guz: On 19 September 2014 13:51, Björn Wittich > wrote: Hi mailing list, I am relatively new to postgres. I hav

Re: [PERFORM] query a table with lots of coulmns

2014-09-19 Thread Pavel Stehule
2014-09-19 13:51 GMT+02:00 Björn Wittich : > Hi mailing list, > > I am relatively new to postgres. I have a table with 500 coulmns and about > 40 mio rows. I call this cache table where one column is a unique key > (indexed) and the 499 columns (type integer) are some values belonging to > this ke

Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-09-19 Thread Merlin Moncure
On Wed, Sep 17, 2014 at 7:11 PM, Josh Berkus wrote: > Folks, > > Just encountered another case of critical fail for abort-early query > plans. In this case, it will completely prevent a user from upgrading > to 9.3; this is their most common query, and on 9.3 it takes 1000X longer. > > Maybe we s

Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-09-19 Thread Josh Berkus
On 09/19/2014 10:15 AM, Merlin Moncure wrote: > On Wed, Sep 17, 2014 at 7:11 PM, Josh Berkus wrote: >> This is the core issue with abort-early plans; they depend on our >> statistics being extremely accurate, which we know they are not. And if >> they're wrong, the execution time climbs by 1000X o

Re: [PERFORM] query a table with lots of coulmns

2014-09-19 Thread Josh Berkus
On 09/19/2014 04:51 AM, Björn Wittich wrote: > > I am relatively new to postgres. I have a table with 500 coulmns and > about 40 mio rows. I call this cache table where one column is a unique > key (indexed) and the 499 columns (type integer) are some values > belonging to this key. > > Now I hav

Re: [PERFORM] postgres 9.3 vs. 9.4

2014-09-19 Thread Mark Kirkwood
On 19/09/14 19:24, Mkrtchyan, Tigran wrote: - Original Message - From: "Mark Kirkwood" To: "Tigran Mkrtchyan" Cc: "Merlin Moncure" , "postgres performance list" Sent: Friday, September 19, 2014 8:26:27 AM Subject: Re: [PERFORM] postgres 9.3 vs. 9.4 On 19/09/14 17:53, Mkrtchyan, Ti

Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-09-19 Thread Greg Stark
On 19 Sep 2014 19:40, "Josh Berkus" wrote: > > On 09/19/2014 10:15 AM, Merlin Moncure wrote: > > On Wed, Sep 17, 2014 at 7:11 PM, Josh Berkus wrote: > >> This is the core issue with abort-early plans; they depend on our > >> statistics being extremely accurate, which we know they are not. And if