Re: [PERFORM] Lists or external TABLE?

2005-10-04 Thread Jim C. Nasby
On Fri, Sep 30, 2005 at 10:34:35AM +0100, Richard Huxton wrote: > xchris wrote: > > > >Let's suppose i need to add an info about addresses (which includes > >country,city,capetc etc). > >Addresses can vary from 1 to 20 entries.. > > > >Talking about performance is it better to include a list of

Re: [PERFORM] Lists or external TABLE?

2005-09-30 Thread Richard Huxton
xchris wrote: Let's suppose i need to add an info about addresses (which includes country,city,capetc etc). Addresses can vary from 1 to 20 entries.. Talking about performance is it better to include a list of addresses in TABLE A or is it better to create an external TABLE B? Don't optim

[PERFORM] Lists or external TABLE?

2005-09-30 Thread xchris
Hi list, i'm a postgres noob and before designing a new Database Schema i would like to ask you a simple question because preformance will be a critical point. My question regards performance comparison between a Table which includes a list or a Table without list and with an external table. 1 -