On 3/24/2014 7:45 AM, Álvaro Nunes Lemos Melo wrote:
- New: Xeon E5-2430 2.20GHz
- Old: Xeon X3470 2.93GHz
Memory: 8 GBs
note your OLD server was faster per gigahertz. Intel PR not
withstanding, GHz remains more important for single threaded performance
than about anything else. the addi
On Monday, March 24, 2014, Álvaro Nunes Lemos Melo
>
wrote:
> Jeff: I ran a VACUUM FULL ANALYZE and retested. No significative change
> was notices, the explain is availiable in
>
> 9.3 - After VACUUM FULL ANALYZE - http://explain.depesz.com/s/rVoW
> 9.3 - Original - http://explain.depesz.com/s/Vw
Jeff: I ran a VACUUM FULL ANALYZE and retested. No significative change was
notices, the explain is availiable in
9.3 - After VACUUM FULL ANALYZE - http://explain.depesz.com/s/rVoW
9.3 - Original - http://explain.depesz.com/s/Vwt
Adrian: I'll try to send the query attached. My doubts are: why
Hi Ken,
With that level of dinamism of application servers where there is no way to
keep consistency among them , as you say concurrency must be turned into a
single thread to make sure schema migration will not be locked up by
application threads .
Have you though about constraining connections
thks for committing this into 9.4 Also great decision to resolve what
to us was some confusion between the json vs hstore choice. My decision
to move our products to postgresql looks better every day.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
On Mon, Mar 24, 2014 at 7:45 AM, Álvaro Nunes Lemos Melo <
al_nu...@atua.com.br> wrote:
> ==> Venkata
> > After the migration to hardware and to the new version 9.3, any changes
> have been done in the postgresql.conf compared to the old settings ?
> No, as I wrote initially, I'd double checked a
> Do you really need to allow web server connections to the database during a
> schema migration ? Why not locking them up either with pg_hba.cong or a
> firewal rule or symply shut it off temporarily ?
So this would be ideal if we could control the situation 100%, to be
clear our software is a sh
On Mar 24, 2014, at 9:43 AM, Alvaro Herrera wrote:
> Jerry Levan wrote:
>> The other day I attempted to connect to my 9.3.2 postgresql data base and my
>> connection
>> attempts kept failing.
>>
>> I found about 10 lines in the log file that looked like:
>>
>> ERROR: could not seek to en
Hi Ken,
Do you really need to allow web server connections to the database during a
schema migration ? Why not locking them up either with pg_hba.cong or a
firewal rule or symply shut it off temporarily ?
Cheers,
A.A.
On Fri, Mar 21, 2014 at 10:46 AM, Ken Barber wrote:
> Hi there,
>
> I was j
Hello
User defined exceptions should to use "U0" class
We don't use it - but it should be documented.
I proposed it -
http://www.postgresql.org/message-id/pine.lnx.4.44.0506160954430.8754-100...@kix.fsv.cvut.cz
but our implementation is less restrictive
Regards
Pavel Stehule
2014-03-24 2:4
Jerry Levan wrote:
> The other day I attempted to connect to my 9.3.2 postgresql data base and my
> connection
> attempts kept failing.
>
> I found about 10 lines in the log file that looked like:
>
> ERROR: could not seek to end of file "global/12292": Too many open files
> LOG: out of fi
On Mar 24, 2014, at 11:30 AM, Sergey Konoplev wrote:
> On Mon, Mar 24, 2014 at 9:14 AM, Jerry Levan wrote:
>> ERROR: could not seek to end of file "global/12292": Too many open files
>> LOG: out of file descriptors: Too many open files; release and retry
> [...]
>> Any idea what the problem c
On Mon, Mar 24, 2014 at 9:14 AM, Jerry Levan wrote:
> ERROR: could not seek to end of file "global/12292": Too many open files
> LOG: out of file descriptors: Too many open files; release and retry
[...]
> Any idea what the problem could have been?
Well, it tells for itself. It is out of file d
The other day I attempted to connect to my 9.3.2 postgresql data base and my
connection
attempts kept failing.
I found about 10 lines in the log file that looked like:
ERROR: could not seek to end of file "global/12292": Too many open files
LOG: out of file descriptors: Too many open files
On 03/24/2014 07:45 AM, Álvaro Nunes Lemos Melo wrote:
Firstly, I'd like to thanks all of you guys for your help. Below, I'll try to
provide all the information you asked. I know the query I'm testing could be
improved, but I used it because it's not that fast that is hard to measure
neither s
Vito wrote:
> I'm recently doing some research with Apache ODE engine. I use Postgresql as
> its external database,
> openjpa as its ORM solution and bitronix as its transaction manager. The ODE
> workflow engine starts
> without any problem. But when I deploy process definition files into the
>
Firstly, I'd like to thanks all of you guys for your help. Below, I'll try to
provide all the information you asked. I know the query I'm testing could be
improved, but I used it because it's not that fast that is hard to measure
neither so slow (another report query took about 4 minutes on 9.2
On 03/24/2014 07:05 AM, Vito wrote:
Hi all,
I'm recently doing some research with Apache ODE engine. I use
Postgresql as its external database, openjpa as its ORM solution and
bitronix as its transaction manager. The ODE workflow engine starts
without any problem. But when I deploy process defini
Hi all,
I'm recently doing some research with Apache ODE engine. I use Postgresql as
its external database, openjpa as its ORM solution and bitronix as its
transaction manager. The ODE workflow engine starts without any problem. But
when I deploy process definition files into the engine, the exc
Granthana Biswas writes:
> Version is PostgreSQL 9.1.4.
You do realize you're missing almost two years' worth of bug fixes?
The current release in that branch is 9.1.13, and a quick look through
the git history shows quite a number of replication-related fixes.
One that seems particularly notabl
Ilya Ivanov writes:
> I need to find all active (status=0) items not belonging to any active
> trigger. The best I could come up with is this:
> select count(itemid) from items where status='0' and itemid not in (select
> cast(regexp_matches(expression,'{([^}]+)}','g') as integer) from triggers
>
Sergey,
Version is PostgreSQL 9.1.4.
max_standby_archive_delay = 120s
max_standby_streaming_delay = 180s
Long running activity or idle in transactions are not there on either
master or slave as we stop all connections to both the DBs during vacuum.
Regards,
Granthana
On Fri, Mar 21, 2014 at
I need some help with a query. I've the following tables structure:
# select triggerid,expression,status from triggers
triggerid | expression | status
19298| {23033}=0 | 0
17041| {20211}#0 | {20210} | 1
18875| {22975}
On Sun, 23 Mar 2014 20:58:03 -0300 (BRT)
Álvaro Nunes Lemos Melo wrote:
> Hi,
>
> Recently, I've been trough a datacenter migration, and in this
> operation I'd also upgraded my PostgreSQL version from 9.2 to 9.3. My
> new hardware is slightly better than the old one, but the PostgreSQL
> perfor
On 24 Mar 2014, at 5:32, Rajeev rastogi wrote:
> On 21st March 2014, Ashmita Jain Wrote:
>
> >It is taking date as an empty string.
> >Try defining the empty field as ‘\N’ in your source file.
>
> ‘\N’ in copy source file always results into an empty string (unless
> something written in ne
25 matches
Mail list logo