[PERFORM] Vacum Analyze problem

2007-09-04 Thread rafael
Hello everyone: I wanted to ask you about how the VACUUM ANALYZE works. is it possible that something can happen in order to reset its effects forcing to execute the VACUUM ANALYZE comand again? i am asking this because i am struggling with a query which works ok after i run a VACUUM ANALYZE,

Re: [PERFORM] Vacum Analyze problem

2007-09-04 Thread Mikko Partio
On 9/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello everyone: I wanted to ask you about how the VACUUM ANALYZE works. is it possible that something can happen in order to reset its effects forcing to execute the VACUUM ANALYZE comand again? Yes, lots of modifications

Re: [PERFORM] Vacum Analyze problem

2007-09-04 Thread rafael
On 9/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello everyone: I wanted to ask you about how the VACUUM ANALYZE works. is it possible that something can happen in order to reset its effects forcing to execute the VACUUM ANALYZE comand again? Yes, lots of modifications

Re: [PERFORM] Vacum Analyze problem

2007-09-04 Thread Bill Moran
In response to [EMAIL PROTECTED]: Hello everyone: I wanted to ask you about how the VACUUM ANALYZE works. is it possible that something can happen in order to reset its effects forcing to execute the VACUUM ANALYZE comand again? i am asking this because i am struggling with a query

[PERFORM] About autovacuum

2007-09-04 Thread Jean-David Beyer
I have this turned on, and if I look at the log, it runs once a minute, which is fine. But what does it do? I.e, it runs VACUUM, but does it also do an analyze? -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\

Re: [PERFORM] Vacum Analyze problem

2007-09-04 Thread rafael
On Tuesday 04 September 2007 11:27:07 [EMAIL PROTECTED] wrote: Hello everyone: I wanted to ask you about how the VACUUM ANALYZE works. is it possible that something can happen in order to reset its effects forcing to execute the VACUUM ANALYZE comand again? i am asking this because i

Re: [PERFORM] Vacum Analyze problem

2007-09-04 Thread Richard Broersma Jr
--- [EMAIL PROTECTED] wrote: Thank you all for the information. I'll get to work on it and see what happends. Thanks again Rafael I'll chime in with one last thought about excellent resources on Vacuum: http://www.postgresql.org/docs/8.2/static/sql-vacuum.html

Re: [PERFORM] About autovacuum

2007-09-04 Thread Bill Moran
In response to Jean-David Beyer [EMAIL PROTECTED]: I have this turned on, and if I look at the log, it runs once a minute, which is fine. But what does it do? I.e, it runs VACUUM, but does it also do an analyze? Yes. If you turn up the debugging level, you'll see detailed log messages

Re: [PERFORM] join tables vs. denormalization by trigger

2007-09-04 Thread Mark Lewis
On Tue, 2007-09-04 at 20:53 +0200, Walter Mauritz wrote: Hi, I wonder about differences in performance between two scenarios: Background: Table A, ~50,000 records Table B, ~3,000,000 records (~20 cols) Table C, ~30,000,000 records (~10 cols) a query every 3sec. with limit 10 Table

[PERFORM] Performance on 8CPU's and 32GB of RAM

2007-09-04 Thread Carlo Stonebanks
A client is moving their postgresql db to a brand new Windows 2003 x64 server with 2 quad cores and 32GB of RAM. It is a dedicated server to run 8.2.4. The server typically will have less than 10 users. The primary use of this server is to host a database that is continuously being updated by

Re: [PERFORM] join tables vs. denormalization by trigger

2007-09-04 Thread Marc Mamin
Hello, I had a similar issue and -atfer testing - decided to merge the tables B and C into a single table. In my case the resulting table contains a large proportion of nulls which limits the size increase... You'll have to do some testing with your data to evaluate the performance gain. Hope to

Re: [PERFORM] Performance on 8CPU's and 32GB of RAM

2007-09-04 Thread Scott Marlowe
On 9/4/07, Carlo Stonebanks [EMAIL PROTECTED] wrote: A client is moving their postgresql db to a brand new Windows 2003 x64 server with 2 quad cores and 32GB of RAM. It is a dedicated server to run 8.2.4. And what does the drive subsystem look like? All that horsepower isn't going to help if

Re: [PERFORM] Performance on 8CPU's and 32GB of RAM

2007-09-04 Thread Alvaro Herrera
Carlo Stonebanks wrote: A client is moving their postgresql db to a brand new Windows 2003 x64 server with 2 quad cores and 32GB of RAM. It is a dedicated server to run 8.2.4. Large shared_buffers and Windows do not mix. Perhaps you should leave the shmem config low, so that the kernel can

Re: [PERFORM] Performance on 8CPU's and 32GB of RAM

2007-09-04 Thread Scott Marlowe
On 9/4/07, Alvaro Herrera [EMAIL PROTECTED] wrote: Carlo Stonebanks wrote: A client is moving their postgresql db to a brand new Windows 2003 x64 server with 2 quad cores and 32GB of RAM. It is a dedicated server to run 8.2.4. Large shared_buffers and Windows do not mix. Perhaps you

Re: [PERFORM] Vacum Analyze problem

2007-09-04 Thread Gregory Stark
[EMAIL PROTECTED] writes: I knew that in the long run the VACUUM ANALYZE comand has to be executed again. My question is if something can happen over night and cause the need of a new VACUUM ANALYZE (regenerating indexes or other thing related with performance). The answer to your question