R: [HACKERS] [9.1] unusable for large views (SOLVED)

...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

R: [HACKERS] [9.1] unusable for large views (SOLVED)

to 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 o.bet...@informaticaindustriale.it writes: I

R: [HACKERS] [9.1] unusable for large views (SOLVED)

...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. --

[HACKERS] Monster query

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

[HACKERS] feature request

the 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

Re: [HACKERS] feature request

...could be STORE WHERE [condition] FROM [table] INTO [database] regards Omar Bettin - Original Message - From: Robert Haas robertmh...@gmail.com To: Omar Bettin o.bet...@informaticaindustriale.it Cc: pgsql-hackers@postgresql.org Sent: Thursday, February 25, 2010 11:11 PM Subject: Re

Re: [HACKERS] feature request

I have read that 8.5 will have replication, so is just a feature request. regards Omar Bettin - Original Message - From: Robert Haas robertmh...@gmail.com To: Omar Bettin o.bet...@informaticaindustriale.it Cc: pgsql-hackers@postgresql.org Sent: Thursday, February 25, 2010 11:22 PM

[HACKERS] diabolic state

I know you are i a C state but, A string plus a NULL string is A string mandi TOM

[HACKERS] NULL OR ZERO

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

[HACKERS] Strange behavior on plpgsql trigger function in if comparison

AND NOT NEW.Value IS NULL) THEN ... this works! Is that normal ? Thank you Omar Bettin

Re: [HACKERS] communication protocol

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 protocol

Re: [HACKERS] comunication protocol

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 system

Re: [HACKERS] comunication protocol

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

Re: [HACKERS] comunication protocol

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 doing exactly

[HACKERS] Hello

Hello!!! this is a test!

[HACKERS] comunication protocol

this 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