On Thu, Sep 3, 2009 at 7:33 AM, Mark Starkman wrote:
> I am new to PostgreSQL and I am evaluating it for use as a data warehouse.
> I am really struggling to get a simple query to perform well. I have put
> the appropriate indexes on the table (at least they are appropriate from my
> use with sev
Mark Starkman wrote:
> I'm not sure how to get it to return in
> reasonable amount of time.
Some more information could help.
What version of PostgreSQL is this?
Please give an overview of the hardware and OS.
Please show your postgresql.conf file, excluding comments.
Please run your q
I am new to PostgreSQL and I am evaluating it for use as a data
warehouse. I am really struggling to get a simple query to perform
well. I have put the appropriate indexes on the table (at least they
are appropriate from my use with several other RDBMS's). However, the
query doesn't perform well
