RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ?

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

[root@levure 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 - pgsql-ml@baguette.net