I know nothing about running PostgreSQL in windows, but slowness in
establishing connections on a particular host that isn't replicable elsewhere
is very often the result of something doing reverse DNS lookups on a server
when accepting new connections. Perhaps the client you are connecting from
I have been running Postgresql 9.2 under VMWare/WinXP-32bit, and it works
really well.
I finally decided to move to my host - Win 7 Ultimate 64bit - and installed
the 64bit version with same config as the 32bit. When I tried to run it,
it was extremely slow connecting to a 4 table database I use
On Sat, Dec 29, 2012 at 5:57 PM, Stefan Andreatta
wrote:
> n*d / (n - f1 + f1*n/N)
>
> where f1 is the number of values that occurred only once in the sample. n is
> the number of rows sampled, d the number of distincts found and N the total
> number of rows in the table.
>
...
>
> When the numbe
On 12/29/2012 10:57 PM, Peter Geoghegan wrote:
On 29 December 2012 20:57, Stefan Andreatta wrote:
Now, the 2005 discussion goes into great detail on the advantages and
disadvantages of this algorithm, particularly when using small sample sizes,
and several alternatives are discussed. I do not k
