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 > when I install sysbench-0.4.8, after the make command: > > > /usr/bin/ld: warning: libssl.so.6, needed by > /opt/PostgreSQL/9.0/lib/libpq.

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, valu

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

2010-12-12 Thread Tom Lane
Tomas Vondra 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 DEFAULT_RANGE_INEQ

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

2010-12-12 Thread tv
> Tomas Vondra 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 wrote: Scott Marlowe wrote: On Fri, Dec 10, 2010 at 12:53 AM, Adarsh Sharma wrote: Dear all, I am r

[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 wrote: > Hello, > > We are facing very HIGH memory utilization on postgreSQL server and need help. > > Below are details of PostgreSQL server, > > === > MemTotal:      8165696 kB

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 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, 4793732k cach

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,