Hi Simon,
thanks for the suggestion. What kind of space savings should I expected
from turning off full_page_writes? The servers have battery-backed
write-caches for the disk controllers, so it should be safe to give this
a try. Does turning off full_page_writes have any other effect on the
da
On Mon, 2010-03-15 at 11:27 +0200, Nicos Panayides wrote:
> thanks for the suggestion. What kind of space savings should I expected
> from turning off full_page_writes?
Substantial, though you should measure it and see, since it is workload
dependent.
--
Simon Riggs www.2ndQuadrant
I need to get a copy of the 8.4.2 Linux 64 bit One Click Installer instead of
8.4.3. The plan is to install the 8.4.2 and then test our Patching procedures
when upgrading to 8.4.3.
Thanks,
Sandra Arnold
Sr. Database Admin
DOE/OSTI
I've got about 44GB of data in a few hundred production databases. I'm using PG
8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I
know. I wish it were, and it's slated here for q2, but I cannot even apply
maintenance patches without a full testing cycle.
My aut
When migrating our Postgres databases from 32 to 64-bit systems, including
large binary objects, how well will this work?
32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb
64-bit server) pg_restore -d mydb backup.pg
I'm hoping that PG's compressed custom archive format is
I've got about 44GB of data in a few hundred production databases. I'm using PG
8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I
know. I wish it were, and it's slated here for q2, but I cannot even apply
maintenance patches without a full testing cycle.
My auto-v
how to get notification in front end application when ever postgre DB table
is modified, any tool, jar, api available?
thanks & regards
seetharaman. j
I've got about 44GB of data in a few hundred production databases. I'm using PG
8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I
know. I wish it were, and it's slated here for q2, but I cannot even apply
maintenance patches without a full testing cycle.
My auto
"Matt Janssen" writes:
> When migrating our Postgres databases from 32 to 64-bit systems, including
> large binary objects, how well will this work?
> 32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb
> 64-bit server) pg_restore -d mydb backup.pg
Should be fine; but remember that o
seetharaman jayaraman wrote on 15.03.2010 10:13:
how to get notification in front end application when ever postgre DB
table is modified, any tool, jar, api available?
thanks & regards
seetharaman. j
Have a look at listen/nofify
http://www.postgresql.org/docs/current/static/sql-listen.html
Th
Hi All,
Due to some historical idiosyncracies in our environment, we have a custom
8.3.7 database installation built from source. We'd like to install dblink
into this, however there are some problems with doing so:
1) the 8.3.7 database was built on a CentOS 4 build box that has since gone aw
Scott Whitney wrote:
> So, my questions are:
>
> a) Is the manual vacuum needed for performance reasons, or is auto-vac
> sufficient?
> b) How do my settings look?
> c) Is there a way that the clogs get cleared via autovac, would a full vac of
> just template1/template0 (if that last is poss
David Jantzen writes:
> Due to some historical idiosyncracies in our environment, we have a custom
> 8.3.7 database installation built from source. We'd like to install dblink
> into this, however there are some problems with doing so:
> 1) the 8.3.7 database was built on a CentOS 4 build box
Thanks for the detailed response. We'll look at upgrading to 8.3.9 from an RPM.
On Mar 15, 2010, at 6:01 PM, Tom Lane wrote:
> David Jantzen writes:
>> Due to some historical idiosyncracies in our environment, we have a custom
>> 8.3.7 database installation built from source. We'd like to ins
On Mon, 2010-03-15 at 19:25 -0700, David Jantzen wrote:
> We'll look at upgrading to 8.3.9 from an RPM.
FWIW 8.3.10 was released today.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, d
15 matches
Mail list logo