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