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
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 partition
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
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
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
On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
On Apr 22, 2013, at 1:29 AM, Josh Berkus j...@agliodbs.com 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
On Apr 22, 2013, at 11:19 AM, Josh Berkus j...@agliodbs.com wrote:
On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
On Apr 22, 2013, at 1:29 AM, Josh Berkus j...@agliodbs.com wrote:
Folks,
I've heard a rumor that the most recent update of OSX mountain lion
lowers the installed SHMMAX to
Steve Atkins st...@blighty.com writes:
On Apr 22, 2013, at 11:19 AM, Josh Berkus j...@agliodbs.com wrote:
On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
On Apr 22, 2013, at 1:29 AM, Josh Berkus j...@agliodbs.com wrote:
I've heard a rumor that the most recent update of OSX mountain lion
lowers
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
