Christopher Kings-Lynne wrote:
I couldn't agree more. Look at this very instance. He now found the
right reindex command and the corrupted file is gone. We don't have the
slightest clue what happened to that file. Was it truncated? Did some
other process scribble around in the shared memory? Ho
I couldn't agree more. Look at this very instance. He now found the
right reindex command and the corrupted file is gone. We don't have the
slightest clue what happened to that file. Was it truncated? Did some
other process scribble around in the shared memory? How do you tell now?
The end user
That is the current status, but this is a very active project and I
believe the cvs version is much better.
You are correct though it is an embedded db, and as such is quite cool.
The reason I suggested it was more of an academic exercise for folks who
wanted to see the issues with doing this in
I just wanted to share that we're on the brink of having an automated
test on our Scalable Test Platform (http://www.osdl.org/stp/) that
features our DBT-2 workload, a fair use implementation of the TPC-C,
that uses PostgreSQL 7.4 and LVM2 on Linux on our 8-processor systems.
Currently the test on
Jan Wieck wrote:
> Tom Lane wrote:
> > Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> >> Is there anything stopping us going through the code and finding all
> >> ereports that can be fixed by a REINDEX, and issue a HINT with all of
> >> them saying that they should REINDEX the broken inde
On Tue, 2003-12-09 at 12:32, Andrew Dunstan wrote:
> PL/Java would be way cool, though, and have
> very significant appeal, and is very much worth doing, I believe. (Not
> that I have the time to do it.)
>
http://pljava.sourceforge.net/
Someone did it but it didn't catch fire.
Robert Treat
--
Teodor Sigaev kirjutas T, 09.12.2003 kell 23:07:
> Urmo wrote:
> > Hi,
> >
> > there seems to be no way of searching partial matches with tsearch.
> > Would it be hard to implement prefix based matching, i.e.
> > "hu" matches "human", "humanity", "humming", "huge"? With some hacking I
> > manage
--On Tuesday, December 09, 2003 23:13:15 +0100 Peter Eisentraut
<[EMAIL PROTECTED]> wrote:
Larry Rosenman wrote:
Do we need to reinitdb to pick this up, or just run this file?
It's actually described in the release notes:
Thanks!
Thats what I get for not reading the SGML stuff.
quickie script
Larry Rosenman wrote:
> Do we need to reinitdb to pick this up, or just run this file?
It's actually described in the release notes:
If you want to install the fixes in the information schema
concerning the bit types, you need to reload the information
schema. This is either acco
All right Tom,
I managed to get a trace:
Script started on Tue Dec 9 23:02:13 2003
# debug -c base/2308232/core.2509 39 /usr/local/pgsql/bin/postmaster
Avertissement: Fichier image mémoire tronqué
Erreur: Impossible de trouver le segment de mémoire associé à l'adresse
0xbfffd00c dans le process
Andrew Dunstan kirjutas T, 09.12.2003 kell 22:07:
> Dave Cramer wrote:
>
> >Have a look at Axion for a pure java db
> >
> >http://axion.tigris.org/
> >
> >Not as full featured,but still useful.
> >
> >
> >
>
> Er, I take it that "not as full featured" is an example of meiosis :-)
>
> Here's wh
Do we need to reinitdb to pick this up, or just run this file?
Curiousity.
--On Sunday, December 07, 2003 06:18:50 -0400 Peter Eisentraut - PostgreSQL
<[EMAIL PROTECTED]> wrote:
CVSROOT:/cvsroot
Module name:pgsql-server
Changes by: [EMAIL PROTECTED] 03/12/07 06:18:50
Mod
managed to disable morphology part from tsearch1 (database contained
multiple languages in a single table so morphology could not be used)
BTW, why? How many are languages in one record possible? tsearch V2 allows to
use many dictionaries for each type of lexeme and you can write your own
dicti
Urmo wrote:
Hi,
there seems to be no way of searching partial matches with tsearch.
Would it be hard to implement prefix based matching, i.e.
"hu" matches "human", "humanity", "humming", "huge"? With some hacking I
managed to disable morphology part from tsearch1 (database contained
multiple
We remain sceptical about writing an RDBMS in Java. The earlier
version of TelegraphCQ was in Java and turned out to be a bit of a
pain.
Some more information:
Mehul A. Shah, Samuel Madden, Michael J. Franklin, Joseph
M. Hellerstein: Java Support for Data-Intensive Systems: Experiences
Building
[EMAIL PROTECTED] (Ivelin Ivanov) writes:
> Has this subject been discussed before?
> I did not find any references to it in the archives.
>
> I think that a co-bundle between an open source J2EE
> container like JBoss and a scalable database like
> PostgreSQL will be a blast.
>
> There are several
Dave Cramer wrote:
Have a look at Axion for a pure java db
http://axion.tigris.org/
Not as full featured,but still useful.
Er, I take it that "not as full featured" is an example of meiosis :-)
Here's what the web page says:
Not (Yet) Supporte
Hello,
All due respect but this seems like a completely insane idea.
Sincerely,
Joshua Drake
Ivelin Ivanov wrote:
Has this subject been discussed before?
I did not find any references to it in the archives.
I think that a co-bundle between an open source J2EE
container like JBoss and a scalab
Dear Friends,
I am trying to modify the parser of the postgresql so as to print all the columns of a table (or to put them in a seperate file) when the parser meets an Insert Statement.
In the file (/src/backend/parser/gram.y) ,
InsertStmt: INSERT INTO qualified_name insert_rest{ $4
I tried :
select count('x') from patients;
And I get the same error.
select count('x'); should return the same as select count(*); which
returns 1.
Previous Postgres versions returned 1.
-ESR-
Peter Eisentraut wrote:
Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
Little important fact: it is not the indexing taking so long with FTS.
It is filling the fulltext table before creating indexes on it. I have
table A with with a column searchtext and trigger to create FTS records
of it in table cdsfti. So to fill the cdsfti table I did UPDATE A SET
oneintegerc
Hi,
there seems to be no way of searching partial matches with tsearch.
Would it be hard to implement prefix based matching, i.e.
"hu" matches "human", "humanity", "humming", "huge"? With some hacking I
managed to disable morphology part from tsearch1 (database contained
multiple languages in a
On Monday, December 8, 2003, at 08:29 AM, Tom Lane wrote:
I'm of the opinion that zlib
should not be typedef'ing a name as generic as "free_func", but if
they've made that part of their exported API, it might be hard for them
to change.
Yes, that was a mistake. However we're stuck with it to maint
Dear Friends,
I am trying to modify the parser of the postgresql so as to print all the columns of a table (or to put them in a seperate file) when the parser meets an Insert Statement.
During the parsing, i can have the relation name ( type: char *) but i cant find the way to get from the name
Hello,
I saw another post on this list about some conflicts on building an
rpm on redhat that seemed similar.
I wanted to add that I was building PHP with the individual directory
flags, (./configure --with-iodbc=/usr --with-pgsql=/usr/local ) and
the compiler still choked (see below).
Not su
Have a look at Axion for a pure java db
http://axion.tigris.org/
Not as full featured,but still useful.
Dave
On Tue, 2003-12-09 at 13:32, Andrew Dunstan wrote:
> D'Arcy J.M. Cain wrote:
>
> >On December 9, 2003 12:15 pm, Neil Conway wrote:
> >
> >
> >>P.S. While we're contemplating pies-in-t
D'Arcy J.M. Cain wrote:
On December 9, 2003 12:15 pm, Neil Conway wrote:
P.S. While we're contemplating pies-in-the-sky, I'd personally love to
rewrite PostgreSQL in Objective Caml.
I vote for InterCal. :-)
Pick your poison from this site: http://99-bottles-of-beer.ls-la.net/
(see es
Neil Conway wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
As a Java programmer, I do agree that having a pure Java RDBMS
system would be a Good Thing (tm)
Are there any advantages that this would provide that we could get
without investing so much effort? For example, PL/Java seems lik
On December 9, 2003 12:15 pm, Neil Conway wrote:
> P.S. While we're contemplating pies-in-the-sky, I'd personally love to
> rewrite PostgreSQL in Objective Caml.
I vote for InterCal. :-)
--
D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/
Tom,
> In general I am suspicious of proposals to rewrite queries into UNION
> "equivalents", because the "equivalent" usually isn't exactly
> equivalent, at least not without conditions that the planner can't
> easily prove.
As I said, I'm not sure that UNIONing the query is the solution, we jus
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Frank Wiles wrote:
>> Not to mention it would kill PostgreSQL's current speedy
>> performance!
> Maybe, maybe not. Modern JVMs have much better performance
> characteristics than was once the case. Also, some of the things
> that Java buys you (memory m
On Mon, 8 Dec 2003, Tom Lane wrote:
> Elliot Lee <[EMAIL PROTECTED]> writes:
> > http://archives.postgresql.org/pgsql-hackers/2000-07/msg00483.php
> > I'm having this same problem with postgresql 7.3.4.
>
> You aren't having the "same" problem, because that UNION bug was fixed
> ages ago.
You're
Frank Wiles wrote:
On Tue, 9 Dec 2003 07:15:41 -0800 (PST)
Ivelin Ivanov <[EMAIL PROTECTED]> wrote:
Has this subject been discussed before?
I did not find any references to it in the archives.
I think that a co-bundle between an open source J2EE
container like JBoss and a scalable database like
It would be interesting to have a JBoss, PostgreSQL and the JDBC driver for
PostgreSQL all bundled together in a single installation script.
Keith
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ivelin Ivanov
Sent: Tuesday, December 09, 2003 9:16 AM
To: [
Josh Berkus <[EMAIL PROTECTED]> writes:
> Summary: Currently, queries with complex "or group" criteria get devolved by
> the planner into canonical and-or filters resulting in very poor execution on
> large data sets. We should find better ways of dealing with these queries,
> for example UNION
Ivelin Ivanov <[EMAIL PROTECTED]> writes:
> Has this subject been discussed before?
> I did not find any references to it in the archives.
I think the phrase "not gonna happen" was invented for this subject. :)
-Doug
---(end of broadcast)---
TIP 5
On Tue, 9 Dec 2003 07:15:41 -0800 (PST)
Ivelin Ivanov <[EMAIL PROTECTED]> wrote:
>
> Has this subject been discussed before?
> I did not find any references to it in the archives.
>
> I think that a co-bundle between an open source J2EE
> container like JBoss and a scalable database like
> Postg
Has this subject been discussed before?
I did not find any references to it in the archives.
I think that a co-bundle between an open source J2EE
container like JBoss and a scalable database like
PostgreSQL will be a blast.
There are several well performing comercial Java dbs
out there and there
-- Forwarded message --
Date: Tue, 9 Dec 2003 12:55:55 +0100
From: Ferdinand Smit <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [ADMIN] Full textsearch & gist
Hi,
I'm experimenting with tsearch2. It works very good, but i have a few
questions:
- Is there a tsearch maillingslis
Tom Lane wrote:
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
Is there anything stopping us going through the code and finding all
ereports that can be fixed by a REINDEX, and issue a HINT with all of
them saying that they should REINDEX the broken index?
How would you know which ones corre
Hi Neil and Tom
On Mon, 8 Dec 2003, Neil Conway wrote:
> Date: Mon, 08 Dec 2003 22:44:42 -0500
> From: Neil Conway <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: Tom Lane <[EMAIL PROTECTED]>,
> pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] 73.5 and uw 713
>
> [EMAIL PROTE
Hello hackers
Is there a plan to mirror logfiles or/and controlfiles for the new
version of PostgreSQL? Or do you think it is not that important for HA?
Regards Oli
---
Oli Sennhauser
Database-Engineer (Oracle & PostgreSQL)
Rebenweg 6
CH - 86
Bruce Momjian wrote:
Guys, where are we on tablespaces? Should I set up a project page or
does it need organization? I think we need to define the command syntax
and then implementation details. I don't think it is that hard and
certainly is possible for 7.5.
There was a offlist group communi
43 matches
Mail list logo
