Jeff, Robert, I am still working on the "low cardinality" info you requested.
Please bear with me.
In the meantime, have the following question:
Are there known "scenarios" where certain types of SQL queries perform worse in
PG
than they do in ORacle ?
For example, I have observed some discuss
lever workarounds to boosting performance involving
low queries on low cardinality columns ? i.e avoiding a full table scan ?
VK
From: Greg Stark
To: Vikul Khosla
Cc: pgsql-performance@postgresql.org
Sent: Fri, October 16, 2009 8:27:15 PM
Subject: Re: [PERFORM] In
lever workarounds to boosting performance involving
low queries on low cardinality columns ? i.e avoiding a full table scan ?
VK
From: Greg Stark
To: Vikul Khosla
Cc: pgsql-performance@postgresql.org
Sent: Fri, October 16, 2009 8:27:15 PM
Subject: Re: [PERFORM] In
Folks,
We have just migrated from Oracle to PG.
We have a database that has approx 3 mil rows and one of the columns has a
cardinality
of only 0.1% (3000 unique values).
We have to issue several queries that use this low cardinality column in a
WHERE clause
as well as see this column particip
