On Wed, 2021-12-22 at 09:58 +, Chris Withers wrote:
> A year and a half later, now that version 14 is the latest available,
> I wonder if anything has changed with respect to gist index creation?
> Probably also worth asking: are there now different index types this
> application should be usin
Hi,
A year and a half later, now that version 14 is the latest
available, I wonder if anything has changed with respect to gist
index creation?
Probably also worth asking: are there now different index types
this application should be using?
cheers,
Chri
On 14/05/2020 21:31, Tom Lane wrote:
Chris Withers writes:
It has 4.1 million rows in it and while importing the data only
takes a couple of minutes, when I did a test load into the new
cluster, building the mkt_profile_period_col1_col4_col2_chan_excl
index for the e
> >
> >Hi Chris,
> >
> >This sounds like a candidate for pg_logical replicating from the
> >old to new system.
>
> Can you point me to a good guide as to how to easily set this up for
> one database and would work between pg 9.4 and pg 11.5?
>
> cheers,
>
> Chris
Hi Chris,
Here is on for 9.4 t
On 14/05/2020 21:16, k...@rice.edu wrote:
Hi Chris,
This sounds like a candidate for pg_logical replicating from the old to
new system.
Can you point me to a good guide as to how to easily set this up for one
database and would work between pg 9.4 and pg 11.5?
cheers,
Chris
Chris Withers writes:
> It has 4.1 million rows in it and while importing the data only
> takes a couple of minutes, when I did a test load into the new
> cluster, building the mkt_profile_period_col1_col4_col2_chan_excl
> index for the exclude constraint took 15 hours.
Do
Quoting Chris Withers :
Hi,
I'm upgrading a database from 9.4 to 11.5 by dumping from the old
cluster and loading into the new cluster.
The database is tiny: around 2.3G, but importing this table is
proving problematic:
Column | Type|Modifiers
.
Hi,
I'm upgrading a database from 9.4 to 11.5 by dumping from the old
cluster and loading into the new cluster.
The database is tiny: around 2.3G, but importing this table is
proving problematic:
Column | Type|Modifie
