On Thu, Oct 12, 2017 at 11:50 PM, Tom Lane wrote:
> Ants Aasma writes:
>> I stumbled upon a severe row count underestimation that confusingly
>> went away when two inner joins in the from clause were reordered.
>
> Hm, looks more like an overestimate in this example, but anyway ...
>
>> Does anyb
Ants Aasma writes:
> I stumbled upon a severe row count underestimation that confusingly
> went away when two inner joins in the from clause were reordered.
Hm, looks more like an overestimate in this example, but anyway ...
> Does anybody have any idea what is going on here?
set_joinrel_size_e
Hi,
I've faced a problem that a query without limit works much faster than with
one. Steps to reproduce
create extension pg_trgm;
create table t (id serial, val text, constraint t_pk primary key (id));
insert into t (val) select (random() * 100)::text from generate_series(1,
100);
create inde
ROS Didier wrote:
> I would like your advice and recommendation about the
> following infrastructure problem :
> What is the best way to optimize synchronization between an instance
> PostgreSQL on Windows 7 workstation and an Oracle 11gR2 database on linux
> RHEL ?
> Here are m
On Thu, Oct 12, 2017 at 5:13 AM, ROS Didier wrote:
> Hi
>
>I would like your advice and recommendation about the
> following infrastructure problem :
>
> What is the best way to optimize synchronization between an instance
> PostgreSQL on Windows 7 workstation and an Oracle 11gR2
Hi
I would like your advice and recommendation about the following
infrastructure problem :
What is the best way to optimize synchronization between an instance PostgreSQL
on Windows 7 workstation and an Oracle 11gR2 database on linux RHEL ?
Here are more detailed explanations
In