I am using this DB since last 3 or 4 years. And suddenly we can't update it.
We are planning it at the end of year. Recently we faced the template1
wraparound issue. So we added template1 also for vacuuming. We are
vacuuming the DB each hour with 'vacuumdb --analyze -a' options.
Now the vacuuming o
Steve Atkins writes:
> On Apr 22, 2013, at 11:19 AM, Josh Berkus wrote:
>> On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
>>> On Apr 22, 2013, at 1:29 AM, Josh Berkus wrote:
I've heard a rumor that the most recent update of OSX "mountain lion"
lowers the installed SHMMAX to 4MB, which
On Apr 22, 2013, at 11:19 AM, Josh Berkus wrote:
> On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
>>
>> On Apr 22, 2013, at 1:29 AM, Josh Berkus wrote:
>>
>>> Folks,
>>>
>>> I've heard a rumor that the most recent update of OSX "mountain lion"
>>> lowers the installed SHMMAX to 4MB, which pr
On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
>
> On Apr 22, 2013, at 1:29 AM, Josh Berkus wrote:
>
>> Folks,
>>
>> I've heard a rumor that the most recent update of OSX "mountain lion"
>> lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from
>> installing. Can anyone verify this?
On 22.04.2013 19:48, Anne Rosset wrote:
Hi,
We are seeing some overall performance degradation in our application since we
installed the security release. Other commits were also done at the same time
in the application so we don't know yet if the degradation has any relationship
with the secu
Hi,
We are seeing some overall performance degradation in our application since we
installed the security release. Other commits were also done at the same time
in the application so we don't know yet if the degradation has any relationship
with the security release.
While we are digging into th
On 04/22/2013 07:31 AM, pradeep singh wrote:
Hi,
I am using postgresql 8.1 DB.
Why are you using a release of Postgres that is way out of date and
unsupported?
cheers
andrew
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscri
Hi,
I am using postgresql 8.1 DB.
I have a large DB and i run the vacuum every hour with "vocuumdb
--analyze -a" option.
Some times template1 consumes much time in comparison to my own DB.I
think at these times the load on OS is higher. But from iostat logs i
can see that the load on the partitio
W dniu 2013-04-21 19:28, Scott Marlowe pisze:
My DB version is little old - 8.1.18.
Well upgrade as soon as possible. 9.1 is pretty darn stable.
Scott,
excuse me this somewhat off-topic question.
Good to hear that 9.1 is so stable, because this is what I currently use in production. But why