On Tue, 2019-07-23 at 19:24 -0400, Tom Lane wrote:
> [ hey guys, please trim your replies ]
sorry
>
> Experimenting, however, I see that that only works as intended if
> I use v11 pg_restore. I can replicate your result if I use v10
> pg_restore. So ... don't do that.
Thanks very much!
I've s
On Tue, 2019-07-23 at 16:04 -0700, Adrian Klaver wrote:
> On 7/23/19 3:58 PM, Sergey Koposov wrote:
> >
> > On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote:
> > >
> > > On 7/23/19 3:42 PM, Sergey Koposov wrote:
> > > >
> > > >
On Tue, 2019-07-23 at 15:52 -0700, Adrian Klaver wrote:
> On 7/23/19 3:42 PM, Sergey Koposov wrote:
> >
> > On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote:
> > >
> > > On 7/23/19 3:23 PM, Sergey Koposov wrote:
> > > >
> > > >
On Tue, 2019-07-23 at 15:37 -0700, Adrian Klaver wrote:
> On 7/23/19 3:23 PM, Sergey Koposov wrote:
> >
> > On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote:
> > >
> > > On 7/23/19 3:19 PM, Sergey Koposov wrote:
> > > >
> > > >
On Tue, 2019-07-23 at 15:21 -0700, Adrian Klaver wrote:
> On 7/23/19 3:19 PM, Sergey Koposov wrote:
> >
> > Hi,
> >
> > I'm trying to copy a schema from one PG database (ver 11) to PG 10.
> > Previously the first database version was 9.6 and the way I di
Hi,
I'm trying to copy a schema from one PG database (ver 11) to PG 10.
Previously the first database version was 9.6 and the way I did the copying was
ssh -o Compression=no user@host '/opt/pgsql/bin/pg_dump --no-tablespaces -n
schemaname -Fc -U dbadmin dbname' | pg_restore -U dbadmin -h lo
On Thu, 2019-05-02 at 01:05 -0400, Tom Lane wrote:
> Sergey Koposov writes:
> >
> > On Thu, 2019-05-02 at 00:36 -0400, Tom Lane wrote:
> > >
> > > What sort of selectivity estimator have you got attached to that custom
> > > operator?
> >
On Thu, 2019-05-02 at 00:36 -0400, Tom Lane wrote:
> Sergey Koposov writes:
> >
> > I'm currently trying to understand the expected row counts for a query
> > involving a nested loop join and bitmap index scan
> > on the functional index and a custom oper
Hi,
I'm currently trying to understand the expected row counts for a query
involving a nested loop join and bitmap index scan
on the functional index and a custom operator. And the numbers that I see don't
make sense to me currently. Hopefully
somebody here can shed some light on it, or confi
