> don't feel upset, that time I already learned how to control missile :)
Just curious ... how old does one need to be to be allowed
that? :) I was of "legal drinking age" then, btw ..
---(end of broadcast)---
TIP 9: In versions below 8.0, the plann
On Sat, 18 Feb 2006, Marc G. Fournier wrote:
On Fri, 17 Feb 2006, Joshua D. Drake wrote:
Anyone able to beat that?
Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
At Marc hands himself a foot gun... I was 9 years old in 82.
damn, now *I* feel old :)
don't feel u
On Fri, 17 Feb 2006, Joshua D. Drake wrote:
Anyone able to beat that?
Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
At Marc hands himself a foot gun... I was 9 years old in 82.
damn, now *I* feel old :)
Marc G. Fournier Hub.Org Networking Services
/me was 1 year old in 1982On 2/17/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
>> Anyone able to beat that?>> Sorry, I was still in Junior High in '82 :( Man, you are *old* :)>And Marc hands himself a foot gun... I was 9 years old in 82.
Joshua D. Drake>> > Marc G. Fournier Hub
Anyone able to beat that?
Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
At Marc hands himself a foot gun... I was 9 years old in 82.
Joshua D. Drake
Marc G. Fournier Hub.Org Networking Services
(http://www.hub.org)
Email: [EMAIL PROTECTED]
Anyone able to beat that?
Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
And Marc hands himself a foot gun... I was 9 years old in 82.
Joshua D. Drake
Marc G. Fournier Hub.Org Networking Services
(http://www.hub.org)
Email: [EMAIL PROTECTED]
On Fri, 17 Feb 2006, Michael Fuhr wrote:
On Fri, Feb 17, 2006 at 09:35:32PM -0400, Marc G. Fournier wrote:
Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
Anybody know some reasonable postgresql.conf settings for a system
that starts up with
Cass?
Memory Size?
'cuz I st
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Tom Lane) would
write:
> I said:
>> The oldest thing I can actually document at the moment
>
> After further digging, I found something older: conclusive proof that
> I was present at the invention of the smiley. I've been heard to asser
On Fri, Feb 17, 2006 at 09:35:32PM -0400, Marc G. Fournier wrote:
> Sorry, I was still in Junior High in '82 :( Man, you are *old* :)
Anybody know some reasonable postgresql.conf settings for a system
that starts up with
Cass?
Memory Size?
'cuz I still have one :-)
--
Michael Fuhr
--
On Fri, 17 Feb 2006, Tom Lane wrote:
I said:
The oldest thing I can actually document at the moment
After further digging, I found something older: conclusive proof that
I was present at the invention of the smiley. I've been heard to assert
that before, but apparently someone has actually m
I said:
> The oldest thing I can actually document at the moment
After further digging, I found something older: conclusive proof that
I was present at the invention of the smiley. I've been heard to assert
that before, but apparently someone has actually managed to unearth
archives that had bee
Bruce Momjian writes:
> Tom Lane wrote:
>> Bruce Momjian writes:
>>> My first post to Usenet was May 1991:
>>
>> Newbie ;-)
> OK, don't taunt us. What date do you have? :-)
Not sure, but I remember being netnews admin for CMU in '87.
(Grad student slave labor position, mind you, not prestigi
On Fri, 17 Feb 2006, Bruce Momjian wrote:
Joshua D. Drake wrote:
Bruce Momjian wrote:
I have updated my email signature because I think it is no longer
necessary to list contact information now that my home page has all that
information. (At the time I created it, email was becoming popular b
Tom Lane wrote:
> Bruce Momjian writes:
> > My first post to Usenet was May 1991:
>
> Newbie ;-)
OK, don't taunt us. What date do you have? :-)
--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com
+ If your life is a hard drive, Christ can be your backup. +
Bruce Momjian writes:
> My first post to Usenet was May 1991:
Newbie ;-)
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze is your friend
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/
What! Can't you embed an image in there too! :-)
You
Joshua D. Drake wrote:
> Bruce Momjian wrote:
> > I have updated my email signature because I think it is no longer
> > necessary to list contact information now that my home page has all that
> > information. (At the time I created it, email was becoming popular but
> > personal web sites were ra
On 2/17/06, Ragnar <[EMAIL PROTECTED]> wrote:
> Say again ?
> Let us say you have 1 billion rows, where the
> column in question contains strings like
> baaaaaa
> baaaaab
> baaaaac
> ...
> not necessarily in this order on disc of course
>
> The minimu
Christian Bird <[EMAIL PROTECTED]> writes:
> I'm a grad student doing some work correlating mailinglist activity
> with cvs activity for a datamining conference and I'm using postgres
> as one of the OSS projects under study. For most names of cvs
> committers, I've been able to determine what e-m
On Fri, 17 Feb 2006, Christian Bird wrote:
Hello,
I'm a grad student doing some work correlating mailinglist activity
with cvs activity for a datamining conference and I'm using postgres
as one of the OSS projects under study. For most names of cvs
committers, I've been able to determine what
Mark Lewis <[EMAIL PROTECTED]> writes:
> I think we're actually on the same page here; you're right that the
> constraint above ( f(a)==f(b) iff a==b ) can't be extended to data types
> with more than 32 bits of value space. But the constraint I listed was
> actually:
> if a==b then f(a)==f(b)
I
Hello,
I'm a grad student doing some work correlating mailinglist activity
with cvs activity for a datamining conference and I'm using postgres
as one of the OSS projects under study. For most names of cvs
committers, I've been able to determine what e-mail addresses they
used on this mailinglist
On fös, 2006-02-17 at 08:01 -0500, Ron wrote:
> At 04:24 AM 2/17/2006, Ragnar wrote:
> >On fös, 2006-02-17 at 01:20 -0500, Ron wrote:
> > >
> > > OK, so here's _a_ way (there are others) to obtain a mapping such that
> > > if a < b then f(a) < f (b) and
> > > if a == b then f(a) == f(b)
> >
> >
On Thu, 2006-02-16 at 21:33 -0800, David Lang wrote:
> > In SQL_ASCII, just take the first 4 characters (or 8, if using a 64-bit
> > sortKey as elsewhere suggested). The sorting key doesn't need to be a
> > one-to-one mapping.
>
> that would violate your second contraint ( f(a)==f(b) iff (a==b) )
Ron wrote:
I assume we have such?
You could look at the Sample Databases project on pgfoundry:
http://pgfoundry.org/projects/dbsamples/
Best Regards,
Michael Paesold
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
On Fri, 2006-02-17 at 10:51, Ron wrote:
> I assume we have such?
Depends on what you wanna do.
For transactional systems, look at some of the stuff OSDL has done.
For large geospatial type stuff, the government is a good source, like
www.usgs.gov or the fcc transmitter database.
There are other
I assume we have such?
Ron
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
At 10:53 AM 2/17/2006, Martijn van Oosterhout wrote:
On Fri, Feb 17, 2006 at 08:23:40AM -0500, Ron wrote:
> >For this mapping, you need a full table sort.
> One physical IO pass should be all that's needed. However, let's
> pretend you are correct and that we do need to sort the table to get
> t
Bruce Momjian wrote:
I have updated my email signature because I think it is no longer
necessary to list contact information now that my home page has all that
information. (At the time I created it, email was becoming popular but
personal web sites were rare.)
Also, I wanted to mention that I
On Fri, Feb 17, 2006 at 08:18:41AM -0800, Scott Lamb wrote:
> On Feb 16, 2006, at 2:17 PM, Mark Lewis wrote:
> >Data types which could probably provide a useful function for f
> >would be
> >int2, int4, oid, and possibly int8 and text (at least for SQL_ASCII).
>
> ...and with some work, floats (
On Feb 16, 2006, at 2:17 PM, Mark Lewis wrote:Data types which could probably provide a useful function for f would be int2, int4, oid, and possibly int8 and text (at least for SQL_ASCII). ...and with some work, floats (I think just the exponent would work, if nothing else). bytea. Probably just ab
On Fri, Feb 17, 2006 at 08:23:40AM -0500, Ron wrote:
> >For this mapping, you need a full table sort.
> One physical IO pass should be all that's needed. However, let's
> pretend you are correct and that we do need to sort the table to get
> the key mapping. Even so, we would only need to do it
I have updated my email signature because I think it is no longer
necessary to list contact information now that my home page has all that
information. (At the time I created it, email was becoming popular but
personal web sites were rare.)
Also, I wanted to mention that I work for SRA OSS more p
At 05:19 AM 2/17/2006, Markus Schaber wrote:
Hi, Ron,
Ron schrieb:
> OK, so here's _a_ way (there are others) to obtain a mapping such that
> if a < b then f(a) < f (b) and
> if a == b then f(a) == f(b)
>
> Pretend each row is a integer of row size (so a 2KB row becomes a 16Kb
> integer; a 4K
At 04:24 AM 2/17/2006, Ragnar wrote:
On fös, 2006-02-17 at 01:20 -0500, Ron wrote:
>
> OK, so here's _a_ way (there are others) to obtain a mapping such that
> if a < b then f(a) < f (b) and
> if a == b then f(a) == f(b)
> By scanning the table once, we can map say 001h (Hex used to ease
Hi, Ron,
Ron schrieb:
> OK, so here's _a_ way (there are others) to obtain a mapping such that
> if a < b then f(a) < f (b) and
> if a == b then f(a) == f(b)
>
> Pretend each row is a integer of row size (so a 2KB row becomes a 16Kb
> integer; a 4KB row becomes a 32Kb integer; etc)
> Since eve
Hi, David,
David Lang schrieb:
>> In SQL_ASCII, just take the first 4 characters (or 8, if using a 64-bit
>> sortKey as elsewhere suggested). The sorting key doesn't need to be a
>> one-to-one mapping.
> that would violate your second contraint ( f(a)==f(b) iff (a==b) )
no, it doesn't.
When b
On Fri, Feb 17, 2006 at 09:18:39AM +0100, Jens-Wolfhard Schicke wrote:
> What I think as the biggest problem is the digit representation necessary
> for Radix-Sort in cases of locales which sort without looking at spaces. I
> assume that would be hard to implement. The same goes for the proposed
--On Donnerstag, Februar 16, 2006 10:39:45 -0800 Dann Corbit
<[EMAIL PROTECTED]> wrote:
He refers to counting sort and radix sort (which comes in most
significant digit and least significant digit format). These are also
called distribution (as opposed to comparison) sorts.
These sorts are O(
39 matches
Mail list logo
