I am using a Pentaho process to access the database and select the appropriate
information to update the DB tables and records. I am trying to select the
previous subscription key in order to update the factable for any records that
have the previous key to have the current subscription key. Th
Tomas,
Thank you for your feedback. I am attaching the requested information. While
I do not think the query is necessarily inefficient, I believe a sequence scan
would be more efficient.
\d member_subscription_d
Table "public.member_subscription_d"
Thomas,
Thank you. I executed the query this morning after disabling the scan types.
I am including links to explain.depesz output for each of the three variations
that I executed.
indexscan and bitmapscan off: http://explain.depesz.com/s/sIx
seqscan and bitmapscan off: http://explain.depes
Thomas,
I would have to agree that the current results do indicate that. However, I
have run this explain analyze multiple times and the timing varies from about
4ms to 35ms using the Bitmap Heap Scan. Here is an explain plan from Thursday
of last week that shows about 21ms. Part of the issu
Tomas,
Thank you for the recommendation. In this case, The bitmap scan runs quite
quickly, however in production were data may or may not be cached and at higher
volumes I am trying to ensure the process will continue to execute efficiently
and reduce the impact of the process on other process
scan may not be as
efficient since 4 times the data returned in just a little more time using the
index scan.
Thank you,
James
-Original Message-
From: Tomas Vondra [mailto:t...@fuzzy.cz]
Sent: Monday, July 14, 2014 12:29 PM
To: Magers, James
Cc: Tomas Vondra; Thomas Kellerer; pgsql
