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
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.4
version to perform as well as the 7.x version...what do others have
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
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
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
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
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
[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 this in Postgres? Performance is SLOW on my
server and I have autovacuum enabled as well as rebuilt
indexes...whatelse
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 commands to ...I have it set to 'syslogs' but
this file is 0 bytes :confused:
Should I set other
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:
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
to 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 wrote:
Hello
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
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:
)
smiley2211 wrote:
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
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
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
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,
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
19 matches
Mail list logo