Postgres Pro
Downloads
Home   >   mailing lists

Re: Delete performance again - Mailing list pgsql-performance

From Marc Mamin
Subject Re: Delete performance again
Date
Msg-id CA896D7906BF224F8A6D74A1B7E54AB3039E8BEF@JENMAIL01.ad.intershop.net
Whole thread Raw
In response to Re: Delete performance again  ("Віталій Тимчишин" <tivv00@gmail.com>)
Responses Re: Delete performance again
List pgsql-performance
Tree view 
Hi,

Maybe you can try this syntax. I'm not sure, but it eventually perform better:


delete from company_alias USING comprm
where company_alias.company_id =comprm.id


Cheers,

Marc

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: 7.4 - basic tuning question
Next
From: "Greg Caulton"
Date:
Subject: cant get an index scan with a LIKE