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,
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
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
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
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.
/( )\
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
--- [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
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
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
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
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
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
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
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
[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
15 matches
Mail list logo