如何给网站增加内链,广告公司微网站建设,成都私人做网站,什么用来编写网页生产环境针对大表的处理相对比较麻烦。
方案1、直接truncate#xff0c;可能会遇到系统卡主的情况#xff0c;因为truncate的过程中会对表进行加锁#xff0c;会导致数据不能正常的写入 方案2、创建一个同结构的表结构#xff0c;rename旧表#xff0c;不停业务rename表担…生产环境针对大表的处理相对比较麻烦。
方案1、直接truncate可能会遇到系统卡主的情况因为truncate的过程中会对表进行加锁会导致数据不能正常的写入 方案2、创建一个同结构的表结构rename旧表不停业务rename表担心会影响业务建议是先停止接口进程停止写入后再rename然后创建一个同样的表结构 方案3、批量删除数据后再truncate回收空间批量删除过程中会产生比较多的wal日志同时还要考虑主从复制的延迟但是稳妥不会影响系统卡死
以下通过ID字段分批删除数据示例
清理脚本如下$ cat del.sh
#!/bin/bash
#$1对应表名$2对应主键列$3对应一次删除多少行ipsql -h 127.0.0.1 -U postgres -d t1db -c select ceil(count(1)/${3}::float) from ${1} where created_at 2024-12-30 23:59:59
necho ${i} |awk -F {print $3}
c1
#echo ${n}
#echo echo ${i} |awk -F {print 一共需要执行,$3,次}
while [ $c -le $n ]
doecho dateecho 一共需要执行${n}次,当前执行第${c}次echo 一共需要执行${n}次,当前执行第${c}次 /home/postgres/deldata.txtreturnspsql -h 127.0.0.1 -U postgres -d t1db -c delete from ${1} where ${2} any (select ${2} from ${1} where created_at 2024-12-30 23:59:59 limit ${3} );echo datec$[ $c1 ]
done
清理日志记录
[postgresoradb ~]$ sh -x del.sh test_table id 10000psql -h 127.0.0.1 -U postgres -d t1db -c select ceil(count(1)/10000::float) from test_table where created_at \2024-12-30 23:59:59\i ceil
------48
(1 row)echo ceil ------ 48 (1 row)awk -F {print $3}n48c1[ 1 -le 48 ]dateecho Fri Jan 24 09:16:54 CST 2025
Fri Jan 24 09:16:54 CST 2025echo 一共需要执行48次,当前执行第1次
一共需要执行48次,当前执行第1次echo 一共需要执行48次,当前执行第1次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:54 CST 2025
Fri Jan 24 09:16:54 CST 2025c2[ 2 -le 48 ]dateecho Fri Jan 24 09:16:54 CST 2025
Fri Jan 24 09:16:54 CST 2025echo 一共需要执行48次,当前执行第2次
一共需要执行48次,当前执行第2次echo 一共需要执行48次,当前执行第2次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:54 CST 2025
Fri Jan 24 09:16:54 CST 2025c3[ 3 -le 48 ]dateecho Fri Jan 24 09:16:54 CST 2025
Fri Jan 24 09:16:54 CST 2025echo 一共需要执行48次,当前执行第3次
一共需要执行48次,当前执行第3次echo 一共需要执行48次,当前执行第3次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025c4[ 4 -le 48 ]dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025echo 一共需要执行48次,当前执行第4次
一共需要执行48次,当前执行第4次echo 一共需要执行48次,当前执行第4次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025c5[ 5 -le 48 ]dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025echo 一共需要执行48次,当前执行第5次
一共需要执行48次,当前执行第5次echo 一共需要执行48次,当前执行第5次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025c6[ 6 -le 48 ]dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025echo 一共需要执行48次,当前执行第6次
一共需要执行48次,当前执行第6次echo 一共需要执行48次,当前执行第6次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025c7[ 7 -le 48 ]dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025echo 一共需要执行48次,当前执行第7次
一共需要执行48次,当前执行第7次echo 一共需要执行48次,当前执行第7次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025c8[ 8 -le 48 ]dateecho Fri Jan 24 09:16:55 CST 2025
Fri Jan 24 09:16:55 CST 2025echo 一共需要执行48次,当前执行第8次
一共需要执行48次,当前执行第8次echo 一共需要执行48次,当前执行第8次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025c9[ 9 -le 48 ]dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025echo 一共需要执行48次,当前执行第9次
一共需要执行48次,当前执行第9次echo 一共需要执行48次,当前执行第9次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025c10[ 10 -le 48 ]dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025echo 一共需要执行48次,当前执行第10次
一共需要执行48次,当前执行第10次echo 一共需要执行48次,当前执行第10次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025c11[ 11 -le 48 ]dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025echo 一共需要执行48次,当前执行第11次
一共需要执行48次,当前执行第11次echo 一共需要执行48次,当前执行第11次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025c12[ 12 -le 48 ]dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025echo 一共需要执行48次,当前执行第12次
一共需要执行48次,当前执行第12次echo 一共需要执行48次,当前执行第12次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025c13[ 13 -le 48 ]dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025echo 一共需要执行48次,当前执行第13次
一共需要执行48次,当前执行第13次echo 一共需要执行48次,当前执行第13次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025c14[ 14 -le 48 ]dateecho Fri Jan 24 09:16:56 CST 2025
Fri Jan 24 09:16:56 CST 2025echo 一共需要执行48次,当前执行第14次
一共需要执行48次,当前执行第14次echo 一共需要执行48次,当前执行第14次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025c15[ 15 -le 48 ]dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025echo 一共需要执行48次,当前执行第15次
一共需要执行48次,当前执行第15次echo 一共需要执行48次,当前执行第15次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025c16[ 16 -le 48 ]dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025echo 一共需要执行48次,当前执行第16次
一共需要执行48次,当前执行第16次echo 一共需要执行48次,当前执行第16次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025c17[ 17 -le 48 ]dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025echo 一共需要执行48次,当前执行第17次
一共需要执行48次,当前执行第17次echo 一共需要执行48次,当前执行第17次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025c18[ 18 -le 48 ]dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025echo 一共需要执行48次,当前执行第18次
一共需要执行48次,当前执行第18次echo 一共需要执行48次,当前执行第18次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025c19[ 19 -le 48 ]dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025echo 一共需要执行48次,当前执行第19次
一共需要执行48次,当前执行第19次echo 一共需要执行48次,当前执行第19次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025c20[ 20 -le 48 ]dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025echo 一共需要执行48次,当前执行第20次
一共需要执行48次,当前执行第20次echo 一共需要执行48次,当前执行第20次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025c21[ 21 -le 48 ]dateecho Fri Jan 24 09:16:57 CST 2025
Fri Jan 24 09:16:57 CST 2025echo 一共需要执行48次,当前执行第21次
一共需要执行48次,当前执行第21次echo 一共需要执行48次,当前执行第21次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c22[ 22 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第22次
一共需要执行48次,当前执行第22次echo 一共需要执行48次,当前执行第22次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c23[ 23 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第23次
一共需要执行48次,当前执行第23次echo 一共需要执行48次,当前执行第23次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c24[ 24 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第24次
一共需要执行48次,当前执行第24次echo 一共需要执行48次,当前执行第24次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c25[ 25 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第25次
一共需要执行48次,当前执行第25次echo 一共需要执行48次,当前执行第25次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c26[ 26 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第26次
一共需要执行48次,当前执行第26次echo 一共需要执行48次,当前执行第26次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c27[ 27 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第27次
一共需要执行48次,当前执行第27次echo 一共需要执行48次,当前执行第27次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c28[ 28 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第28次
一共需要执行48次,当前执行第28次echo 一共需要执行48次,当前执行第28次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025c29[ 29 -le 48 ]dateecho Fri Jan 24 09:16:58 CST 2025
Fri Jan 24 09:16:58 CST 2025echo 一共需要执行48次,当前执行第29次
一共需要执行48次,当前执行第29次echo 一共需要执行48次,当前执行第29次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c30[ 30 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第30次
一共需要执行48次,当前执行第30次echo 一共需要执行48次,当前执行第30次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c31[ 31 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第31次
一共需要执行48次,当前执行第31次echo 一共需要执行48次,当前执行第31次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c32[ 32 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第32次
一共需要执行48次,当前执行第32次echo 一共需要执行48次,当前执行第32次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c33[ 33 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第33次
一共需要执行48次,当前执行第33次echo 一共需要执行48次,当前执行第33次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c34[ 34 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第34次
一共需要执行48次,当前执行第34次echo 一共需要执行48次,当前执行第34次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c35[ 35 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第35次
一共需要执行48次,当前执行第35次echo 一共需要执行48次,当前执行第35次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c36[ 36 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第36次
一共需要执行48次,当前执行第36次echo 一共需要执行48次,当前执行第36次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c37[ 37 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第37次
一共需要执行48次,当前执行第37次echo 一共需要执行48次,当前执行第37次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025c38[ 38 -le 48 ]dateecho Fri Jan 24 09:16:59 CST 2025
Fri Jan 24 09:16:59 CST 2025echo 一共需要执行48次,当前执行第38次
一共需要执行48次,当前执行第38次echo 一共需要执行48次,当前执行第38次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c39[ 39 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第39次
一共需要执行48次,当前执行第39次echo 一共需要执行48次,当前执行第39次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c40[ 40 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第40次
一共需要执行48次,当前执行第40次echo 一共需要执行48次,当前执行第40次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c41[ 41 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第41次
一共需要执行48次,当前执行第41次echo 一共需要执行48次,当前执行第41次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c42[ 42 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第42次
一共需要执行48次,当前执行第42次echo 一共需要执行48次,当前执行第42次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c43[ 43 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第43次
一共需要执行48次,当前执行第43次echo 一共需要执行48次,当前执行第43次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c44[ 44 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第44次
一共需要执行48次,当前执行第44次echo 一共需要执行48次,当前执行第44次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c45[ 45 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第45次
一共需要执行48次,当前执行第45次echo 一共需要执行48次,当前执行第45次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c46[ 46 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第46次
一共需要执行48次,当前执行第46次echo 一共需要执行48次,当前执行第46次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025c47[ 47 -le 48 ]dateecho Fri Jan 24 09:17:00 CST 2025
Fri Jan 24 09:17:00 CST 2025echo 一共需要执行48次,当前执行第47次
一共需要执行48次,当前执行第47次echo 一共需要执行48次,当前执行第47次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 10000dateecho Fri Jan 24 09:17:01 CST 2025
Fri Jan 24 09:17:01 CST 2025c48[ 48 -le 48 ]dateecho Fri Jan 24 09:17:01 CST 2025
Fri Jan 24 09:17:01 CST 2025echo 一共需要执行48次,当前执行第48次
一共需要执行48次,当前执行第48次echo 一共需要执行48次,当前执行第48次psql -h 127.0.0.1 -U postgres -d t1db -c delete from test_table where id any (select id from test_table where created_at \2024-12-30 23:59:59\ limit 10000 );returnsDELETE 1dateecho Fri Jan 24 09:17:01 CST 2025
Fri Jan 24 09:17:01 CST 2025c49[ 49 -le 48 ]
[postgresoradb ~]$
最后对表进行vacuum
t1db# vacuum full test_table;
VACUUM
