this
happens.
[cid:imagec5a681.PNG@530b3f9e.479048e5]
Kristian Ejvind
Linux System Administrator
IT Operations | Technical Operations
Resurs Bank
Ekslingan 8
Box 222 09, SE-25467 Helsingborg
Mobil: +46 728571483
Växel: +46 42 38 20 00
E-post: kristian.ejv...@resurs.se<mailto:kristian.
0 | 0 | 0
(7 rows)
Time: 2.857 ms
Time: 0.162 ms
Regards
Kristian
[cid:imageec8d1d.PNG@91acb18e.4997dc74]
Kristian Ejvind
Linux System Administrator
IT Operations | Technical Operations
Resurs Bank
Ekslingan 8
Box 222 09, SE-25467 Helsingborg
Mobil: +46 728
Kristian
?On 2019-07-23, 16:33, "Kenneth Marshall" wrote:
On Tue, Jul 23, 2019 at 01:41:53PM +, Kristian Ejvind wrote:
> Thanks Kenneth. In fact we've already partitioned the largest history*
and trends* tables
> and that has been running fine for a year. Perform
cleaned up by dropping partitions instead everything worked much,
much, much better. When we started using partitioning, we used the
old inheiritance style. Now you can use the native partitioning.
Regards,
Ken
Resurs Bank AB
Kristian Ejvind
Linux System Administrator
IT
++-+-++-+---+--+-
--+---+---
(0 rows)
All these queries execute well below 1 ms, using indexes.
Let's delete one row. See explain results here:
https://explain.depesz.com/s/aycf . 5 seconds to delete a single ro