[PERFORM] slow query on postgres 8.4

Can someone shed some light on the following query. any help would certainly be appreciated! thanks - * Maria Wilson Nasa/Langley Research Center Hampton, Virginia m.l.wil...@nasa.gov * explain analyze select a.ID, a.provider, a.hostname, a.username, a.eventTimeStamp, a.AIPGUID, a.

[PERFORM] help on slow query using postgres 8.4

Can someone shed some light on the following query. any help would certainly be appreciated! thanks - * Maria Wilson Nasa/Langley Research Center Hampton, Virginia m.l.wil...@nasa.gov * explain analyze select a.ID, a.provider, a.hostname, a.username, a.eventTimeStamp, a.AIPGUID, a.

[PERFORM] postgres constraint triggers

Hi all I would like to start a dialogue and hear general feedback about the use of constraint triggers in postgres (8.4.5). Our overall issue is that using general triggers is causing slow inserts (from locking issues) in our database. Here are some details: A little background (jboss/

Re: [PERFORM] help speeding up a query in postgres 8.4.5

endations? Maria On 5/10/11 1:59 PM, Robert Haas wrote: [ woops, accidentally replied off-list, trying again ] On Tue, May 10, 2011 at 1:47 PM, Maria L. Wilson wrote: thanks for taking a look at this and it's never too late!! I've tried bumping up work_mem and did not see any

Re: [PERFORM] help speeding up a query in postgres 8.4.5

pr 5, 2011 at 3:25 PM, Maria L. Wilson wrote: Would really appreciate someone taking a look at the query below Thanks in advance! this is on a linux box... Linux dsrvr201.larc.nasa.gov 2.6.18-164.9.1.el5 #1 SMP Wed Dec 9 03:27:37 EST 2009 x86_64 x86_64 x86_64 GNU/Linux explain analyze

Re: [PERFORM] help speeding up a query in postgres 8.4.5

yep - we use analyze and check the output. It's version 8.4.5 so no fsm issues. thanks, Maria On 4/6/11 11:33 AM, Kevin Grittner wrote: "Maria L. Wilson" wrote: Autovacuum is not running - but regular vacuums are being done twice daily. Is the ANALYZE keyword used on th

Re: [PERFORM] help speeding up a query in postgres 8.4.5

thanks for the reply, Tomas. I'll test bumping up work_mem and see how that helps. thanks again, Maria Wilson On 4/6/11 9:16 AM, t...@fuzzy.cz wrote: some additional info. the table inventory is about 4481 MB and also has postgis types. the table gran_ver is about 523 MB the table IN

Re: [PERFORM] help speeding up a query in postgres 8.4.5

ON gran_ver USING btree (granule_id); indexes on sensor CREATE INDEX invsnsr_idx2 ON invsensor USING btree (sensor_id); On 4/6/11 7:41 AM, Szymon Guz wrote: On 5 April 2011 21:25, Maria L. Wilson <mailto:maria.l.wilso...@nasa.gov>> wrote: Would really appreciat

[PERFORM] help speeding up a query in postgres 8.4.5

Would really appreciate someone taking a look at the query below Thanks in advance! this is on a linux box... Linux dsrvr201.larc.nasa.gov 2.6.18-164.9.1.el5 #1 SMP Wed Dec 9 03:27:37 EST 2009 x86_64 x86_64 x86_64 GNU/Linux explain analyze select MIN(IV.STRTDATE), MAX(IV.ENDDATE) from G

Re: [PERFORM] [Fwd: postgres 8.4.1 number of connections]

n Thu, Aug 26, 2010 at 2:29 PM, Maria L. Wilson wrote: we have this application (using jboss/java/hibernate) on linux accessing data on 3 postgres database servers using 8.4.1. One of our many concerns has been the way we handle connections to the database. java/hibernate handle their own pooli

[PERFORM] [Fwd: postgres 8.4.1 number of connections]

Original Message Subject:postgres 8.4.1 number of connections Date: Thu, 26 Aug 2010 14:25:47 -0500 From: Maria L. Wilson Reply-To: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS APPLICATIONS] To: pgsql-performance-ow...@postgresql.org we have this