Re: [PERFORM] What's the cost of a few extra columns?

2005-10-10 Thread Announce
oduction_info whenever a row is inserted into productions? On Sun, Oct 09, 2005 at 10:03:33PM -0500, Announce wrote: ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[PERFORM] What's the cost of a few extra columns?

2005-10-09 Thread Announce
What's goin on pg-people? I have a table PRODUCTIONS that is central to the DB and ties a lot of other information together: PRODUCTIONS (table) -- prod_id primary key type_id foreign key level_idforeign key tour_id foreign k

[PERFORM] int2 vs int4 in Postgres

2005-09-26 Thread Announce
Is there an performance benefit to using int2 (instead of int4) in cases where i know i will be well within its numeric range? I want to conserve storage space and gain speed anywhere i can, but i know some apps simply end up casting 2byte data to 4byte (like Java int/short). These int2 values wil