Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno BAGUETTE
Subject RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ?
Date
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAc4S9ozBdnUKOm+euVRHDegEAAAAA@baguette.net
Whole thread Raw
In response to Re: Increase performance of a UNION query that thakes  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: RE : Increase performance of a UNION query that thakes
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: "Bruno BAGUETTE"
Date:
Subject: RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ?
Next
From: Stephan Szabo
Date:
Subject: Re: RE : Increase performance of a UNION query that thakes