Re: [ADMIN] How do I get off this mailing list
Andy, For detailed instructions: http://webmail.postgresql.org/cgi-bin/mj_wwwusr/domain=postgresql.org regards steve boyle - Original Message - From: Andy Gussie To: [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 4:24 AM Subject: [ADMIN] How do I get off this mailing list How do I get off this mailing list? -- Andy Gussie Network Administrator eFruit International, Inc. http://www.efruitinternational.com President VI Massive, Inc. http://www.vimassive.net
[ADMIN] Fine tuning mem sort, shared buffer
Hi all, First of all, I apologize for all these questions but my dba knowledges are quite grounded :( I would like to know if there is a reveipe, good RTFM, any thing else to estimate/evaluate values for mem_sort and shared buffers. Thank you. -- Jean-Christophe ARNU s/w developer Paratronic France ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Fine tuning mem sort, shared buffer
Jean-Christophe ARNU wrote: > Hi all, > First of all, I apologize for all these questions but my dba knowledges > are quite grounded :( > > I would like to know if there is a reveipe, good RTFM, any thing else > to estimate/evaluate values for mem_sort and shared buffers. See my hardware performance tuning article on techdocs site: http://techdocs.postgresql.org/ Specifically: http://www.ca.postgresql.org/docs/momjian/hw_performance/ -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Fine tuning mem sort, shared buffer
pgman wrote: > Jean-Christophe ARNU wrote: > > Hi all, > > First of all, I apologize for all these questions but my dba knowledges > > are quite grounded :( > > > > I would like to know if there is a reveipe, good RTFM, any thing else > > to estimate/evaluate values for mem_sort and shared buffers. > > See my hardware performance tuning article on techdocs site: > > http://techdocs.postgresql.org/ > > Specifically: > > http://www.ca.postgresql.org/docs/momjian/hw_performance/ These parameters are aslo discussed on in our documentation in the "Performance" section. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] problems with pg_dump/pg_restore
Hello ! I'm trying to dump postgresql 7.1.3 database and restore it in 7.2b4. Databases are located on different hosts. The problem is that when I run command pg_dump databasename --verbose -b -Ft -h otherhost | pg_restore -d databasename after some tables are copied error occures pg_dump: [tar archiver] could not write to tar member (wrote 1087, attempted 5365) pg_dump: *** aborted because of error pg_restore: [tar archiver] could not find header for file 179.dat in tar archive command is run on host with Postgresql 7.2b4 installed. What is wrong ?? BR Mirek ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] Monitoring database
On Tuesday, January 15, 2002, at 07:08 PM, Roman Gavrilov wrote: David Stanaway wrote: On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote: One more question is how can I see all tables in the template1 ? Thanks allot. in the psql client: psql template1 \dt \h is definately worth reading too. Did you try that ? I get "No relations found" is it a problem or template1 tables are protected some how and not shown in \dt What relations are you looking for? System tables? They don't show up in \dt That just lists user tables. There are a number of \d commands in psql for different types of relations, you should look at \? (Sorry I said \h and thats for SQL help) to see all the psql escapes. == David Stanaway Personal: [EMAIL PROTECTED] Work: [EMAIL PROTECTED]
[ADMIN] VACUUM ANALYZE--how often?
Our database has about 70 tables. Only a half-dozen or so have more than 100K rows, and all of these change (99% inserts, 10K-50K rows) during an average day. VACUUM ANALYZE takes over an hour, and it's edging up by a couple minutes per day. Is there a way to look at the DEBUG stats from the VACUUM command (written to the postmaster log) to determine what the optimum interval would be between VACUUMs? (Perhaps I could do three of the "big" tables on odd-numbered days, and the rest on even-numbered days?) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [ADMIN] VACUUM ANALYZE--how often?
[EMAIL PROTECTED] (Jeff Boes) writes: > Our database has about 70 tables. Only a half-dozen or so have more > than 100K rows, and all of these change (99% inserts, 10K-50K rows) > during an average day. > VACUUM ANALYZE takes over an hour, and it's edging up by a couple > minutes per day. Care to try 7.2? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[ADMIN] postgreSQL Version 7.2 for SuSE Linux
Hello there In my current project, we have postgres 7.0.x running for half a year now. In the db, there is one table that causes problems. This table has 66 columns and 1700 rows. SQL select's are 8 times slower than normal when the problem starts. Is there a way to see why the performance ist getting slower and slower. (I raised the buffer size for postmaster) I tried to regenerate the indexes, didn't help. In the news I read about the possibility to run vaccum/analyze without stopping the db with versein 7.2 of postgres. Is there a date when this release will be ready. In the next project in March, I'd like to have this feature. Tx ... jr __ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland internet : www.pup.ch phone : +4141 790 4040 fax : +4141 790 2545 mobile : +4179 211 0315 __ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
