On Sun, Jun 30, 2019 at 3:29 PM Mohsen Bande wrote:
> I've created a new database, and started to copy current data into it. it
> seems to work.
> it seems that the problem relates to upgrade process of database catalogs
> from Beta1 to Beta2.
> if the problem persists, it wil
Peter Geoghegan wrote:
> On Thu, Jun 27, 2019 at 1:28 AM Mohsen Bande
> wrote:
> > i have a working database in PG 12 Beta 1. today i upgraded it to Beta
> 2. everything goes fine and server is up and running. but trying to
> INSERT/UPDATE anything, server crashes:
>
> Is it
i have a working database in PG 12 Beta 1. today i upgraded it to Beta 2.
everything goes fine and server is up and running. but trying to
INSERT/UPDATE anything, server crashes:
=# select id from user where id=0;
id
0(1 row)=# UPDATE user SET is_deleted = true WHERE id = 0;
psql: server c
Hi all,
I have a user table with ~8M records, with different type of fields b-tree
indexed.
by investigating index sizes, i found two strange things:
1- all index sizes are almost the same, regardless of field type (boolean,
string, bigint)
2 - all of them are much bigger that my expectation, e.g.
