| From: | "Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net> |
|---|---|
| To: | "'Stephan Szabo'" <sszabo(at)megazone(dot)bigpanda(dot)com>, "'Bruno BAGUETTE'" <pgsql-ml(at)baguette(dot)net> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? |
| Date: | 2004-02-06 16:41:20 |
| Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAc4S9ozBdnUKOm+euVRHDegEAAAAA@baguette.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> 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(at)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(at)baguette(dot)net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | markw | 2004-02-06 17:05:04 | Re: 7.3 vs 7.4 performance |
| Previous Message | Bruno BAGUETTE | 2004-02-06 16:34:48 | RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? |