Of course ! I'm an idiot ...
Thank you a lot !
A question : is it possible with Postgres to change the temp_tablespace only
for a session (or page) ?
I have a cron which takes a lot of memory. I would like to say to PostGreSql
to use this temp_tablespace only on this command and not affect my u
Hi,
Thank you a lot for your answer.
I've done that (create a tablespace in another HD with POSTGRES role + put
it as the main temp_tablespace in the conf).
But ... my command ~# df show me that all queries use the default tablespace
...
This was my commands (the directory is owned by postgre
The query is (unfortunately) generated by Doctrine 2 (Symfony 2).
We can’t change the query easily.
This is my config :
max_connections = 80
shared_buffers = 15GB
work_mem = 384MB
maintenance_work_mem = 1GB
#temp_buffers = 8MB
#temp_file_limit = -1
effective_cache_size = 44GB
If I put a temp_
Hi all,
We have a big database (more than 300 Gb) and we run a lot of queries each
minute.
However, once an hour, the (very complex) query writes A LOT on the disk
(more than 95 Gb !!!)
We have 64 Gb of RAM and this is our config :
And my error on the query is :
Do you know how to solve th
