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
On Sun, May 10, 2015 at 12:30 PM, Yuri Budilov
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 compression available o
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 compres
* 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 p
* 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.
>
> http://www.enterprisedb.com/solutions/oracle-compatibility-tec
Stephen Frost 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 CPU t
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
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
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
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 c
On Thu, 07 May 2015 10:07:44 +0300
? 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 is
> enabled.
On Fri, May 8, 2015 at 2:29 PM James Sewell
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'
> restore_comman
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 g
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
> Ora
14 matches
Mail list logo
