Reputation
530
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
8 28
Impact
~52k people reached

  • 0 posts edited
  • 0 helpful flags
  • 50 votes cast
Mar
2
awarded  Popular Question
Jan
20
awarded  Popular Question
Jan
7
awarded  Notable Question
Oct
19
awarded  Popular Question
Oct
8
awarded  Notable Question
Oct
7
awarded  Popular Question
Oct
5
comment Deleting many rows on a live table in chunks - without locking for too long (PostgreSQL 9.3)
Thanks @Kassandry I cannot use that way of inserting delta rows into working table because the table I'm working on is being actively used for the information in it, including what I'm not deleting.
Oct
5
accepted Deleting many rows on a live table in chunks - without locking for too long (PostgreSQL 9.3)
Oct
5
comment Deleting many rows on a live table in chunks - without locking for too long (PostgreSQL 9.3)
@jjanes does the table get locked while pg is writing to log for the rollback - which it may be doing while evaluating the "where" statement and so would be writing to log for the ~20 million rows while locking the table. (This was the reason given to me for doing this).
Oct
2
asked Deleting many rows on a live table in chunks - without locking for too long (PostgreSQL 9.3)
Jul
27
awarded  Caucus
May
14
accepted PostgreSQL + PG_Monz (Zabbix) DB size too large > 1073741824
May
5
awarded  Popular Question
Apr
13
comment Downsides to using SQL 2012 Upgrade as opposed to a fresh install?
I'm just going to post this here (and it's something I'm dealing with as well after having upgraded my version of SQL server instead of doing a fresh install. It's worth a read: dba.stackexchange.com/questions/22402/… (Note speaking of answer by Bijan)
Apr
3
awarded  Popular Question
Mar
18
awarded  Popular Question
Jan
6
awarded  Notable Question
Jan
3
awarded  Yearling
Dec
22
awarded  Popular Question
Dec
20
awarded  Popular Question