All Questions
Tagged with postgresql-9.2 delete
2 questions
7
votes
3
answers
10k
views
Delete data from a billion row table based on where clause
I need to delete about 400 million rows from a 1.3 billion row table based on an indexed date field.
The table is about 800 GB in size.
What is the most efficient way to delete the data without ...
- 342
116
votes
7
answers
173k
views
Very slow DELETE in PostgreSQL, workaround?
I have a database on PostgreSQL 9.2 that has a main schema with around 70 tables and a variable number of identically structured per-client schemas of 30 tables each. The client schemas have foreign ...
- 1,262