Am 09.03.19 um 02:05 schrieb Joseph Dunleavy:
I am building a multi-tenant deployment with multiple database - 1
tenant per database.
I would like to be able to dedicate specific temp tablespace to
a specific database or user/schemas.
I understand how to define temp_tablespace in postgr
Hello,
We have recently upgraded our postgres cluster from 9.1 to 9.6. we are having
a difficult time creating our slave server. We have encountered the
"contrecord is requested" error which is preventing the slave from starting up.
We have recreated the slave , still no luck. Our master i
Try partitioning your table based on your device_id, that will give you a
considerable boost for queries which the where clause includes it. for 9.6
(that's the one your using right?) there's pg_partman for that kind of
thing, in this case you would partition by ranges, if the id's are
sequential i
Hi,
I noticed that a delete on a table with many partitions seems to be
using a lot of ram.
It seems to occur during the planing phase, as explain behaves the same
as the actual execution of the delete.
On the simplified test below for 4000 partitions it seems to be using
for a short time o
On Sun, 10 Mar 2019 at 10:20, wrote:
> I noticed that a delete on a table with many partitions seems to be
> using a lot of ram.
> Is this a known behaviour or related to my setup?
Yeah, It's known. There's a warning against what you're doing in
https://www.postgresql.org/docs/10/ddl-partitionin
