pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres 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