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
--+-
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
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
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