>>bgwriter_percent = 0
>>bgwriter_maxpages = 0
> Why did you do that? There's certainly nothing in the docs recommending
> disabling the bgwriter.
I'm remembering that putting big data into the database ran faster with
this settings.
>>The duration of the VACUUM of tbl1 and tbl2 is okay - so ho
Aldor <[EMAIL PROTECTED]> writes:
> bgwriter_percent = 0
> bgwriter_maxpages = 0
Why did you do that? There's certainly nothing in the docs recommending
disabling the bgwriter.
> The duration of the VACUUM of tbl1 and tbl2 is okay - so how to speed up
> now the VACUUM of tbl3?
You have not show
Hi,
I want to get some statistical information from people having experience
with vacuuming big tables:
I was a little bit confused why some vacuums take much much longer then
other and I was doing some tests with a test database. All tests have
been made with PostgreSQL 8.0.3. At all I made thre
On Sun, Aug 28, 2005 at 08:49:13AM -0300, Flávio Brito wrote:
> How can I see, such as MSSQL screen, all queries that are processing in
> real time?
You can configure the backend to log the queries it receives; for
more information see "Error Reporting and Logging" in the "Server
Run-time Environm
How can I see, such as MSSQL screen, all queries that are processing in
real time?
I want to monitor all the queries that are being processed by a user in
real time.
Thanks
Flavio
---(end of broadcast)---
TIP 6: explain analyze is your friend
