I think instead of performing an INSERT you call a stored proc that does the ins... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		const_cast 69 days ago \| parent \| context \| favorite \| on: Postgres LISTEN/NOTIFY does not scale I think instead of performing an INSERT you call a stored proc that does the insert and some extra stuff.

shivasaxena 68 days ago [–]

Yes, we already have all of our business logic in postgres functions(create_order, create_partial_payment etc).

Doing the extra work in stored procedures is noticeably faster than relying on triggers.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact