Re: Extremely slow count (simple query, with index)

2019-08-22 Thread Ravikumar Reddy
Dear , Create the below indexes and try it !!! create index ind_ subscriptions_ project_id on "subscriptions"("project_id") Where "project_id"= 1 create index ind_ subscriptions_ trashed_at on "subscriptions"(" trashed_at ") Where "trashed_at" is null On Thu, Aug 22, 2019 at 6:36 PM Marc

Re: time taking deletion on large tables

2020-12-03 Thread Ravikumar Reddy
Hi Atul, Please try the code below. Execute all the statements in one transaction. select * into new_table from old_table where type = 'abcz'; truncate table old_table; inesrt into old_table select * from new_table; On Thu, Dec 3, 2020 at 8:16 PM Atul Kumar wrote: > Hi, > > The feed_post