From: Greg Spiegelberg <gspiegelberg@cranel.com>
To: Dror Matalon <dror@zapatec.com>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Compare rows
Date: Wed, 08 Oct 2003 15:07:30 -0400
Message-ID: <3F846072.3090700@cranel.com> (raw)
In-Reply-To: <20031008185527.GK2979@rlx11.zapatec.com>
References: <3F841A28.8060504@cranel.com>
<200310080901.45093.josh@agliodbs.com>
<3F843AFD.3020700@cranel.com>
<3F843F73.6030302@joeconway.com>
<3F8459FA.1030008@cranel.com>
<20031008185527.GK2979@rlx11.zapatec.com>
Dror,
I gave this some serious thought at first. I only deal with
int8, numeric(24,12) and varchar(32) columns which I could
reduce to 3 different tables. Problem was going from 1700-3000
rows to around 300,000-1,000,000 rows per system per day that
is sending data to our database.
BTW, the int8 and numeric(24,12) are for future expansion.
I hate limits.
Greg
Dror Matalon wrote:
> It's still not quite clear what you're trying to do. Many people's gut
> reaction is that you're doing something strange with so many columns in
> a table.
>
> Using your example, a different approach might be to do this instead:
>
> Day | Name | Value
> ------+-------------+-----------
> Oct 1 | OS | Solaris 5.8
> Oct 1 | Patch | 108528-12
> Oct 3 | Patch | 108528-13
>
>
> You end up with lots more rows, fewer columns, but it might be
> harder to query the table. On the other hand, queries should run quite
> fast, since it's a much more "normal" table.
>
> But without knowing more, and seeing what the other columns look like,
> it's hard to tell.
>
> Dror
--
Greg Spiegelberg
Sr. Product Development Engineer
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: gspiegelberg@Cranel.com
Cranel. Technology. Integrity. Focus.
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: gspiegelberg@cranel.com, dror@zapatec.com
Subject: Re: Compare rows
In-Reply-To: <3F846072.3090700@cranel.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