Tom,
I will lower the sort_mem and see what happens. :-)
I agree that we probably pushed the limits of a vacuum full with the
size table we had and the large percentage of change in the table. We
did NOT run any vacuum jobs during the update process, that my have
helped to allow the updates t
Sean Shanny <[EMAIL PROTECTED]> writes:
> sort_mem = 64000# min 64, size in KB
You might want to lower that; a complex query could easily use several
times sort_mem. Whether this is the immediate source of your problem
with the other query is hard to tell.
> vacuum_mem = 32767
From postgresql.conf:
# - Memory -
shared_buffers = 1 # min 16, at least max_connections*2,
8KB each
sort_mem = 64000# min 64, size in KB
vacuum_mem = 32767 # min 1024, size in KB
The ulimit is set to unlimited as far as I can tell.
--sean
Tom Lane wr
Fernando Schapachnik <[EMAIL PROTECTED]> writes:
> Take a look at datasize: your processes are allowed a maximum of 512 Mb RAM.
> Read the handbook to find out how to reconfigure your kernel and the limits
> (and/or ulimit) man page to tweak the values for individual processes.
512Mb does not seem
Sean Shanny <[EMAIL PROTECTED]> writes:
> Does anyone have an explanation as to why this might occur?
What have you got vacuum_mem set to? Also, what ulimit settings is the
postmaster running under? (I'm wondering exactly how large the backend
process has grown when it gets the failure.)
Take a look at datasize: your processes are allowed a maximum of 512 Mb RAM.
Read the handbook to find out how to reconfigure your kernel and the limits
(and/or ulimit) man page to tweak the values for individual processes.
Good luck!
Fernando.
En un mensaje anterior, Sean Shanny escribió:
> lim
Is your system using full RAM? Ie, what does limits -a show?
Regards.
Fernando.
En un mensaje anterior, Sean Shanny escribió:
> To all,
>
> The facts:
>
> PostgreSQL 7.4.0 running on BSD 5.1 on Dell 2650 with 4GB RAM, 5 SCSI
> drives in hardware RAID 0 configuration. Database size with inde
To all,
The facts:
PostgreSQL 7.4.0 running on BSD 5.1 on Dell 2650 with 4GB RAM, 5 SCSI
drives in hardware RAID 0 configuration. Database size with indexes is
currently 122GB. DB size before we completed the vacuum full was 150GB.
We have recently done a major update to a table, f_pageviews
