pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgres gets slower after some while
4+ messages / 3 participants
[nested] [flat]
* postgres gets slower after some while
@ 2004-11-01 15:01 Edgars <edzix19@inbox.lv>
0 siblings, 1 reply; 4+ messages in thread
From: Edgars @ 2004-11-01 15:01 UTC (permalink / raw)
To: pgsql-admin
Hey,
make some futher testings regarding my previous post (subj) and
discovered that even on v7.4.2 is the same problem, it means the problem
is somewhere in the configuration. On another box this works ok.
The only way how i'm solving it for now is by dumping the whole
structure and data from DB, dropping it and creating again. Then
everything works for some time (till one day).
Please can someone assist me in this!
Edgars
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres gets slower after some while
@ 2004-11-01 15:37 Jaime Casanova <systemguards@yahoo.com>
parent: Edgars <edzix19@inbox.lv>
0 siblings, 1 reply; 4+ messages in thread
From: Jaime Casanova @ 2004-11-01 15:37 UTC (permalink / raw)
To: pgsql-admin
--- Edgars <edzix19@inbox.lv> escribió:
> Hey,
>
> make some futher testings regarding my previous post
> (subj) and
> discovered that even on v7.4.2 is the same problem,
> it means the problem
> is somewhere in the configuration. On another box
> this works ok.
> The only way how i'm solving it for now is by
> dumping the whole
> structure and data from DB, dropping it and creating
> again. Then
> everything works for some time (till one day).
>
Are you running VACUUM periodically on the database?
It has a similar effect (it's not the same thing) that
when you drop and recreate the database.
Here is an explanation why VACUUM is necessary:
http://www.postgresql.org/docs/7.4/interactive/maintenance.html
Here you can find some other performance-tips:
http://www.postgresql.org/docs/7.4/interactive/performance-tips.html
regards,
Jaime Casanova
_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres gets slower after some while
@ 2004-11-02 12:32 Edgars <edzix19@inbox.lv>
parent: Jaime Casanova <systemguards@yahoo.com>
0 siblings, 1 reply; 4+ messages in thread
From: Edgars @ 2004-11-02 12:32 UTC (permalink / raw)
To: Jaime Casanova <systemguards@yahoo.com>; pgsql-admin
Jaime,
thanks for the response!
yes, i have tried this VACUMM, it gives some effect but only for some
time (2hours or so). Maybe you know why it is happening so?
Edgars
Jaime Casanova wrote:
> --- Edgars <edzix19@inbox.lv> escribió:
>
>
>>Hey,
>>
>>make some futher testings regarding my previous post
>>(subj) and
>>discovered that even on v7.4.2 is the same problem,
>>it means the problem
>>is somewhere in the configuration. On another box
>>this works ok.
>>The only way how i'm solving it for now is by
>>dumping the whole
>>structure and data from DB, dropping it and creating
>>again. Then
>>everything works for some time (till one day).
>>
>>
>>
>
>Are you running VACUUM periodically on the database?
>
>It has a similar effect (it's not the same thing) that
>when you drop and recreate the database.
>
>Here is an explanation why VACUUM is necessary:
>http://www.postgresql.org/docs/7.4/interactive/maintenance.html
>
>Here you can find some other performance-tips:
>http://www.postgresql.org/docs/7.4/interactive/performance-tips.html
>
>regards,
>Jaime Casanova
>
>
>
>_________________________________________________________
>Do You Yahoo!?
>Información de Estados Unidos y América Latina, en Yahoo! Noticias.
>Visítanos en http://noticias.espanol.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 8: explain analyze is your friend
>
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: postgres gets slower after some while
@ 2004-11-02 14:22 Harald Fuchs <hf0722x@protecting.net>
parent: Edgars <edzix19@inbox.lv>
0 siblings, 0 replies; 4+ messages in thread
From: Harald Fuchs @ 2004-11-02 14:22 UTC (permalink / raw)
To: pgsql-admin
In article <41877E56.4060504@inbox.lv>,
Edgars <edzix19@inbox.lv> writes:
> Jaime,
> thanks for the response!
> yes, i have tried this VACUMM, it gives some effect but only for some
> time (2hours or so). Maybe you know why it is happening so?
PostgreSQL can't run for long without a proper VACUUM policy. Read
the docs under "Routine Database Maintenance Tasks".
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-11-02 14:22 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-01 15:01 postgres gets slower after some while Edgars <edzix19@inbox.lv>
2004-11-01 15:37 ` Jaime Casanova <systemguards@yahoo.com>
2004-11-02 12:32 ` Edgars <edzix19@inbox.lv>
2004-11-02 14:22 ` Harald Fuchs <hf0722x@protecting.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox