> In addition to what Tom said, the row estimates look
> suspiciously default. You mention vacuuming, but do you ever
> analyze the tables?
I run VACUUM FULL ANALYZE with the postgres user on all the PostgreSQL
databases on the server, twice a day, sometimes more.
> Also, what do you have sort_mem set to?
[EMAIL PROTECTED] data]# cat postgresql.conf | grep sort_mem
sort_mem = 6144 # min 64, size in KB
Do you think I should increase that value ?
It's not so easy to do a good setup of that postgresql.conf file, is
there any tool that suggests some values for that ?
Thanks in advance for your tips :-)
---------------------------------------
Bruno BAGUETTE - [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
