Tom Lane-2 wrote
> PG doesn't try to estimate inequalities exactly, because it usually
> doesn't make enough of a difference to matter. Currently we don't
> even bother to distinguish say ">" from ">=" for estimation purposes,
> though certainly we would need to in order to deal with zero-width ra
=?koi8-r?B?/cXLyc4g8dLP08zB1w==?= writes:
> I've noticed strange row count estimations in BETWEEN predicate:
> EXPLAIN
> SELECT *
> FROM t1
> WHERE f1 = 42;
> -->> Bitmap Heap Scan on t1 (cost=203.07..28792.94 rows=10662 width=24)
>
> EXPLAIN
> SELECT *
> FROM t1
> WHERE f1 BETWEEN 42 A
El 13/06/15 a las 10:58, Mephysto escribió:
Thank you Holger,
any suggestions?
I'm using the same settings used for ssh connection to vm, and these
work correctly
Bye.
Meph
Hello
Are PosgreSQL listening in the IP of the machine with (for example):
listen_addresses = '*'# wh
Hi.
I've noticed strange row count estimations in BETWEEN predicate:
--
-- I'm using this:
SELECT version();
-->> PostgreSQL 9.4.1, compiled by Visual C++ build 1800, 32-bit
-- Prepare table:
CREATE TABLE t1 (
id bigserial NOT NULL,
f0 bigint NOT NULL,
f1 bigint NOT NULL,
CONSTRAINT t1_pkey PR
Thank you Holger,
any suggestions?
I'm using the same settings used for ssh connection to vm, and these work
correctly
Bye.
Meph
Il 12/giu/2015 17:37, ha scritto:
> Melvin Davidson wrote on Friday, June 12, 2015 5:10 PM:
>
> > To allow external ip access, you need to specifcally add the ip
