Hi all,
I would appreciate if somebody could help me understanding why the query
described below takes very different execution times to complete, almost
completely randomly.
I have two very "simple" tables, A and B:
CREATE TABLE A (
a1 varchar(10) NULL,
a2 varchar(10) NULL,
v int4 NULL
);
CREATE
erval 5s
wal_segment_size 16MB
wal_sender_timeout 1min
wal_skip_threshold 2MB
wal_sync_method fdatasync
wal_writer_delay 200ms
wal_writer_flush_after 1MB
work_mem 800MB
xmlbinary base64
xmloption content
zero_damaged_pages off
Again, thanks a lot for the time you spent on my messages.
Best regards,
Fr
the first and second
execution is visible.
Also, from what I can see, the plans are different...
Il giorno mer 10 mar 2021 alle ore 09:27 Justin Pryzby
ha scritto:
> On Sat, Mar 06, 2021 at 10:40:00PM +0100, Francesco De Angelis wrote:
> > The problem is the following: the query can tak
ng how the
optimisation algorithm works and whether there is a way to disable it.
In this way I can try to better figure out what to do, in the future, in
case the data model cannot be re-arranged like in this case.
Thanks again.
Best regards,
Francesco De Angelis
Il giorno mer 10 mar 2021 alle ore
