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.
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
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:
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
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
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
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
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
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
> 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.
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,
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.
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 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
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
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
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
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
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
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
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
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 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
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
"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
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
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
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 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
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 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 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
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
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
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
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
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
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
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
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 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
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 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
43 matches
Mail list logo
