From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-hackers@postgresql.org
Subject: Re: WIP: multivariate statistics / proof of concept
Date: Sat, 15 Nov 2014 19:35:53 +0100
Message-ID: <54679D09.3010203@fuzzy.cz> (raw)
In-Reply-To: <747665527.663493.1416073781449.JavaMail.yahoo@jws100192.mail.ne1.yahoo.com>
References: <8106e11197849725375a933e1cc1409f.squirrel@2.emaily.eu>
<747665527.663493.1416073781449.JavaMail.yahoo@jws100192.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On 15.11.2014 18:49, Kevin Grittner
> If you eliminate the quals besides the zipcode column you get 61
> rows and it gets much stranger, with legal municipalities that are
> completely surrounded by Madison that the postal service would
> rather you didn't use in addressing your envelopes, but they have
> to deliver to anyway, and organizations inside Madison receiving
> enough mail to (literally) have their own zip code -- where the
> postal service allows the organization name as a deliverable
> "city".
>
> If you want to have your own fun with this data, you can download
> it here:
>
> http://federalgovernmentzipcodes.us/free-zipcode-database.csv
>
...
>
> I bet there are all sorts of correlation possibilities with, for
> example, latitude and longitude and other variables. With 81831
> rows and so many correlations among the columns, it might be a
> useful data set to test with.
Thanks for the link. I've been looking for a good dataset with such
data, and this one is by far the best one.
The current version of the patch supports only data types passed by
value (i.e. no varlena types - text, ), which means it's impossible to
build multivariate stats on some of the interesting columns (state,
city, ...).
I guess it's time to start working on removing this limitation.
Tomas
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
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-hackers@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: WIP: multivariate statistics / proof of concept
In-Reply-To: <54679D09.3010203@fuzzy.cz>
* 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