This message has been digitally signed by the sender.
RES___GENERAL__Does_postgresql_9_0_4_use_index_on_PREFIX_SUFFIX_queries_.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
if this "intermitent link" scenario is already covered
(perhaps in later releases), or this is something we cannot foresee/deal
with?
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On 23-04-2015 16:55, Marc-André Goderre wrote:
Hello, I'm processing a 100Million row table.
I get error message about memory and I'ld like to know what can cause this
issue.
...
psql:/home/ubuntu/create_topo.sql:12: NOTICE: 104855000 edges processed
psql:/home/ubuntu/create_topo.sql:12: NOTI
sent in smaller sizes as well?
I've not found this information in docs.
Thanks,
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks, Adrian.
That's the reference I was looking for.
Atenciosamente,
Edson Carlos Ericksson Richter
Em 29/06/2015 15:55, Adrian Klaver escreveu:
On 06/29/2015 11:49 AM, Edson Richter wrote:
Dear community,
I'm using PostgreSQL 9.3.6 on Linux x64.
Would sound a stupid ques
Dear all,
Another question about WAR archiving: what is the "resend policy" if
remote storage runs out of space?
The failed archives will be resend automatically in future, or there is
need for manual interation?
Thanks,
--
Atenciosamente,
Edson Carlos Ericksson Richter
-
Hi!
I've a situation where I would like to keep sync replication, where servers
have 10Mbps network connection but high latency (normally, ~20ms but sometimes,
1000ms~2000ms, even 3000ms when network is under load).
Considering that I will keep enough WAL files (let's say, 200 WAL segments on a
Em 13/08/2015 00:40, Joshua D. Drake escreveu:
On 08/12/2015 05:33 PM, Edson Richter wrote:
Hi!
I've a situation where I would like to keep sync replication, where
servers have 10Mbps network connection but high latency (normally, ~20ms
but sometimes, 1000ms~2000ms, even 3000ms when ne
Any chance to get those amazing wonderful features backported to 9.4?
Thanks,
Edson
Enviado do meu smartphone Sony Xperia™
Madovsky escreveu
> Hi,
>
> I would like to fix a issue I'm facing of with the version 9.4 streaming
> replication.
> is it possible to set on the fly the synchronous commit on the master
> (or standby?)
> which only sync commit the hot standby node used by the client who has a
> r
it effective?
Or a complete restart is required?
Thanks,
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Adrian Klaver escreveu
> On 10/27/2015 07:29 PM, Edson Richter wrote:
> > Hi!
> >
> > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3
> > 20140911, installed using yum repository.
> >
> > In postgresql.conf, I do ha
Thanks, Tom.
I'll play a bit with this in a development server.
Regards,
Atenciosamente,
Edson Carlos Ericksson Richter
Em 28/10/2015 12:06, Tom Lane escreveu:
Adrian Klaver writes:
No, if the above does not indicate a problem, then the issue is
probably, as Francisco said, i
Perfect explanation and indeed useful suggestions.
I'll play a bit with a development server.
Thanks,
Atenciosamente,
Edson Carlos Ericksson Richter
Em 28/10/2015 12:15, Yves Dorfsman escreveu:
On 2015-10-27 20:29, Edson Richter wrote:
Hi!
Using PostgreSQL 9.3.10 x86_64 Oracle EL7 com
ced records can be in my deletion.
Has anyone faced a behavior like this?
Am I doing something wrong?
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Em 13/06/2016 22:33, Edson Richter escreveu:
I've a table "A" with 4,000,000 records.
I've decided to delete records from oldest to newest but I can't
delete records that have references in tables "B", "C" or "D".
so, I've
Em 13/06/2016 23:18, rob stone escreveu:
On Mon, 2016-06-13 at 22:41 -0300, Edson Richter wrote:
Em 13/06/2016 22:33, Edson Richter escreveu:
I've a table "A" with 4,000,000 records.
I've decided to delete records from oldest to newest but I can't
delete records that
Em 13/06/2016 23:36, Edson Richter escreveu:
Em 13/06/2016 23:18, rob stone escreveu:
On Mon, 2016-06-13 at 22:41 -0300, Edson Richter wrote:
Em 13/06/2016 22:33, Edson Richter escreveu:
I've a table "A" with 4,000,000 records.
I've decided to delete records from oldest t
Em 14/06/2016 01:33, David G. Johnston escreveu:
On Monday, June 13, 2016, Edson Richter <mailto:edsonrich...@hotmail.com>> wrote:
Em 13/06/2016 23:36, Edson Richter escreveu:
Em 13/06/2016 23:18, rob stone escreveu:
On Mon, 2016-06-13 at 22:41 -0300, Edson Richter wrote
Em 14/06/2016 10:32, David G. Johnston escreveu:
On Tue, Jun 14, 2016 at 12:51 AM, Edson Richter
mailto:edsonrich...@hotmail.com>>wrote:
Em 14/06/2016 01:33, David G. Johnston escreveu:
On Monday, June 13, 2016, Edson Richter mailto:edsonrich...@hotmail.com>> wrote:
Em 14/06/2016 12:02, Edson Richter escreveu:
Em 14/06/2016 10:32, David G. Johnston escreveu:
On Tue, Jun 14, 2016 at 12:51 AM, Edson Richter
wrote:
Em 14/06/2016 01:33, David G. Johnston escreveu:
On Monday, June 13, 2016, Edson Richter
mailto:edsonrich...@hotmail.com>>
efore decided to migrate all systems to PostgreSQL.
My personal experience is that MySQL is excellent for data that is not
sensitive (web site, e-mail settings, etc). Everything else goes to
PostgreSQL (or Oracle, or MS SQL Server, or Sybase, or DB2 - in *my*
order of preference).
Regards,
Edson Richter
ists, please kindly point me to the docs. If
not, please consider adding this in a future release.
Thanks,
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> Subject: Re: [GENERAL] Proposal "stack trace" like debugging option in
> PostgreSQL
> To: edsonrich...@hotmail.com; pgsql-general@postgresql.org
> From: adrian.kla...@aklaver.com
> Date: Sat, 30 Jul 2016 15:26:42 -0700
>
> On 07/30/2016 10:52 AM, Edson Ri
> From: t...@sss.pgh.pa.us
> To: edsonrich...@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Proposal "stack trace" like debugging option in
> PostgreSQL
> Date: Sun, 31 Jul 2016 11:56:11 -0400
>
> Edson Richter writes:
> > But
quot;since date... ", "from date ..." or
"planned" status...
You can split the table by bundle (basic /enterprise) so you will help your
visitors to better understand your offer...
Just my 2c.
Sorry for being off topic...
Edson Richter
I do use Dbwrench, but is pretty basic, no fancy procedures / function
development support.
Enviado do meu smartphone Sony Xperia™
Pavel Stehule escreveu
Hi
2016-09-03 11:36 GMT+02:00 Tim Uckun :
> Does anybody use an IDE for doing heavy duty stored proc development?
> PGadmin is de
ork around the problem
You could try running: rpm -Va --nofiles --nodigest"
(the "LANG=C" at beginning of the line is to force output in english, please
ignore it)
Have anyone faced similar issue or know how to correct this error?
Thanks in advance,
Edson Richter
On 02/10/2016 16:05, Adrian Klaver wrote:
> On 10/02/2016 10:52 AM, Edson Richter wrote:
>> Dear community,
>>
>>
>> I'm trying to install pgAdmin4 in Oracle EL 7.
>>
>> I've already installed PostgreSQL 9.6 final in same server (have EPEL
>&g
On 02/10/2016 17:04, Devrim Gündüz wrote:
> Hi,
>
> On Sun, 2016-10-02 at 17:52 +0000, Edson Richter wrote:
>> I'm trying to install pgAdmin4 in Oracle EL 7.
>>
>> I've already installed PostgreSQL 9.6 final in same server (have EPEL
>> enabled, as well
On 03/10/2016 10:12, Devrim Gündüz wrote:
> Hi Edson,
>
> On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote:
>> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server
>> -x86_64/repodata/repomd.xml:
>> [Errno 14] HTTPS Error 404 - Not F
ork around the problem
You could try running: rpm -Va --nofiles --nodigest"
(the "LANG=C" at beginning of the line is to force output in english, please
ignore it)
Have anyone faced similar issue or know how to correct this error?
Thanks in advance,
Edson Richter
Please, ignore this double post. It came from wrong e-mail address.
The issue is already being discussed in another discussion thread.
uires: libpython2.7_d.so.1.0()(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
If I can help on anything, please let me know.
Regards,
Edson
De: pgsql-general-ow...@postgresql.org
Devrim Gündüz escreveu
> Hi again,
>
> On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote:
> > It is not working, I get the following error:
> >
> > [root@backup1 yum.repos.d]# LANG=C yum install pgadmin4 pgadmin4-web
> > Loaded plugins: ulninfo
>
ere codigoocorrencia = '091'
and observacao is not null
order by datahoraimportacao DESC
Total results = 3826
Why is that?
Regards,
Edson Richter
> -Mensagem original-
> De: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Enviada em: sábado, 5 de novembro de 2016 15:21
> Para: Edson Richter
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL] Trouble with regexp_matches
>
> Edson Richter writes:
> > I’
> -Mensagem original-
> De: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
> Enviada em: sábado, 5 de novembro de 2016 15:13
> Para: Edson Richter ; pgsql-
> gene...@postgresql.org
> Assunto: Re: [GENERAL] Trouble with regexp_matches
>
> On 11/05/2016 10:01
data
type?
Thanks,
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to change the application (of course,
under the limits).
Atenciosamente,
Edson Carlos Ericksson Richter
Em 09/12/2015 21:17, Kevin Grittner escreveu:
On Wed, Dec 9, 2015 at 5:13 PM, Edson Richter wrote:
I do have several tables that uses varchar(2000) as store for remarks.
Lately, one cus
Em 15/12/2015 00:27, Jim Nasby escreveu:
On 12/9/15 5:43 PM, Edson Richter wrote:
Actually, the biggest change is that I don't have to keep another
constraint between app and database - if I want to increase the user
perceived space, now I just have to change the application (of course,
I think this is the nature of "async multi master"...
IMHO, It would be necessary to be "sync multi master" (with two-phase
commit?) to get the behavior you expect.
Atenciosamente,
Edson Carlos Ericksson Richter
Em 04/01/2016 18:09, Riley Berton escreveu:
I have been ex
mente,
Edson Carlos Ericksson Richter
Em 04/01/2016 18:09, Riley Berton escreveu:
I have been experimenting with BDR and have a question about how BDR
interacts with transactions.
bdrdemo=# create table thingy (id INT, value TEXT, PRIMARY KEY(id));
CREATE TABLE
bdrdemo=# create table tx_log(id IN
Em 05/01/2016 11:42, Riley Berton escreveu:
Edson Richter writes:
BTW, I'm also looking for a "synchronous multi-master" solution... If
you find one, please share :-)
The only solution I've found so far is a middleware that is close, the
C-Jdbc/Sequoia, which seem
;
cn.commit();
Something like that (I know sql syntax is wrong, this is just a lazy
example)...
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
aditional DBA interference.
Also, the tooling to help planning indices and test query performance is
really good, and the PgAdmin III has been good and quite strong (has
some flaws, but nothing that really interfere in its usage).
Regards,
Edson Richter
--
Sent via pgsql-general ma
0
I can easly read this XML in Notepad++, and also in Java - but
PostgreSQL always throw error.
Can you plase tell me how can make PostgreSQL ignore this malformed
xmlns and proceed processing the XML?
Thanks,
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via p
2016-02-12 1:53 GMT+01:00 Edson Richter <mailto:edsonrich...@hotmail.com>>:
Hi!
I've some (about 1M records) containing legacy XML I would like to
parse and apply XMLEXISTS.
This is the query:
select * from xmllog
where xpath_exists(('/
r multi-database systems with async
replication to avoid such "resync" problems?
Thanks for your orientation,
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Carlos Ericksson Richter
Em 10/03/2016 16:56, Andy Colson escreveu:
On 3/10/2016 1:41 PM, Edson Richter wrote:
Hi!
Using async replication between geographically database servers. I've
some 9.3 and some 9.4 servers, so doesn't matter the version (the only
reason I've not migrated al
Em 10/03/2016 17:18, Andy Colson escreveu:
please don't top post.
> Em 10/03/2016 16:56, Andy Colson escreveu:
On 3/10/2016 1:41 PM, Edson Richter wrote:
Hi!
Using async replication between geographically database servers. I've
some 9.3 and some 9.4 servers, so doesn't matte
something like "copy database A to B")?
I would like to run this everyday, overnight, with minimal impact to
prepare a test environment based on production data.
Thanks,
--
Atenciosamente,
Edson Carlos Ericksson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Same machine, same cluster - just different database name.
Atenciosamente,
Edson Carlos Ericksson Richter
Em 12/04/2016 11:46, John R Pierce escreveu:
On 4/12/2016 7:25 AM, Edson Richter wrote:
I have a database "Customer" with about 60Gb of data.
I know I can backup and restore
De: Adrian Klaver
Enviado:terça-feira, 12 de abril de 2016 12:04
Para: Edson Richter; pgsql-general@postgresql.org
Assunto: Re: [GENERAL] Fastest way to duplicate a quite large database
On 04/12/2016 07:51 AM, Edson Richter wrote:
> Same machine, same cluster - just different database name.
Em 12/04/2016 12:53, Edson Richter escreveu:
*De: *Adrian Klaver <mailto:adrian.kla...@aklaver.com>
*Enviado:*terça-feira, 12 de abril de 2016 12:04
*Para: *Edson Richter <mailto:edsonrich...@hotmail.com>;
pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.org&
Em 13/04/2016 11:18, Adrian Klaver escreveu:
On 04/13/2016 06:58 AM, Edson Richter wrote:
Another trouble I've found: I've used "pg_dump" and "pg_restore" to
create the new CustomerTest database in my cluster. Immediately,
replication started to replicate the
jects at programming side, and ORM works just so well,
it is a really waste of time (and other resources) to change systems
that are working well in the past 10 or more years.
Just my 2c,
Edson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
It is possible to define a global value/variable in PostgreSQL in a way that I
can use it in any query/view/function?For example, I do have a connection
string I use for dblink connections in several places (specially, inside
views).Then, if I want to change the connection string, I do have to c
Yes. It's similar, but consider I'm using a connection pool, so I''ve no control on when the connections are established/destroyed.I think I need something with scope broader than session... Atenciosamente,Edson Richter -- Mensagem original --De: John McKownData: 19/06/
hu, 19 Jun 2014 14:39:45 +
Yes. It's similar, but consider I'm using a connection pool, so I''ve no
control on when the connections are established/destroyed.I think I need
something with scope broader than session... Atenciosamente,
Edson Richter
-- Mensagem origi
(select 1 from QRY where country = QRY.country and state =
QRY.state)
Can I simplify the query by using some sort of window function or other
PostgreSQL feature I don't know yet?
Thanks,
Edson Richter
Would you please provide an example, even hypothetical? Atenciosamente,Edson Richter -- Mensagem original --De: David G Johnston Data: 04/07/2014 19h22Para: pgsql-general@postgresql.org;Assunto:Re: [GENERAL] Query "top 10 and others"Edson Richter wrote
> I would like to cons
Thanks!I'll investigate (explain) performance for both versions. Atenciosamente,Edson Richter -- Mensagem original --De: David Johnston Data: 04/07/2014 21h20Para: Edson Richter;Cc:pgsql-general@postgresql.org;Assunto:Re: Re : [GENERAL] Query "top 10 and others"> with
e for path and other things.
Can anyone point me what I've done wrong?
Thanks,|
--
Atenciosamente,
Edson Carlos Ericksson Richter
I've found this very useful:
http://people.planetpostgresql.org/devrim/index.php?/archives/82-Running-more-than-one-9.4-9.3-instance-in-parallel-on-RHEL-7.html
Atenciosamente,
Edson Carlos Ericksson Richter
On 10-11-2014 16:45, Edson Richter wrote:
Hi!
I've just received a new s
t;,
'1. nfe'::text as "tipo",
( select sum(arquivosimportados.contasucesso) as sum
Why does the same CREATE VIEW statement result in different source codes
in the server side?
Regards,
--
Atenciosamente,
Edson Carlos Ericksson Richter
as always!
Atenciosamente,
Edson Carlos Ericksson Richter
On 08-12-2014 16:53, Tom Lane wrote:
select version()
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 05-01-2015 10:02, Michael Paquier wrote:
On Mon, Jan 5, 2015 at 6:51 PM, Edson Carlos Ericksson Richter
wrote:
Would this kind of count being recorded somewhere else?
How does the server knows that the wal_segments have been exhausted?
You should evaluate the amount of wal_keep_segments
You mean union?
select 1 as t1
union
select 2 as t2
union
select 3 as t3
?
Atenciosamente,
Edson Carlos Ericksson Richter
On 29-01-2015 16:58, Sterpu Victor wrote:
Hello
Can I write a query where I receive a single result set from many queries?
Something like this: SELECT (SELECT 1 AS t1, 2
and nothing else
happens.
Thanks,
Edson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Em 13/01/2013 16:27, Shaun Thomas escreveu:
Hey guys,
I'm not sure the last time I saw this discussion, but I was somewhat curious:
what would be your ideal Linux distribution for a nice solid PostgreSQL
installation? We've kinda bounced back and forth between RHEL, CentOS, and
Ubuntu LTS, so
Em 14/01/2013 01:46, Scott Marlowe escreveu:
On Sun, Jan 13, 2013 at 4:06 PM, SUNDAY A. OLUTAYO wrote:
4 reasons:
1. One place where I worked Ubuntu was standard, I tried it and found
that it lacked at least a couple of desktop features in GNOME 2 that
I found very useful into Fedo
I was wondering, would be a nice addition the ability to read the chain
of triggers (may be another trigger variable like TG_OP, called
"TG_CHAIN" or something else that will be an array with the name of the
triggers called before current trigger).
Would help debug database triggers that have
Em 15/01/2013 21:36, Adrian Klaver escreveu:
On 01/15/2013 03:30 PM, Edson Richter wrote:
I was wondering, would be a nice addition the ability to read the chain
of triggers (may be another trigger variable like TG_OP, called
"TG_CHAIN" or something else that will be an array with t
Hi!
I'm debugging few triggers I wrote these days, and I can't see the
triggers statements being logged.
Probably I'm doing something wrong.
I just enabled
log_statement = 'all'
In postgresql.conf, but I can see all statements issued by my
application, but the statements in trigger don't sh
Em 16/01/2013 14:18, Tom Lane escreveu:
Pavel Stehule writes:
2013/1/16 Edson Richter :
I was wondering, would be a nice addition the ability to read the chain of
triggers (may be another trigger variable like TG_OP, called "TG_CHAIN" or
something else that will be an array with t
Em 16/01/2013 13:56, Edson Richter escreveu:
Hi!
I'm debugging few triggers I wrote these days, and I can't see the
triggers statements being logged.
Probably I'm doing something wrong.
I just enabled
log_statement = 'all'
In postgresql.conf, but I can see al
I've applyied both paths below to be able to print SQL Warnings when
loglevel=1 when working with JDBC 9.2.2 driver.
I did create this as separate driver compilation, because I don't want
the slowdown introduced in the addWarnings (that would affect
significantly my production servers).
Using th
I'm wondering why "varchar_opts" is not default operator class for all
indexed varchar field.
Is the impact to heavy?
Thanks for the clarification,
Edson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
Em 21/01/2013 17:18, Tom Lane escreveu:
Edson Richter writes:
I'm wondering why "varchar_opts" is not default operator class for all
indexed varchar field.
varchar has no operators of its own; it just relies on the operators for
type text. Therefore text_ops is the formally
Em 21/01/2013 18:03, Tom Lane escreveu:
Edson Richter writes:
I see. So, what is the overhead of having text_ops in opclass?
Can I define it as default for all my indexes when textual type of any kind?
Why are you intent on defining anything? IMO, best practice is to let
the database choose
Em 21/01/2013 18:36, Tom Lane escreveu:
Edson Richter writes:
Thanks, but I've found that some queries using LIKE operator uses table
scan instead index unless it is defined with varchar_ops in the index...
You mean varchar_pattern_ops? That's an entirely differ
my LIKE queries more
optmized.
Is there any way to define that this operator class is the default for
my database for varchar columns?
What would be the impact in terms of performance and memory consumption?
Thanks,
Edson Richter
--
Sent via pgsql-general mailing list (pgsql-general@pos
Em 22/01/2013 15:57, Edson Richter escreveu:
I'm rephrasing the question I posted yesterday, because I have used
the wrong terminology and caused confusion (and for instance, got no
response to my question).
Almost all indexed columns of kind varchar in my database re
Em 22/01/2013 18:04, Tom Lane escreveu:
Edson Richter writes:
Almost all indexed columns of kind varchar in my database require
"varchar_pattern_ops" op class in order to make my LIKE queries more
optmized.
Is there any way to define that this operator class is the default for
my da
You have two options:
st.execute("insert into hello values ('bKey', "+f1()+")");
or
PreparedStatement st = db.prepareStatement("insert into hello values
('bKey', ?)");
st.setInteger(1, f1());
where 1 is the first parameter, 2 is the seco
,
Edson Richter
Em 28/01/2013 17:09, Bob Futrelle escreveu:
Thanks to Edson and Dave for lightning responses.
I'm confident that your answers will do the job.
I'll follow up on the advice AFTER I get my coffee ;-)
I'm really focused on the NLP content of my research,
but I need a DB in
Hi!
Assumptions: PostgreSQL 9.2.2, Win64, already run vacumm full freeze
analyze. No problems in the database. I know there are 1247 records to
be found.
Why does these queries return different results:
select count(*) from parcela
where id not in (select parcela_id from cadastroservicoparce
Ok, I get it. Good education!
Thank you very much, saved me a big headache!
Edson
Em 03/02/2013 03:06, Pavel Stehule escreveu:
Hello
2013/2/3 Edson Richter :
Hi!
Assumptions: PostgreSQL 9.2.2, Win64, already run vacumm full freeze
analyze. No problems in the database. I know there are 1247
Em 04/02/2013 07:35, zeljko escreveu:
Edson Richter wrote:
Hi!
Assumptions: PostgreSQL 9.2.2, Win64, already run vacumm full freeze
analyze. No problems in the database. I know there are 1247 records to
be found.
Why does these queries return different results:
select count(*) from parcela
I don't know about ErWin. If you look
for alternatives that would include a tool change, then continue
reading.
I do use DBWrench, is working fairly well.
Prós:
- Multiple diagrams for same database/schema (can reduce the
amount of tables you ar
Em 24/02/2013 23:26, John R Pierce escreveu:
On 2/24/2013 6:20 PM, John R Pierce wrote:
On 2/24/2013 6:13 PM, Tom Duffey wrote:
- The Java app on production shows "10.3884573" while the test app
shows "10.3885"
'real' is single precision, which is only about 6 digits of decimal
accuracy. i
Em 24/02/2013 23:44, Adrian Klaver escreveu:
On 02/24/2013 06:13 PM, Tom Duffey wrote:
Hi Everyone,
Riddle me this. I have a database column of type "real" that gets
mapped to a Java field of type double via JDBC. We have two
databases, test and production, and the test database is periodical
Em 05/03/2013 16:01, Tom Duffey escreveu:
This conversation has moved beyond my ability to be useful but I want to remind
everyone of my original issues in case it helps you improve the docs:
1) Data shown in psql did not match data retrieved by JDBC. I had to debug
pretty deep into the JDBC c
I've two distant servers I would like to configure async replication
between.
Servers are running 9.2.4.
Since 9.0 days I do use script with rsync for transfer. And sometimes
the servers get out of sync (due large processing in master database and
huge network latency), and I have to reinitia
lot of lessons learned, I think I should write down somewhere.
On Mon, May 27, 2013 at 5:08 PM, Edson Richter wrote:
Since 9.0 days I do use script with rsync for transfer. And sometimes the
servers get out of sync (due large processing in master database and huge
network latency), and I have to
, May 27, 2013 at 5:08 PM, Edson Richter
wrote:
Since 9.0 days I do use script with rsync for transfer. And
sometimes the
servers get out of sync (due large processing in master database and
huge
network latency), and I have to reinitialize the standby server.
I think the use of PITRTools is
Em 21/08/2013 01:07, ascot.m...@gmail.com escreveu:
Hi,
I am planning Streaming Replication to a new remote server, can you please
suggest how to set up data encryption by SSL or tunnelling in Postgresql?
regards
I've implemented streaming replication using OpenVPN as encrypted
tunneling s
tarted the server, but seems those files (in number and in size)
are just growing and growing...
Regards,
Edson Richter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Em 28/09/2013 15:16, Edson Richter escreveu:
I've a 12Gb database running without problems in Linux Centos 64bit
for years now.
Looking database statistics (in pgAdmin III), I can see that there are
366 temporary files, and they sum up 11,863,839,867 bytes in size.
Is that normal? When
1 - 100 of 310 matches
Mail list logo
