Hello,
I have a massive table in my database, about 1.5TB and around 3.5 billion
rows. (that is one partition of massive table). When I try to do backup,
just on this one big table, after a while I get following error:
pg_dump: Dumping the contents of table "ta_low" failed: PQgetResult()
fa
I have a table t1 with a primary key column pkey, and a table t2, with a
primary key column pkey. Is there a way to make the following delete use the
indexes?
delete from t1 where pkey in (select pkey from t2);
NOTICE: QUERY PLAN:
Seq Scan on t1 (cost=0.00..6616238.99 rows=660239 width=6)
S
