On 13.06.2006, at 12:33 Uhr, Ruben Rubio Rey wrote:
Seems autovacumm is working fine. Logs are reporting that is being
useful.
But server load is high. Is out there any way to stop "autovacumm"
if server load is very high?
Look at the cost settings for vacuum and autovacuum. From the manu
Seems autovacumm is working fine. Logs are reporting that is being useful.
But server load is high. Is out there any way to stop "autovacumm" if
server load is very high?
Thanks everyone!!!
---(end of broadcast)---
TIP 3: Have you checked our e
Guido Neitzer wrote:
On 13.06.2006, at 8:44 Uhr, Ruben Rubio Rey wrote:
Tonight database has been vacumm full and reindex (all nights
database do it)
Now its working fine. Speed is as spected. I ll be watching that sql
...
Maybe the problem exists when database is busy, or maybe its sol
On 13.06.2006, at 8:44 Uhr, Ruben Rubio Rey wrote:
Tonight database has been vacumm full and reindex (all nights
database do it)
Now its working fine. Speed is as spected. I ll be watching that
sql ...
Maybe the problem exists when database is busy, or maybe its
solved ...
Depending on
Tonight database has been vacumm full and reindex (all nights database
do it)
Now its working fine. Speed is as spected. I ll be watching that sql ...
Maybe the problem exists when database is busy, or maybe its solved ...
---(end of broadcast)---
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 09:05:06AM -0600, Michael Fuhr wrote:
On Mon, Jun 12, 2006 at 04:38:57PM +0200, Ruben Rubio Rey wrote:
I have two similar servers, one in production and another for testing
purposes.
Databases are equal (with a difference of some hours)
In
Hi Ruben,
Ruben Rubio Rey schrieb:
Hi,
Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel
2.6.9-1.667smp)
I have two similar servers, one in production and another for testing
purposes.
Databases are equal (with a difference of some hours)
In the testing server, an sql se
On Mon, Jun 12, 2006 at 05:22:05PM +0200, Ruben Rubio Rey wrote:
> Jim C. Nasby wrote:
>
> >On Mon, Jun 12, 2006 at 04:58:49PM +0200, Ruben Rubio Rey wrote:
> >
> >
> >>$DIREC/vacuumdb -f -v --analyze vacadb 2>&1 | $LOGBIN
> >>$DIRLOGS/%Y-%m-%d_limpieza.log
> >>echo "reindex database vacadb;" |
On Mon, Jun 12, 2006 at 09:05:06AM -0600, Michael Fuhr wrote:
> On Mon, Jun 12, 2006 at 04:38:57PM +0200, Ruben Rubio Rey wrote:
> > I have two similar servers, one in production and another for testing
> > purposes.
> > Databases are equal (with a difference of some hours)
> >
> > In the testing
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 04:58:49PM +0200, Ruben Rubio Rey wrote:
$DIREC/vacuumdb -f -v --analyze vacadb 2>&1 | $LOGBIN
$DIRLOGS/%Y-%m-%d_limpieza.log
echo "reindex database vacadb;" | $DIREC/psql vacadb 2>&1 | $LOGBIN
$DIRLOGS/%Y-%m-%d_limpieza.log
date | $LOGBIN $DIRLO
On Mon, Jun 12, 2006 at 04:58:49PM +0200, Ruben Rubio Rey wrote:
> $DIREC/vacuumdb -f -v --analyze vacadb 2>&1 | $LOGBIN
> $DIRLOGS/%Y-%m-%d_limpieza.log
> echo "reindex database vacadb;" | $DIREC/psql vacadb 2>&1 | $LOGBIN
> $DIRLOGS/%Y-%m-%d_limpieza.log
> date | $LOGBIN $DIRLOGS/%Y-%m-%d_limpi
On Mon, Jun 12, 2006 at 04:38:57PM +0200, Ruben Rubio Rey wrote:
> I have two similar servers, one in production and another for testing
> purposes.
> Databases are equal (with a difference of some hours)
>
> In the testing server, an sql sentence takes arround 1 sec.
> In production server (low
Jonah H. Harris wrote:
On 6/12/06, Ruben Rubio Rey <[EMAIL PROTECTED]> wrote:
I have two similar servers, one in production and another
for testing purposes. In testing server ~1sec ... in
production ~50 secs
What ver of PostgreSQL?
Version 8.1.3
Same ver on both systems?
Yes
Are
Gábriel Ákos wrote:
Ruben Rubio Rey wrote:
Hi,
Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel
2.6.9-1.667smp)
I have two similar servers, one in production and another for testing
purposes.
Databases are equal (with a difference of some hours)
In the testing server,
Do you run analyze on the production server regularly?
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Ruben Rubio Rey
> Sent: Monday, June 12, 2006 9:39 AM
> To: pgsql-performance@postgresql.org
> Subject: [PERFORM] P
Hi,
Im having a problem with postgres 8.1.3 on a Fedora Core 3 (kernel
2.6.9-1.667smp)
I have two similar servers, one in production and another for testing
purposes.
Databases are equal (with a difference of some hours)
In the testing server, an sql sentence takes arround 1 sec.
In produc
16 matches
Mail list logo
