Re: [PERFORM] Postgresql.conf Settings

.Marsha Scott Marlowe-2 wrote: > > On 11/4/07, smiley2211 <[EMAIL PROTECTED]> wrote: >> >> Hello all, >> >> What are the ideal settings for values in this postgresql.conf file??? I >> have tried so many parameter changes but I still can not get the 8.1.

[PERFORM] Postgresql.conf Settings

Hello all, What are the ideal settings for values in this postgresql.conf file??? I have tried so many parameter changes but I still can not get the 8.1.4 version to perform as well as the 7.x version...what do others have their postgrsql.conf file values set to??? Are there any known performan

Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

Dennis, Thanks for your reply. No, the OLD server are no longer available (decommissioned) - the new servers are definitely better h\w. I do not have any queries to EXPLAIN ANALYZE as they are built by the application and I am not allowed to enable logging on for that server - so where do I go

Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

Here are the requested lines... There were 0 unused item pointers. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: free space map contains 786 pages in 297 relations DETAIL: A total of 5408 page slots are in use (including overhead). 5408 page slots are required to track

Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

How do I know if there is BLOATING??? I just ran vacuum verbose; Yes, autovacuum is on. Thanks...Michelle -- View this message in context: http://www.nabble.com/Upgraded-from-7.4-to-8.1.4-QUERIES-NOW-SLOW%21%21%21-tf4489502.html#a12807959 Sent from the PostgreSQL - performance mailing list a

Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

No, I didn't UPGRADE it but that's what I inherited :( ...not sure of the code page stuff because I am not the one who did the upgrade...I'm not sure I know ENOUGH about POSTGRESQL to mess around with the codepage... Yes, I use vacuum analyze... Yes, I used the postgresql.conf of 7.4 and tried t

[PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

Hello all, Old servers that housed 7.4 performed better than 8.1.4 version...are there any MAJOR performance hits with this version??? I set the postgresql.conf setting to equal that of 7.4 and queries still run SLOW on 8.1.4... I have perform maintenance tonight on the 8.1.4 server - any ideas

Re: [PERFORM] How to ENABLE SQL capturing???

og will > likely show up in the /var/log/messages file. > > On Fri, 10 Aug 2007, smiley2211 wrote: > >> >> Hello all, >> >> I have ENABLED this 'log_min_duration_statement = 100" but I can't figure >> out WHERE it's writing the

Re: [PERFORM] How to ENABLE SQL capturing???

.postgresql.org/ > > Bryan > > On 8/8/07, Steinar H. Gunderson <[EMAIL PROTECTED]> wrote: >> On Wed, Aug 08, 2007 at 01:02:24PM -0700, smiley2211 wrote: >> > I am trying to enable capturing of the submitted code via an >> > application...how do I do th

[PERFORM] How to ENABLE SQL capturing???

Hello all, I am trying to enable capturing of the submitted code via an application...how do I do this in Postgres? Performance is SLOW on my server and I have autovacuum enabled as well as rebuilt indexes...whatelse should be looked at? Thanks...Michelle -- View this message in context: http

Re: [PERFORM] Database Statistics???

the fast database? --- I am new, how do I know the size of the database (OS file size ??))...is there an sp_helpdb equivalent command?? My EXPLAINS are under a previous thread: Query is taking 5 HOURS to Complete on 8.1 version Thanks...Michelle Tom Arthurs wrote: > > smiley2211

[PERFORM] Database Statistics???

Hello all, I am a bit confused...I have a database which was performing very POORLY selecting from a view (posted earlier) on one server but extremely fast on another server... I just backed up the database from the FAST server and loaded to the SLOW server and it ran just as fast as it original

Re: [PERFORM] TIMING A QUERY ???

Thanks all...\timing works. -- View this message in context: http://www.nabble.com/TIMING-A-QUERY-tf4062567.html#a11559115 Sent from the PostgreSQL - performance mailing list archive at Nabble.com. ---(end of broadcast)--- TIP 5: don't forg

[PERFORM] TIMING A QUERY ???

How can I get the time it takes a query to execute - explain analyze is taking over 5 hours to complete...can I use \timing??? I don't get any time when using the \timing option... Thanks...Marsha -- View this message in context: http://www.nabble.com/TIMING-A-QUERY-tf4062567.html#a1154239

Re: [PERFORM] Query is taking 5 HOURS to Complete on 8.1 version

Index Cond: ((question_tag)::text = 'shareWithEval'::text) -> Index Scan using ctccalls_qs_as_qaid on ctccalls_questions_ans

Re: [PERFORM] Query is taking 5 HOURS to Complete on 8.1 version

TOP shows CPU at 100% while executed the EXPLAIN ANALYZE...what does this mean? 17519 postgres 25 0 3470m 43m 39m R 100 0.3 28:50.53 postmaster -- View this message in context: http://www.nabble.com/Query-is-taking-5-HOURS-to-Complete-on-8.1-version-tf4019778.html#a11419885 Sent from t

Re: [PERFORM] Query is taking 5 HOURS to Complete on 8.1 version

Here are the VIEWS in question: query = (explain analyze select id from people_consent LIMIT 1;) CREATE OR REPLACE VIEW temp_consent AS SELECT p.id, max(en.enrolled_at) AS daterecorded, a.answer FROM people p, enrollments en, encounters ec, encounters_questions_answers eqa, questions_answers

Re: [PERFORM] Query is taking 5 HOURS to Complete on 8.1 version

Here is the EXPLAIN after I changed some conf file - now I am running another EXPLAIN ANALYZE which may take 5 or more hours to complete :,( effective_cache = 17 enable_seqscan = on enable _bitmapscan = on QUERY PLAN

[PERFORM] Query is taking 5 HOURS to Complete on 8.1 version

This query is taking less than 5 minutes on 7.4 but over 5 hours on 8.1... PostgreSQL 8.1.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.0 (SUSE Linux) Total runtime: 20448310.101 ms = 5.6800862 hour (132 rows) --postgresql.conf: shared_buffers = 114688 # min 16 or