On 8/23/2010 12:11 PM, atul.g...@globaldatapoint.com wrote:
Hi,
Can cursors be returned to IBATIS. If so how. This is what I have written.
This does not work. Please help.
There is a dedicated mailing list for MyBatis (renamed from iBATIS) over
at http://www.mybatis.org. This questi
I'm currently playing with very large data import using COPY from
file.
As this can be extremely long operation (hours in my case) the nice
feature would be some option to show operation progress - how many
rows were already imported.
Or maybe there is some way to do it? As long as postgres have
On Wed, Aug 25, 2010 at 07:34, Tom Lane wrote:
> I wrote:
>> Cutting his value for shared_buffers (currently about 800MB) might be
>> wise too. I'm not sure what the effectively available address space
>> for a win32 process is, but if there's any inefficiency in the way
>> the address space is l
On 25/08/10 14:18, PMC OS wrote:
> Good morning,
>
>> -Ursprüngliche Nachricht-
>> Von: Craig Ringer
>> Honestly, in most cases you'll be much better off managing
>> authentication with LDAP. It's a better design for the nature of
>> authentication and user data management, where it has t
On 2010-08-25, wstrzalka wrote:
> I'm currently playing with very large data import using COPY from
file.
>
> As this can be extremely long operation (hours in my case) the nice
> feature would be some option to show operation progress - how many
> rows were already imported.
>
> Or maybe there
Hi Group,
I've never really learned how to optimize queries that join several tables
and have order by clauses that specify columns from each table. Is there
documentation that could help me optimize and have the proper indexes in
place? I've read through the PG Docs Chapter 11 on Indexes yet stil
I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname
>backupfilename.sql.gz. When i want to restore it ( I drop the old database
,creaete new and language to it and i type a command 'cat
backupfilename.sql.gz|gunzip|/usr/local/pgsql/bin/psql -U username dbname) this
backup
Le 25.08.2010 15:15, Łukasz Bieniek a écrit :
I'have made a backup my DB with pg_dump its (' pg_dump -U username
dbname>backupfilename.sql.gz. When i want to restore it ( I drop the old
database ,creaete new and language to it and i type a command 'cat
backupfilename.sql.gz|gunzip|/usr/local/p
Le 25.08.2010 09:15, wstrzalka a écrit :
I'm currently playing with very large data import using COPY from
file.
As this can be extremely long operation (hours in my case) the nice
feature would be some option to show operation progress - how many
rows were already imported.
Or maybe there is s
I am using pgsql9.0b4 (but pgsql8.4 exhibits the same behavior) on MacOS 10.6.4
and initdb fails:
/usr/local/pgsql90beta/bin/initdb -D /Volumes/Data/pgsql90b/ -E UTF8
The files belonging to this database system will be owned by user "agentm".
This user must also own the server process.
The datab
Hello,
I'm getting a strange error during reload of one of our databases. For the
past several weeks, we have been seeing the following error regularly, but
not necessarily with the same table. The pg_restore aborts after this error,
resulting in an incomplete reload. At first I thought it might b
On Wed, 2010-08-25 at 11:15 -0400, A.M. wrote:
> I am using pgsql9.0b4 (but pgsql8.4 exhibits the same behavior) on MacOS
> 10.6.4 and initdb fails:
> initdb: removing data directory "/Volumes/Data/pgsql90b"
>
> I would like to create the database space and then reduce the shared memory
> requir
On 25 August 2010 16:25, bricklen wrote:
> Hello,
>
> I'm getting a strange error during reload of one of our databases. For the
> past several weeks, we have been seeing the following error regularly, but
> not necessarily with the same table. The pg_restore aborts after this error,
> resulting i
On 2010-08-25, Joshua Berry wrote:
> Hi Group,
>
> I've never really learned how to optimize queries that join
> several tables and have order by clauses that specify columns
> from each table. Is there documentation that could help me
> optimize and have the proper indexes in place? I've read
>
On Aug 25, 2010, at 11:31 AM, Joshua D. Drake wrote:
> On Wed, 2010-08-25 at 11:15 -0400, A.M. wrote:
>> I am using pgsql9.0b4 (but pgsql8.4 exhibits the same behavior) on MacOS
>> 10.6.4 and initdb fails:
>> initdb: removing data directory "/Volumes/Data/pgsql90b"
>>
>> I would like to create
As a follow-up to my question from this past Saturday
(http://archives.postgresql.org/pgsql-general/2010-08/msg00624.php), I
experimented with adding two types of indices to the same text column:
CREATE INDEX item_eng_searchable_text_idx ON item USING
gin(to_tsvector('english', searchable_text));
On Wed, Aug 25, 2010 at 8:35 AM, Thom Brown wrote:
>
>
> Just seeking the obvious, but is the file you've shown being output
> with pg_dump the same one you're using on pg_restore? The paths are
> different, although if that's on 2 different machines, that would make
> perfect sense.
>
> --
> Th
On Wed, 2010-08-25 at 17:06 +0200, Denis BUCHER wrote:
> Le 25.08.2010 09:15, wstrzalka a crit :
> > I'm currently playing with very large data import using COPY from
> > file.
> >
> > As this can be extremely long operation (hours in my case) the nice
> > feature would be some option to show opera
"A.M." writes:
> Then it seems that the error reporting could be improved to not mention
> "shared_buffers" and "max_connections" neither of which I can touch during
> initdb.
The error has to be phrased to cover the case where you hit it after
initdb. It would be quite unhelpful to *not* ment
I wrote:
> Could we see the output of
> sysctl -a | grep sysv
"ipcs -a" might be informative, too.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On Wed, 2010-08-25 at 12:20 -0400, Eric Comeau wrote:
>
> > Without even changing any line of data or code in sql !
> >
> > Incredible, isn't it ?
> >
>
> Curious- what postgresql.conf settings did you change to improve it?
The most obvious would be to turn fsync off, sychronous_commit off,
i
On Wed, Aug 25, 2010 at 10:40 AM, Wappler, Robert wrote:
> On 2010-08-25, Joshua Berry wrote:
>
> > Here's my latest culprit:
> >
> > select Anl.Priority, Anl.Lab, Anl.Job, JOB.DateIn,
> > JOB.CompanyCode, Anl.SampleName
> > from analysis anl join job on anl.job = job.job
> > order by job.companyc
On 08/25/2010 12:30 PM, Joshua D. Drake wrote:
On Wed, 2010-08-25 at 12:20 -0400, Eric Comeau wrote:
Without even changing any line of data or code in sql !
Incredible, isn't it ?
Curious- what postgresql.conf settings did you change to improve it?
The most obvious would be to turn fsync
Yea - I'll try to optimize as I had a plan to write to
pgsql.performance for rescue anyway.
I don't know exact hardware specification yet - known facts at the
moment are:
Sun Turgo?? (SPARC) with 32 cores
17GB RAM (1GB for shared buffers)
hdd - ?
OS - Solaris 10 - the system is running in
Denis Papathanasiou writes:
> Is this because the gin/to_tsvector() index works differently for
> to_tsquery() compared to plainto_ts_query() ?
Not per se, but maybe looking at the actual outputs of the two function
calls would be enlightening. I suspect you'll find that the search
conditions yo
2010/8/25 Łukasz Bieniek :
> I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname
> >backupfilename.sql.gz. When i want to restore it ( I drop the old database
> ,creaete new and language to it and i type a command 'cat
> backupfilename.sql.gz|gunzip|/usr/local/pgsql/bin/psq
Hi!
2010/8/25 Łukasz Bieniek :
> I'have made a backup my DB with pg_dump its (' pg_dump -U username dbname
> >backupfilename.sql.gz. When i want to restore it ( I drop the old database
> ,creaete new and language to it and i type a command 'cat
> backupfilename.sql.gz|gunzip|/usr/local/pgsql/bi
bricklen writes:
> I'm getting a strange error during reload of one of our databases.
This appears to indicate that the server's first idea that there was
trouble came when the client side disconnected partway through a COPY:
> 2010-08-25 04:16:46 PDT [2401]: [1-1] (user=postgres) ERROR: unexpe
Not per se, but maybe looking at the actual outputs of the two function
calls would be enlightening. I suspect you'll find that the search
conditions you are getting are not equivalent.
Strictly speaking they're not, b/c the plainto_tsquery() is chaining
several tokens together.
However, a
On Wed, Aug 25, 2010 at 12:01 PM, Tom Lane wrote:
>
> bricklen writes:
> > I'm getting a strange error during reload of one of our databases.
>
> This appears to indicate that the server's first idea that there was
> trouble came when the client side disconnected partway through a COPY:
>
> > 201
I have an application in the product. Now, one status field needs to have three
statuses instead of two. How to make a such change in PostgreSQL?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-
On 25/08/2010 20:29, wei...@lycos.com wrote:
> I have an application in the product. Now, one status field needs to
> have three statuses instead of two. How to make a such change in
> PostgreSQL?
Perhaps an enumerated type?
http://www.postgresql.org/docs/8.4/static/datatype-enum.html
Ray.
On 08/25/2010 12:29 PM, wei...@lycos.com wrote:
I have an application in the product. Now, one status field needs to have three
statuses instead of two. How to make a such change in PostgreSQL?
I am going to assume that by binary you mean boolean. If so it already
has three states NULL,True,
> I am going to assume that by binary you mean boolean. If so it already has
> three states NULL,True,False.
Uh, not really, no. NULL indicates the absence or indeterminacy of a
state, and has a number of properties that make it unsuitable for
representing anything other than that.
Use an enum.
Denis,
we need examples of your explain analyze. I don't want to waste my time
reading theoretical reasoning :)
btw, Be sure you use the same search configuration as in create index or
index will not be used at all.
Oleg
On Wed, 25 Aug 2010, Denis Papathanasiou wrote:
As a follow-up to my qu
we need examples of your explain analyze. I don't want to waste my time
reading theoretical reasoning :)
Here's an actual 'explain analyze' example:
alerts=> CREATE INDEX node_val_tsv_idx ON node USING
gin(to_tsvector('english', val));
CREATE INDEX
alerts=> explain analyze select item_pk fr
Try this select
alerts=> explain analyze select item_pk from node where
tag='primaryIssuer.entityType' and val @@ plainto_tsquery('english','Limited
Partnership');
Read 12.2.2. Creating Indexes at
http://www.postgresql.org/docs/8.4/static/textsearch-tables.html
CREATE INDEX pgweb_idx ON pgwe
Denis Papathanasiou writes:
> alerts=> CREATE INDEX node_val_tsv_idx ON node USING
> gin(to_tsvector('english', val));
> CREATE INDEX
> alerts=> explain analyze select item_pk from node where
> tag='primaryIssuer.entityType' and val @@ plainto_tsquery('Limited
> Partnership');
> [ doesn't use t
Le 09/08/2010 20:04, Bill Christensen a écrit :
Hi folks,
I'm building a new server with postgres/phppgadmin, and having trouble
getting the dumps to work properly. This is my first time installing
> postgres, so I very well may have missed something.
>
Just to let y'all know, I got
Good evening,
> -Ursprüngliche Nachricht-
> Von: Craig Ringer
> >
> > Have now installed slapd on my OMAP L138 but now it has crashed the
> > kernel and I cna not more boot the server because it want o init
> > slapd and crash.
> That's ... surprising.
> Kernel panic? Or is it just that
On 08/25/10 11:47 AM, Wojciech Strzałka wrote:
The data set is 9mln rows - about 250 columns
Having 250 columns in a single table sets off the 'normalization' alarm
in my head.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On 26/08/2010 1:06 AM, Steve Clark wrote:
On 08/25/2010 12:30 PM, Joshua D. Drake wrote:
On Wed, 2010-08-25 at 12:20 -0400, Eric Comeau wrote:
Without even changing any line of data or code in sql !
Incredible, isn't it ?
Curious- what postgresql.conf settings did you change to improve it
You are right. I typed the message in hurry before I left home this morning. It
is the boolean type. Thanks for your suggestion. The NULL value may not work
for jdbc. On the application level, a fixed set of constants is used to
represent the three status, which are converted into an integer.
43 matches
Mail list logo
