[PERFORM] slow query - will CLUSTER help?

2013-12-19 Thread Sev Zaslavsky
Hello,_ _ I've got a very simple table with a very simple SELECT query, but it takes longer on the initial run than I'd like, so I want to see if there is a strategy to optimize this. Table rt_h_nbbo contains several hundred million rows. All rows for a given entry_date are appended to this

[PERFORM] slow loading of pages for SELECT query - will CLUSTER help?

2013-12-19 Thread Sev Zaslavsky
Hello, __ I've got a very simple table with a very simple SELECT query, but it takes longer on the initial run than I'd like, so I want to see if there is a strategy to optimize this. Table rt_h_nbbo contains several hundred million rows. All rows for a given entry_date are appended to this