Re: [PERFORM] Very slow query in PostgreSQL 9.3.3

2014-03-14 4:26 GMT+09:00 : > PostgreSQL 9.3.3 RHEL 6.4 > > Total db Server memory 64GB (...) > effective_cache_size = 48MB I'm not sure if this will help directly, but is the value for 'effective_cache_size' intentional? 48 *GB* would be a more likely setting. Regards Ian Barwick -- Sent v

Re: [PERFORM] Postgres upgrade, security release, where?

2013/4/4 Mark Kirkwood : > On 02/04/13 21:47, Mark Kirkwood wrote: >> >> On 02/04/13 21:34, Dave Page wrote: >>> >>> On Mon, Apr 1, 2013 at 11:43 PM, Mark Kirkwood >>> wrote: >>>> >>>> On 02/04/13 13:55, Bruce Momjian wrote: >&g

Re: [PERFORM] Postgres upgrade, security release, where?

2013/4/2 Bruce Momjian : > On Mon, Apr 1, 2013 at 05:10:22PM -0700, Tory M Blue wrote: >> So It was announced that there would be a security patch for all versions >> released on the 4th. I see it's been announced/released on the website, but >> the >> versions available show Feb dates. >> >> Sho

Re: [PERFORM] PG_XLOG 27028 files running out of space

2013/2/14 Tory M Blue > My postgres db ran out of space. I have 27028 files in the pg_xlog > directory. I'm unclear what happened this has been running flawless for > years. I do have archiving turned on and run an archive command every 10 > minutes. > > I'm not sure how to go about cleaning this