Re: [GENERAL] SSL ques

2010-12-12 Thread Dmitriy Igrishin
Hey, Sounds like you does not have SSL library installed. Try to install, for example, OpenSSL first and then try to build you software. 2010/12/12 zab08 za...@126.com when I install sysbench-0.4.8, after the make command: /usr/bin/ld: warning: libssl.so.6, needed by

Re: [GENERAL] SSL ques

2010-12-12 Thread zab08
thank you, I install postgres from source, and use --with-openssl.

[GENERAL] range intervals in window function frames

2010-12-12 Thread Daniel Popowich
Hello all! I need to do moving averages over time series data and was hoping window functions could solve the problem for me, but it doesn't look like 8.4 or even 9.0 implementations are quite there, yet. Currently, if I have this table: create table sample ( tstimestamp,

Re: [GENERAL] strange row count estimates with conditions on multiple column

2010-12-12 Thread Tom Lane
Tomas Vondra t...@fuzzy.cz writes: Dne 17.11.2010 06:58, Tom Lane napsal(a): BTW I think the default estimate used to be 1000, so it was changed in one of the 8.x releases? Can you point me to the docs? I've even tried to find that in the sources, but unsuccessfully. It's

Re: [GENERAL] strange row count estimates with conditions on multiple column

2010-12-12 Thread tv
Tomas Vondra t...@fuzzy.cz writes: I've been thinking about this and I think it might be improved. If I understand the logic corretly, it says 'use half of the histogram bin size'. But the value #define DEFAULT_RANGE_INEQ_SEL 0.005 says it's always 0.5%, which is not not true if STATISTICS

Re: [GENERAL] Performance tuning in Pgsql

2010-12-12 Thread Adarsh Sharma
Scott Marlowe wrote: Please keep the list cc'd as there are others who might be able to help or could use this thread for help. On Fri, Dec 10, 2010 at 2:53 AM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Scott Marlowe wrote: On Fri, Dec 10, 2010 at 12:53 AM, Adarsh Sharma

[GENERAL] Urgent -- High memory usage on PostgreSQL server

2010-12-12 Thread savio rodriges
Hello, We are facing very HIGH memory utilization on postgreSQL server and need help. Below are details of PostgreSQL server, === MemTotal: 8165696 kB CpuTotal: 8

Re: [GENERAL] Urgent -- High memory usage on PostgreSQL server

2010-12-12 Thread Allan Kamau
On Mon, Dec 13, 2010 at 8:49 AM, savio rodriges sj_sa...@yahoo.com wrote: Hello, We are facing very HIGH memory utilization on postgreSQL server and need help. Below are details of PostgreSQL server, === MemTotal:      

Re: [GENERAL] Urgent -- High memory usage on PostgreSQL server

2010-12-12 Thread Paul McGarry
On Mon, Dec 13, 2010 at 4:49 PM, savio rodriges sj_sa...@yahoo.com wrote: Hello, We are facing very HIGH memory utilization on postgreSQL server and need help. Mem: 8165696k total, 7943160k used, 222536k free, 282044k buffers Swap: 8385920k total, 112828k used, 8273092k free,

Re: [GENERAL] Urgent -- High memory usage on PostgreSQL server

2010-12-12 Thread Jan Kesten
Hello Savio, top - 21:43:35 up 55 days, 8:07, 4 users, load average: 0.05, 0.25, 0.17 Tasks: 257 total, 1 running, 256 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 8165696k total, 7943160k used, 222536k free,