Re: [PERFORM] Trigger question

2004-01-19 Thread Neil Conway
Harald Fuchs <[EMAIL PROTECTED]> writes: > Does anyone know how to access the affected values for > statement-level triggers? I mean what the "old" and "new" > pseudo-records are for row-level triggers. Yeah, I didn't get around to implementing that. If anyone wants this feature, I'd encourage th

Re: [PERFORM] COUNT & Pagination

2004-01-19 Thread Neil Conway
"scott.marlowe" <[EMAIL PROTECTED]> writes: > Yes, previously run query should be faster, if it fits in kernel > cache. Or the PostgreSQL buffer cache. > Plus, the design of Postgresql is such that it would have to do a > LOT of cache checking to see if there were any updates to the > underlying