Re: [PERFORM] Inefficient escape codes.

2005-10-19 Thread Peter Childs
On 18/10/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > [Please copy the mailing list on replies so others can participate > in and learn from the discussion.] > > On Tue, Oct 18, 2005 at 07:09:08PM +, Rodrigo Madera wrote: > > > What language and API are you using? > > > > I'm using libpqxx. A

Re: [PERFORM] Inefficient escape codes.

2005-10-19 Thread Merlin Moncure
Rodrigo wrote: $$ As I understand it, the client needs to put the data into the server using a textual-based command. This makes the 5MB data grow up-to 5x, making it 25MB in the worst case. (Example: 0x01 -> \\001). My question is: 1) Is there any way for me to send the binary field directly wit

[PERFORM] Materializing a sequential scan

2005-10-19 Thread Steinar H. Gunderson
Hi, I'm using PostgreSQL 8.1 beta 3 (packages from Debian experimental), and I have a (rather complex) query that seems to take forever -- when the database was just installed, it took about 1200ms (which is quite good, considering that the 7.4 system this runs on today uses about the same time, b

Re: [PERFORM] Materializing a sequential scan

2005-10-19 Thread Tom Lane
"Steinar H. Gunderson" <[EMAIL PROTECTED]> writes: > I'm using PostgreSQL 8.1 beta 3 (packages from Debian experimental), and I > have a (rather complex) query that seems to take forever -- when the database > was just installed, it took about 1200ms (which is quite good, considering > that the 7.4

Re: [PERFORM] Materializing a sequential scan

2005-10-19 Thread Tom Lane
"Steinar H. Gunderson" <[EMAIL PROTECTED]> writes: > BEGIN > INSERT INTO kortsys2.mdb_gruppekobling_temp > SELECT overgruppe_id,undergruppe_id FROM gruppekobling gk > JOIN gruppe g1 ON gk.overgruppe_id=g1.gruppe_id > JOIN gruppe g2 ON gk.overgruppe_id=g2.grup