Re: [PERFORM] SQL CPU time usage

2006-05-18 Thread Ivan Zolotukhin
You may also try PgFouine (http://pgfouine.projects.postgresql.org/) for log analysis, I found it very useful in similar situation. On 5/17/06, Ruben Rubio Rey <[EMAIL PROTECTED]> wrote: Hi, I have a web page, that executes several SQLs. So, I would like to know witch one of those SQLs consum

Re: [PERFORM] getting better performance

2006-07-06 Thread Ivan Zolotukhin
On 7/6/06, A. Kretschmer <[EMAIL PROTECTED]> wrote: am 06.07.2006, um 9:40:16 +0300 mailte Eugeny N Dzhurinsky folgendes: > In postgresql.conf I have these settings: > > shared_buffers = 4 > work_mem = 8192 > maintenance_work_mem = 16384 > max_stack_depth = 2048 > > all other settings are l

Re: [PERFORM] PostgreSQL performance on a virtual host

2008-03-05 Thread Ivan Zolotukhin
Hello, We had a bad experience with PostgreSQL running in OpenVZ (year and a half year ago): OpenVZ kernel killed postmaster with strange signals from time to time, failcounters of OpenVZ did not worked as expected in this moments, PostgreSQL fighted for the disk with applications in other virtual

Re: [PERFORM] PostgreSQL performance on a virtual host

2008-03-05 Thread Ivan Zolotukhin
Hello, On Wed, Mar 5, 2008 at 5:40 PM, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to "Ivan Zolotukhin" <[EMAIL PROTECTED]>: > > > > > We had a bad experience with PostgreSQL running in OpenVZ (year and a > > half year ago): OpenVZ kernel ki