We are looking for advice on the RAID controller cards with battery back cache
for 10K SAS disks with RAID 10. Any suggestion for the best card and settings
to use for heavy write transactions.
See Sing
Whitepages.com
It is a discussion about the transaction ID wraparound in PostgreSQL.
However, what is the fundamental definition if transaction ID.
select * from table where ID=1:1
it is consider as one transaction or 1 transactions.
--
View this message in context:
I just upgraded to 9.1 and downloaded EnterpriseDB Tuning wizard, but the
list of servers in ComboBox support only 8.2, 8.3 i 8.4 version and x86
build. How can I tune 9.1, 64 bit version?
Is there any workaround, other version for download... ?
Any help?
Michael.
Hello,
Due to a large database size, my weekend database backup (pg_dumpall) takes
about 12 hours to complete. Additionally, I add the --no-unlogged-table-data
option to skip any volatile tables. One UNLOGGED table in the database is
completely regenerated every day with a TRUNCATE TABLE/INSERT
ddgs gsma...@gmail.com wrote:
It is a discussion about the transaction ID wraparound in
PostgreSQL.
Hopefully you've seen this:
http://www.postgresql.org/docs/current/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
However, what is the fundamental definition if transaction ID.
As
It is just a simple idea syntax, not the exact one.
Anyway, I am wonder how to get the 2^31 transaction IDs to cause the failure
But I get the wraparound error warning when I delete a large no. of rows.
So the wraparound failure is due to what reason, that I still have no idea
(at least not the
On 9 Březen 2012, 16:07, Michael Kopljan wrote:
I just upgraded to 9.1 and downloaded EnterpriseDB Tuning wizard, but the
list of servers in ComboBox support only 8.2, 8.3 i 8.4 version and x86
build. How can I tune 9.1, 64 bit version?
Is there any workaround, other version for download...
ddgs gsma...@gmail.com wrote:
It is just a simple idea syntax, not the exact one.
Then it doesn't seem possible to give an exact answer as to what it
will do. The effect on transaction IDs will depend on whether
you're talking about one DELETE statement with a range of values in
the WHERE
On 7 Březen 2012, 18:49, See Sing Lau wrote:
We are looking for advice on the RAID controller cards with battery back
cache for 10K SAS disks with RAID 10. Any suggestion for the best card
and settings to use for heavy write transactions.
It's hard to give you advices when we know nothing
Is it a good starting point to the basic reason of doing vacuum?
from the manual,
PostgreSQL's VACUUM command must be run on a regular basis for several
reasons:
To recover disk space occupied by updated or deleted rows.
To update data statistics used by the PostgreSQL query planner.
To protect
On Mon, Mar 12, 2012 at 10:03 AM, Tomas Vondra t...@fuzzy.cz wrote:
On 9 Březen 2012, 16:07, Michael Kopljan wrote:
I just upgraded to 9.1 and downloaded EnterpriseDB Tuning wizard, but the
list of servers in ComboBox support only 8.2, 8.3 i 8.4 version and x86
build. How can I tune 9.1, 64
On Mon, Mar 12, 2012 at 10:10 AM, Tomas Vondra t...@fuzzy.cz wrote:
On 7 Březen 2012, 18:49, See Sing Lau wrote:
We are looking for advice on the RAID controller cards with battery back
cache for 10K SAS disks with RAID 10. Any suggestion for the best card
and settings to use for heavy write
ddgs gsma...@gmail.com wrote:
Is it a good starting point to the basic reason of doing vacuum?
from the manual,
PostgreSQL's VACUUM command must be run on a regular basis for
several reasons:
To recover disk space occupied by updated or deleted rows.
To update data statistics used by the
On Mon, Mar 12, 2012 at 10:07 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Mon, Mar 12, 2012 at 10:03 AM, Tomas Vondra t...@fuzzy.cz wrote:
On 9 Březen 2012, 16:07, Michael Kopljan wrote:
I just upgraded to 9.1 and downloaded EnterpriseDB Tuning wizard, but
the
list of servers in
I'm using gin index for my full text search engine in production. These
days the gin index size grows to 20-30G and the system started to suffer
with periodical insert hanging. This is same as described in the 2 posts:
15 matches
Mail list logo