| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Reducing the overhead of NUMERIC data |
| Date: | 2005-11-02 08:48:25 |
| Message-ID: | 1130921305.8300.1720.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Tue, 2005-11-01 at 18:15 -0500, Tom Lane wrote:
> Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> > Anybody like to work out a piece of SQL to perform data profiling and
> > derive the distribution of values with trailing zeroes?
>
> Don't forget leading zeroes. And all-zero (we omit digits entirely in
> that case). I don't think you can claim that zero isn't a common case.
The question is: how common?
For INTEGERs I would accept that many are often zero. For NUMERIC, these
are seldom exactly zero, IMHO.
This is one of those issues where we need to run tests and take input.
We cannot decide this sort of thing just by debate alone. So, I'll leave
this as a less potentially fruitful line of enquiry.
Best Regards, Simon Riggs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2005-11-02 12:03:57 | Re: slru.c race condition (was Re: TRAP: FailedAssertion("!((itemid)->lp_flags |
| Previous Message | Kevin Grittner | 2005-11-02 06:50:22 | Re: pg_restore [archiver] file offset in dump file |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2005-11-02 12:03:57 | Re: slru.c race condition (was Re: TRAP: FailedAssertion("!((itemid)->lp_flags |
| Previous Message | Tom Lane | 2005-11-02 04:45:12 | Re: slru.c race condition (was Re: TRAP: FailedAssertion("!((itemid)->lp_flags |