On 6/27/20 10:52 AM, Matthias Apitz wrote:
El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió:
2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task
2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table
"testdump.public.idm_tasktab"
> I am not sure whether I am misinterpreting something, or if it is a bug
> (probably former) however, when using partitions, are not
> n_distinct_inherited supposed to propagate to the child partitions? It does
> not seem to do so. (Yes, I run Analyze after setting the variable) I had to
> set
On the topic of n_distinct.
I am not sure whether I am misinterpreting something, or if it is a bug
(probably former) however, when using partitions, are not n_distinct_inherited
supposed to propagate to the child partitions? It does not seem to do so. (Yes,
I run Analyze after setting the vari
Matthias Apitz writes:
> El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió:
>>> 2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task
>>> 2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table
>>> "testdump.public.idm_tasktab"
>> From
El día Samstag, Juni 27, 2020 a las 07:21:21 -0700, Adrian Klaver escribió:
> > 2020-06-27 10:23:02.631 CEST [18302] ERROR: canceling autovacuum task
> > 2020-06-27 10:23:02.631 CEST [18302] CONTEXT: automatic analyze of table
> > "testdump.public.idm_tasktab"
> >
> From what I understand they
Samuel Williams writes:
> Here is a short example:
> https://gist.github.com/ioquatix/2f08f78699418f65971035785c80cf18
> It makes 10 queries in one "PQsendQuery" and sets single row mode. But
> all the results come back at once as shown by the timestamps.
That looks to be less about what libpq wi
On 6/27/20 1:37 AM, Matthias Apitz wrote:
El día Donnerstag, Juni 25, 2020 a las 04:25:00 -0400, Tom Lane escribió:
Matthias Apitz writes:
On Thursday, 25 June 2020 21:41:54 CEST, Tom Lane
wrote:
regardless of the exact details, it seems like the most likely theory
about what is happening i
El día Donnerstag, Juni 25, 2020 a las 04:25:00 -0400, Tom Lane escribió:
> Matthias Apitz writes:
> > On Thursday, 25 June 2020 21:41:54 CEST, Tom Lane
> > wrote:
> >> regardless of the exact details, it seems like the most likely theory
> >> about what is happening is that the dump file is co
Here is a short example:
https://gist.github.com/ioquatix/2f08f78699418f65971035785c80cf18
It makes 10 queries in one "PQsendQuery" and sets single row mode. But
all the results come back at once as shown by the timestamps.
Next I'm planning to investigate streaming large recordsets to see if
it
