From: Ruben Rubio Rey <ruben@rentalia.com>
To: pgsql-performance@postgresql.org
Subject: Is good idea an array of 365 elements in a cell of a table, in order to perform searchs?
Date: Wed, 08 Mar 2006 15:28:36 +0100
Message-ID: <440EEA14.70606@rentalia.com> (raw)
Hi,
Im having a dude with a new inplementation in a web site.
The ojective is create a search as fast as possible. I have thought two
possibilities to do that:
I have several items. Those items has 1 or more of capacity. Each
capacity, has several dates (From 1 january to 10 of april, for
example). The dates covers 366 days, the current year, and they are
indeterminated ranges. Per each date, it has price per day, per week,
per15days and per month.
I have designed two possibilities:
First:
IdItem StartDate EndDate Capacity PricePerDay PricePerWeek*
PricePer15days* PricePerMonth*
1 1-1-2005 10-1-2005 2 100
90 85 80
1 11-1-2005 20-1-2005 2 105
94 83 82
1 21-1-2005 5-2-2005 4 405
394 283 182
2 ...
Right now arround 30.000 rows, in one year is spected to have 60.000 rows
* In order to compare right, all prices will be translated to days.
Example, PricePerWeek will have the Week Price / 7 and go on
Second
IdItem Capacity Days
Week 15Days Month Year
1 2 [Array of 365 values, one per day of
year] [ .Array. ] [ .Array. ] [ .Array. ] [ .Array. ]
^__ Each item of array its a price
Right now arround 2.500 rows. in one year is spected to have 5.000 rows
I have to compare prices or prices and dates or prices and dates and
capacity or capacity and prices
I have no experience working with arrays on a table. Is it fast?
Witch one do u think will have better performance?
Any good idea?
I hope this is enouth information.
Thanks in advance,
Ruben Rubio Rey
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: ruben@rentalia.com
Subject: Re: Is good idea an array of 365 elements in a cell of a table, in order to perform searchs?
In-Reply-To: <440EEA14.70606@rentalia.com>
* 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