stored data is executed after such command the
database joins the stored data into the result query.
This can keep the production database lightweight and fast.
Regards
Omar Bettin
...could be
STORE WHERE [condition] FROM [table] INTO [database]
regards
Omar Bettin
- Original Message -
From: "Robert Haas"
To: "Omar Bettin"
Cc:
Sent: Thursday, February 25, 2010 11:11 PM
Subject: Re: [HACKERS] feature request
On Thu, Feb 25, 2010 at
I have read that 8.5 will have replication, so is just a feature request.
regards
Omar Bettin
- Original Message -
From: "Robert Haas"
To: "Omar Bettin"
Cc:
Sent: Thursday, February 25, 2010 11:22 PM
Subject: Re: [HACKERS] feature request
On Thu, Feb 25, 2
...sorry guys...
was a misconfiguration of database.
9.1.1 is working good.
is ~4% faster than 9.0.5 for same query.
Thanks a lot.
Regards
-Messaggio originale-
Da: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Inviato: lunedì 24 ottobre 2011 12:13
A: Omar Bettin
Cc: pgsql
everyone.
Regards,
Omar
-Messaggio originale-
Da: Tom Lane [mailto:t...@sss.pgh.pa.us]
Inviato: lunedì 24 ottobre 2011 16:46
A: Omar Bettin
Cc: pgsql-hackers@postgresql.org
Oggetto: Re: [HACKERS] [9.1] unusable for large views
"Omar Bettin" writes:
> I have tried 9.1.1 win6
...sorry guys...
was a bad configuration of database.
9.1.1 is working good.
is 4% to 8% faster than 9.0.5.
Thanks a lot.
Regards
Omar
P.s.
attached EXPLAIN
>Hmm. A 59-table join is pretty enormous
and is not the biggest, basically are delivery notes for one day seen in
vertical.
--
S
Hi,
Since the data are of third parties, will prepare a database suitable for the
purpose.
In any case, the compressed backup will be around 20 MB.
Regards,
Omar Bettin
-Messaggio originale-
Da: Jan Urbański [mailto:wulc...@wulczer.org]
Inviato: lunedì 24 ottobre 2011 18:56
A: Omar
Hello!!!
this is a test!
solution could speed up something?
For the moment I have big troubles to debug the server, have you some
informations how to debug it with MinGW?
Thanks and sorry form my english!
Omar Bettin
Merlin Moncure wrote:
On 8/8/07, Omar Bettin <[EMAIL PROTECTED]> wrote:
Hi,
I have installed postgresql to my client as a server for a progam
(libpq.dll/VCL based) that I wrote for them.
Every is working fine, but I noted some general slowness, compared with an
older database
Gustavo Tonini wrote:
Em Quarta 08 Agosto 2007 12:02, Omar Bettin escreveu:
Hi,
I have installed postgresql to my client as a server for a progam
(libpq.dll/VCL based) that I wrote for them.
Borland VCL? What component are you using?
Gustavo.
I use a strong modified
Merlin Moncure wrote:
On 8/9/07, Omar Bettin <[EMAIL PROTECTED]> wrote:
Merlin Moncure wrote:
AFAIK, the fastest possible way to get data off the server, skipping
all data and text processing is to write a SPI routine, and stream the
data out locally to the server. I am
Hannu Krosing wrote:
Ühel kenal päeval, N, 2007-08-09 kell 17:12, kirjutas Omar Bettin:
Why not just set up an ssh2 tunnel with both encryption and compression
and access your remote db over that ?
I know that possibility, but I'm just thinking probably an "ad hoc"
OLD.Value IS NULL AND NOT NEW.Value IS NULL)
THEN
...
this works!
Is that normal ?
Thank you
Omar Bettin
Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO.
I know about standards...
but I think that integralism is somewhat wrong.
Omar
a programmer...
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ign
I know you are i a C state but,
A string plus a NULL string is A string
mandi TOM
16 matches
Mail list logo