> 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 :-)


---------------------------(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

Reply via email to