MANY THANKS to everyone who replied !
Keep up great work!
more things (critical for very large and mission critical databases)
- database row/page compression -
it looks to me that there is no page/block compression available on PostgreSQL
9.4 along the lines of MS-SQL/Oracle row/page
On Sun, May 10, 2015 at 12:30 PM, Yuri Budilov yuri.budi...@hotmail.com
wrote:
MANY THANKS to everyone who replied !
Keep up great work!
more things (critical for very large and mission critical databases)
- database row/page compression -
it looks to me that there is no page/block
Maxim Boguk wrote:
database and transaction log backup compression? not available?
Transaction log backup compression not available (however could be easily
archived via external utilities like bzip2).
Well, in PostgreSQL you backup transaction logs by setting archive_command,
which is a
On 05/09/2015 06:33 AM, Stephen Frost wrote:
Temporary tables will be in memory unless they overflow work_mem and
we do support unlogged tables and tablespaces which you could stick
out on a ramdisk if you want.
I would suggest not putting a table space on a ramdisk. According to the
docs this
Hi Yuri,
I will try answer your questions one by one.
In the meantime, I have scanned the manual for PostgreSQL 9.4 and there are
a few things I was not able to find in the manual, my apologies if I missed
it:
1. does PostgreSQL have parallel query capability like MS-SQL 2008+ and
Oracle
On Thu, 07 May 2015 10:07:44 +0300
? ooo_satu...@mail.ru wrote:
I have postgresql 9.4 and glassfish 4.1. Besides I use MyBatis inside EJB.
Now I try to make select from table and this is what I get:
javax.resource.spi.LocalTransactionException:Cannot commit when autoCommit
Yuri Budilov wrote:
My employer is evaluating PostgreSQL as a possible replacement for Oracle 11g
R2 and
MS-SQL 2008 R2 for some systems.
I am completely new to PostgreSQL but experienced in MS-SQL and also in
Oracle 11g R2.
We need to establish what PostgreSQL is good at and not so good
On Fri, May 8, 2015 at 2:29 PM James Sewell james.sew...@lisasoft.com
wrote:
Hello All,
I am running 9.4 on Centos.
I have three servers, one master and two slaves. The slaves have the
following recovery.conf
standby_mode = 'on'
primary_conninfo = 'user=postgres host=mastervip port=5432'
Yuri, Maxim,
A few clarifications-
* Maxim Boguk (maxim.bo...@gmail.com) wrote:
In the meantime, I have scanned the manual for PostgreSQL 9.4 and there are
a few things I was not able to find in the manual, my apologies if I missed
it:
1. does PostgreSQL have parallel query capability
I might need to roll a custom PostgreSQL server RPM for my current
job.
Looking here:
https://wiki.postgresql.org/wiki/RPM_Packaging
The link to the specfiles and other data at
http://svn.pgrpms.org/repo/ gives a 404. I found a few other
pieces on the internet suggesting the same URL, and can't
Stephen Frost sfr...@snowman.net wrote:
Maxim Boguk (maxim.bo...@gmail.com) wrote:
6. does PostgreSQL support NUMA on Intel based X64 servers and
does it support Hyper-Threading ?
No NUMA support. Yes PostgreSQL will work on HT enabled servers
(will it be efficient - depend on workload and
* Melvin Davidson (melvin6...@gmail.com) wrote:
In addition to the other great comments and advice that have been posted,
you might want to review the Database Compatibility Technology for Oracle
document from EnterpriseDB.
* Jack Christensen (j...@jackchristensen.com) wrote:
On 05/09/2015 06:33 AM, Stephen Frost wrote:
Temporary tables will be in memory unless they overflow work_mem
and we do support unlogged tables and tablespaces which you could
stick out on a ramdisk if you want.
I would suggest not putting
In addition to the other great comments and advice that have been posted,
you might want to review the Database Compatibility Technology for Oracle
document from EnterpriseDB.
http://www.enterprisedb.com/solutions/oracle-compatibility-technology
On Sat, May 9, 2015 at 8:32 AM, Jack Christensen
14 matches
Mail list logo