Re: [PERFORM] slow query on tables with new columns added.

2011-09-24 Thread Filip Rembiałkowski
2011/9/23 M. D. li...@turnkey.bz I did a software upgrade, and with it came a new feature where when selecting a customer it queries for the sum of a few columns. This takes 7 seconds for the 'Cash Sale' customer - by far the most active customer. I'd like to see if it's possible to get it

[PERFORM] [PERFORMANCE] Insights: fseek OR read_cluster?

2011-09-24 Thread Antonio Rodriges
Hello, It is interesting how PostgreSQL reads the tablefiie. Whether its indexes store/use filesystem clusters locations containing required data (so it can issue a low level cluster read) or it just fseeks inside a file? Thank you -- Sent via pgsql-performance mailing list

Re: [PERFORM] DBT-5 Postgres 9.0.3

2011-09-24 Thread Mark Wong
On Wed, Aug 17, 2011 at 8:29 AM, bobbyw bob...@sendprobe.com wrote: Hi, I know this is an old thread, but I wanted to chime in since I am having problems with this as well. I too am trying to run dbt5 against Postgres.  Specifically I am trying to run it against Postgres 9.1beta3. After