[GENERAL] Trouble running nested select - Join query

2014-05-25 Thread RUSHI KAW
Hi, I have been working with Postgresxc 1.1 on a cluster, each cluster compute node having 48GB RAM. I have instantiated the coordinator on one of the compute nodes and have 4 datanodes (2+2) running on two other compute nodes.  I have been trying to run the  following query which is a select on

[GENERAL] "Tuple not found error" during Index creation

2013-12-09 Thread RUSHI KAW
that.  So, I wanted to ask if this is the only workaround for this error, turning off the Autovacuum during index creation and then restarting the process once Indexes have been created or is there something else one can do? Thank you. Regards, Rushi Kaw