Re: primary key hash index

2018-01-02 Thread Magnus Hagander
On Tue, Jan 2, 2018 at 3:02 PM, Rick Otten wrote: > After reading this article about keys in relational databases, highlighted > on hacker news this morning: > https://begriffs.com/posts/2018-01-01-sql-keys-in-depth.html > > I keep pondering the performance chart, regarding uuid insert, shown > t

primary key hash index

2018-01-02 Thread Rick Otten
After reading this article about keys in relational databases, highlighted on hacker news this morning: https://begriffs.com/posts/2018-01-01-sql-keys-in-depth.html I keep pondering the performance chart, regarding uuid insert, shown towards the bottom of the article. I believe he was doing that

Re: Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04

2018-01-02 Thread Vasilis Ventirozos
You are not providing too much info, its unclear to me whats actually slow. If you can, try loading the data first and then create the indexes / constraints. that should be faster. > On 2 Jan 2018, at 15:27, Hans Braxmeier wrote: > > Hi, > > I try to restore a table on U16.04, but it's ten tim

Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu 16.04

2018-01-02 Thread Hans Braxmeier
Hi, I try to restore a table on U16.04, but it's ten times slower than on U14.04. This is the definition of the table: testdb=# \d photos_searchlog Table "public.photos_searchlog" Column | Type | Collation | Nullable | Default --+-