Home > mailing lists

Performance with Boolean datatype - Mailing list pgsql-general

From	devi
Subject	Performance with Boolean datatype
Date	April 1, 2009 10:39:12
Msg-id	F9C01A8D271945F298A011ADEF75468D@Devi Whole thread Raw
List	pgsql-general

Hi,

I would like to know is there any perf differences between

case 1: when i use ( .......where validate=FALSE) [validate as Boolean]

case 2: when i use ( ....... where validate=1) [validate as int(1)]

Thanks

DEVI.G

From: Chris.Ellis@shropshire.gov.uk
Date: 01 April 2009, 08:23:06
Subject: Re: Server Performance

From: ries van Twisk
Date: 01 April 2009, 12:21:38
Subject: Need help with : org.postgresql.util.PSQLException : ERROR: deadlock detected