pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: claudia.amorim@pcinformatica.com.br
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: claudia.amorim@pcinformatica.com.br, "Heikki Linnakangas" <heikki@enterprisedb.com>
Cc: pgsql-performance@postgresql.org
Cc: claudiacomput@hotmail.com
Subject: Re: Problems with PostGreSQL and Windows 2003
Date: Sun, 25 Nov 2007 14:19:03 -0200 (BRST)
Message-ID: <65447.189.5.149.224.1196007543.squirrel@smart> (raw )
In-Reply-To: <dcc563d10711250633r14f1dbbbx74c767d00f6dfac4@mail.gmail.com >
References: <50326.189.5.149.224.1195860047.squirrel@smart >
<4747E684.2000509@enterprisedb.com >
<50662.189.5.149.224.1195905625.squirrel@smart >
<58995.189.5.149.224.1195966621.squirrel@smart >
<dcc563d10711242225yd6438c2i18dea4b094705d91@mail.gmail.com >
<62578.189.5.149.224.1195994521.squirrel@smart >
<dcc563d10711250633r14f1dbbbx74c767d00f6dfac4@mail.gmail.com >
Hi,
I'm using a cursor.
Here is the a piece of log file (psqlodbc):
[0.000]conn=02DE3A70, PGAPI_DriverConnect(
in)='DSN=BI;UID=biuser;PWD=xxxxxxxxx;', fDriverCompletion=0
[0.000]DSN info:
DSN='BI',server='localhost',port='5432',dbase='BI',user='biuser',passwd='xxxxx'
[0.000]
onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0'
[0.000] conn_settings='',conn_encoding='(null)'
[0.000] translation_dll='',translation_option=''
[0.000]Driver Version='08.02.0400,200704270001' linking static Multithread library
[0.000]Global Options: fetch=100, socket=4096, unknown_sizes=0,
max_varchar_size=255, max_longvarchar_size=8190
[0.000] disable_optimizer=0, ksqo=1, unique_index=1,
use_declarefetch=1
[0.000] text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1 NAMEDATALEN=64
[0.000] extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding=''
[0.046] [ PostgreSQL version string = '8.2.5' ]
[0.046] [ PostgreSQL version number = '8.2' ]
[0.046]conn=02DE3A70, query='select oid, typbasetype from pg_type where typname
= 'lo''
[0.046]NOTICE from backend during send_query: 'SLOG'
[0.046]NOTICE from backend during send_query: 'C00000'
[0.046]NOTICE from backend during send_query: 'Mstatement: select oid,
typbasetype from pg_type where typname = 'lo''
[0.046]NOTICE from backend during send_query: 'Fpostgres.c'
[0.046]NOTICE from backend during send_query: 'L811'
[0.046]NOTICE from backend during send_query: 'Rexec_simple_query'
[0.046] [ fetched 1 rows ]
[0.046] [ Large Object oid = 17288 ]
[0.046] [ Client encoding = 'LATIN9' (code = 16) ]
[0.046]conn=02DE3A70,
PGAPI_DriverConnect(out)='DSN=BI;DATABASE=BI;SERVER=localhost;PORT=5432;UID=biuser;PWD=xxxxxxxxx;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=1;Optimizer=0;Ksqo=1;UseDeclareFetch=1;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;XaOpt=1'
[0.062]STATEMENT ERROR: func=set_statement_option, desc='', errnum=30,
errmsg='The option may be for MS SQL Server(Set)'
[0.062]
------------------------------------------------------------
[0.062] hdbc=02DE3A70, stmt=02DE85C8, result=00000000
[0.062] prepare=0, internal=0
[0.062] bindings=00000000, bindings_allocated=0
[0.062] parameters=02DE8F48, parameters_allocated=1
[0.062] statement_type=-2, statement='(NULL)'
[0.062] stmt_with_params='(NULL)'
[0.062] data_at_exec=-1, current_exec_param=-1, put_data=0
[0.062] currTuple=-1, current_col=-1, lobj_fd=-1
[0.062] maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
[0.062] cursor_name=''
[0.062] ----------------QResult Info
-------------------------------
[0.062]CONN ERROR: func=set_statement_option, desc='', errnum=0, errmsg='(NULL)'
[0.062]
Thanks,
Cláudia.
> Are you then trying to process the whole data set at once? I'm pretty
> certain the issue is your app, not pgsql, running out of memory.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
view thread (9+ messages) latest in thread
Message-ID: <65447.189.5.149.224.1196007543.squirrel@smart>
Permalink: ../65447.189.5.149.224.1196007543.squirrel@smart/
Also on: postgresql.org/message-id/65447.189.5.149.224.1196007543.squirrel@smart
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: claudia.amorim@pcinformatica.com.br, scott.marlowe@gmail.com, heikki@enterprisedb.com, claudiacomput@hotmail.com
Subject: Re: Problems with PostGreSQL and Windows 2003
In-Reply-To: <65447.189.5.149.224.1196007543.squirrel@smart>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox