Hello,
> Please run EXPLAIN ANALYZE on the query and post that, it's hard to
say
> what's wrong from just the query plan, without knowing where the time
is
> actually spent. And the schema of the tables involved, and any indexes
> on them. (see also http://wiki.postgresql.org/wiki/SlowQueryQuestions)
The details of the tables and indexes may take a bit of effort to explain.
Will do that.
I remembered that a similar query took about 90 seconds
to run a few days ago. Now that is also taking a few minutes to run. In
between, we made some changes to a few tables (the tables are about 9-10
GB each). This was to fix some issue in conversion from CHARACTER VARYING
to BOOLEAN on PostgreSQL (some columns in Oracle were of type VARCHAR,
to store BOOLEAN values. We changed that to BOOLEAN in PostgreSQL to resolve
some issues at the jdbc level). The alters were of similar type -
ALTER TABLE cusdynatr ALTER tstflg TYPE
boolean USING CASE WHEN tstflg = '1' THEN true WHEN tstflg = '0' then FALSE
END;
Do such alters result in fragmentation at storage
level?
Regards,
Jayadevan
DISCLAIMER:
"The information in this e-mail and any attachment is intended only
for the person to whom it is addressed and may contain confidential and/or
privileged material. If you have received this e-mail in error, kindly
contact the sender and destroy all copies of the original communication.
IBS makes no warranty, express or implied, nor guarantees the accuracy,
adequacy or completeness of the information contained in this email or
any attachment and is not liable for any errors, defects, omissions, viruses
or for resultant loss or damage, if any, direct or indirect."
