Re: FW: [PERFORM] Performance 8.4.0

On Sun, Aug 2, 2009 at 10:04 PM, Chris Dunn wrote: > The database is 8gb currently. Use to be a lot bigger but we removed all > large objects out and developed a file server storage for it, and using > default page costs for 8.4, I did have it changed in 8.1.4 You might want to play with lowerin

Re: [PERFORM] Greenplum MapReduce

Suvankar Roy wrote: Hi all, Has anybody worked on Greenplum MapReduce programming ? It's a commercial product, you need to contact greenplum. -- Postgresql & php tutorials http://www.designmagick.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make cha

FW: [PERFORM] Performance 8.4.0

The database is 8gb currently. Use to be a lot bigger but we removed all large objects out and developed a file server storage for it, and using default page costs for 8.4, I did have it changed in 8.1.4 -Original Message- From: Robert Haas [mailto:robertmh...@gmail.com] Sent: Sunday, 2

Re: [PERFORM] Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version

parimala escreveu: [Don't repeat your answer. It's a PITA to receive multiple identical copies] > We are using Postgres 8.3.7 in our java application. We are doing > performances tuning and load testing in our setup. we have noticed that > ,some of our queries to the database taking long time to

Re: [PERFORM] Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version

,some of our queries to the database taking long time to return the results. fsync: off (even we tested this parameter is on ,we observed the same slowness ) If your queries take long time to return results, I suppose you are talking about SELECTs. fsync = off will not make SELECT

Re: [PERFORM] Performance Monitoring tool

depending on what you mean with 'monitor'. for up/down monitoring use nagios (http://www.nagios.org)for performance monitoring (and I guess the reason why you ask this on the postgresql performance list), use pgstatspack: ( http://pgfoundry.org/projects/pgstatspack/) frits On Fri, Jul 31, 2009 at

Re: [PERFORM] Performance 8.4.0

* Robert Haas (robertmh...@gmail.com) wrote: > On Fri, Jul 31, 2009 at 12:22 AM, Chris Dunn wrote: > > constraint_exclusion = on > > This is critical if you need it, but a waste of CPU time if you don't. > Other than that your paramaters look good. Are you using the default > page cost settings?

[PERFORM] Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version

Dear All, We are using Postgres 8.3.7 in our java application. We are doing performances tuning and load testing in our setup. we have noticed that ,some of our queries to the database taking long time to return the results.Please find our setup details belows. We observed that postgres is runni

[PERFORM] Performance Monitoring tool

Hi Can anyone tell me what are the tools to monitor postgres server. ? I am running my Postgres server on RHEL 5 machine. -- View this message in context: http://www.nabble.com/Performance-Monitoring-tool-tp24751382p24751382.html Sent from the PostgreSQL - performance mailing list archive at Na

[PERFORM] SQL select query becomes slow when using limit (with no offset)

Hi folks, We have problems with performance of a simple SQL statement. If we add a LIMIT 50, the query is about 6 times slower than without a limit (query returns 2 rows). I have read this discussion: http://archives.postgresql.org/pgsql-performance/2008-09/msg5.php but there seems to be no

[PERFORM] Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version

Dear All, We are using Postgres 8.3.7 in our java application. We are doing performances tuning and load testing in our setup. we have noticed that ,some of our queries to the database taking long time to return the results.Please find our setup details belows. We observed that postgres i

[PERFORM] Greenplum MapReduce

Hi all, Has anybody worked on Greenplum MapReduce programming ? I am facing a problem while trying to execute the below Greenplum Mapreduce program written in YAML (in blue). The error is thrown in the 7th line as: Error: YAML syntax error - found character that cannot start any token while s

[PERFORM] select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why?

Hello, I have a problem with an inner join + count(). my query is: explain analyze select k.idn,k.kerdes_subject,k.kerdes_text,u.vezeteknev,u.keresztnev,u.idn as user_id, kg.kategoria_neve, count(v.idn) FROM kategoriak as kg INNER JOIN kerdesek as k on kg.idn = k.kategoria_id INNER JOIN u

Re: [PERFORM] Performance 8.4.0

On Fri, Jul 31, 2009 at 12:22 AM, Chris Dunn wrote: > constraint_exclusion = on This is critical if you need it, but a waste of CPU time if you don't. Other than that your paramaters look good. Are you using the default page cost settings? I see you have 12 GB RAM; how big is your database? ..