Re: some points for FAQ

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: some points for FAQ
Date: 2007-10-10 05:04:56
Message-ID: 162867790710092204v7dcff627v4a65c7cd2c59a5b3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
> OK, how do we even explain this idea in the FAQ. It pulls 20 random
> values from 1 to 10000? That seems pretty hard to code to me. Where do
> you get the 10000 number from? How do you know you will hit a match in
> 20 tries?
>

Number 10000 you have to store in application .. it's magic constant.
It similar our statistics. And sometimes you have to actualise it.
This is stochastic methods, so it's possible so it doesn't return any
value, and you have to repeat it. Using this method expect knowledge
about generating random numbers. This method is far to ideal, but on
databases with big traffic only this is usable.

Pavel

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2007-10-10 05:44:00 Re: Skytools committed without hackers discussion/review
Previous Message Brendan Jurd 2007-10-10 04:57:01 quote_literal with NULL