From: xchris <lyralyra@fastmail.fm>
To: pgsql-performance@postgresql.org
Subject: Lists or external TABLE?
Date: Fri, 30 Sep 2005 11:16:21 +0200
Message-ID: <1128071781.8112.32.camel@lyra> (raw)
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 - TABLE A has several fields (most of which are types defined by me)
for a total of 30-40 field (counting fields in my new types) and could
contain 5000 rows.
2 - TABLE A will be accessed several times with several views or query.
(many SELECT,few UPDATE)
Let's suppose i need to add an info about addresses (which includes
country,city,cap....etc 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?
I'm afraid that including those addresses will decrease performance in
doing many SELECT.
On the other side i'm afraid of doing JOIN with TABLE B.
What do you think?
Thank you!
xchris
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lyralyra@fastmail.fm
Subject: Re: Lists or external TABLE?
In-Reply-To: <1128071781.8112.32.camel@lyra>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox