CLucene is one possibility:
http://sourceforge.net/projects/clucene/
Since you are asking in the PostgreSQL group, why not use the built-in full
text search:
http://www.postgresql.org/docs/8.4/static/textsearch.html
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresq
If you dont ever need to return the complete book text to a user (which
means, you only need the book text for your search indexes only), then keep
the text on file and use Apache Solr to index it.
regards
Sandeep
On Fri, Aug 20, 2010 at 1:05 AM, Miguel Vaz wrote:
>
> Hi,
>
> I need to make a d
Tatsuo Ishii wrote:
I know there is a Wiki on postgresql.org but I don't think it's for
external projects
Well, the external project related pages you've already worked on like
http://wiki.postgresql.org/wiki/Pgpool-II are valuable. I don't think
anyone would object to your extending that wi
Sam Nelson writes:
> Here's the output from pg_controldata:
> $ pg_controldata `pwd`
> WARNING: Calculated CRC checksum does not match value stored in file.
> Either the file is corrupt, or it has a different layout than this program
> is expecting. The results below are untrustworthy.
> pg_con
On Fri, 2010-08-20 at 09:26 +0900, Tatsuo Ishii wrote:
> Hi,
>
> Does anybody know if there is Wiki system or something like that on
> pgfoundry? I want to discuss/record the road maps, TODOs etc. on a
> wiki.
>
> I know there is a Wiki on postgresql.org but I don't think it's for
> external proj
Yes I do realise that temp_buffers is per backend. I set it like this because
we only have a few simultaneous clients connecting, and these clients generally
run large analysis queries that usually create big temp tables.
I turned on extra logging and I have tracked down the query that is crashi
Pgpool Global Development Group is pleased to announce the
availability of pgpool-II 3.0 beta1. In the mean time new version of
pgpoolAdmin, the GUI tool for pgpool-II, pgpoolAdmin 3.0 beta1 is
released.
Users are encouraged to take part in our beta test program.
pgpool-II 3.0 beta1/pgpoolAdmin 3.
Hi,
Does anybody know if there is Wiki system or something like that on
pgfoundry? I want to discuss/record the road maps, TODOs etc. on a
wiki.
I know there is a Wiki on postgresql.org but I don't think it's for
external projects.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co
I'm honestly not sure what I mean by that -- we didn't write that process.
I don't even know the intent of that process; they first told us that it
exists yesterday. I'll ask my boss to ask them for more details about it in
the morning.
We'll talk with 'em and see if they've done anything weird
Let me preface this by saying that I've set up warm standby instances quite
a few times. I think I sort of hopefully know what I'm doing.
pg_start_backup('stuff'), tar data directory, pg_stop_backup(), copy data
directory to warm standby server, extract in data directory, etc.
We have two CentOS
Sam Nelson writes:
>> It's almost certainly not ruby's fault. Have they done anything
>> strange like kill the instance and restart it without letting the db
>> shut down? I'd tend to suspect Amazon's fsyncing is amiss and they
>> did something that triggered it.
> They haven't done anything li
Sorry, I forgot to mention that we also tried reindexing the toast table.
On Thu, Aug 19, 2010 at 1:20 PM, Scott Marlowe wrote:
> SNIP
>
> It's almost certainly not ruby's fault. Have they done anything
> strange like kill the instance and restart it without letting the db
> shut down? I'd tend
>
> select a.ip, b.foo from tablea a, tableb b where a.id=b.id and
> not (a.ip <<= any (select network from assets where network is not null))
>
> regards, tom lane
Yes, that did it. I guess I'll have to hit the books again to fully grok what
you did. THANKS!
--- Let
Hello Sachin,
Thanks for reply. I will check that one out.
Thanks & Regards,
Vikram
From: Sachin Srivastava [mailto:sachin.srivast...@enterprisedb.com]
Sent: Tuesday, August 17, 2010 10:48 PM
To: Vikram Patil
Cc: j...@commandprompt.com; pgsql-general@postgresql.
Hi Igor,
http://wiki.postgresql.org/wiki/Running_&_Installing_PostgreSQL_On_Native_Windows#Why_do_I_need_a_non-administrator_account_to_run_PostgreSQL_under.3F
This says that it will give up administrative rights when we try to install as
administrator account. And it succeeds all windows plat
Hi,
I need to make a database of books. Several specific subject books that are
to be searchable.
Is it viable to have the complete book text on a database and search inside
it? Or should i consider keeping only its metadata (name, author, filename,
etc) on the DB, keep the book file on the HD an
On Thu, Aug 19, 2010 at 11:26 AM, Sam Nelson wrote:
> Good morning, list.
> We've got a bit of a problem on a customer's production box. We got a
> "missing chunk number 0 for toast value N" (N being a number) this week on
SNIP
> So the question is, what could be causing this? It's not so terr
Sam Nelson writes:
> We've got a bit of a problem on a customer's production box. We got a
> "missing chunk number 0 for toast value N" (N being a number) this week on
> their production box. We verified that it was only a problem with one row,
> tried to fix it with updates, and ended up deleti
Scott Brunza writes:
> select a.ip, b.foo from tablea a, tableb, b where a.id=b.id and a.ip ! <<=
> (select network from assets where network is not null)
This is definitely not legal SQL. I think you are looking for something
like
select a.ip, b.foo from tablea a, tableb b where a.id=b.id and
I've been trying, without any luck, to determine whether or an IP address is
contained within (a list of) subnet(s). The computer assets table contains
subnet information, cidr type with /32 for individual hosts, as one would
expect. I'm selecting the IP of hosts that fit certain criteria, but
On Wednesday, August 18, 2010 04:58:08 pm Joshua D. Drake wrote:
> Well if you are just using it for updates to the schema etc... you
> should only need to launch a single connection to each database to make
> those changes.
And that's exactly the problem. On each server, we have at least dozens o
On Wednesday, August 18, 2010 08:40:21 pm Adrian von Bidder wrote:
> Heyho!
>
> On Thursday 19 August 2010 01.32:06 Benjamin Smith wrote:
> > This way we can be sure that either all the databases are in synch, or
> > that we need to rollback the program patch/update.
>
> I guess this might be mo
Good morning, list.
We've got a bit of a problem on a customer's production box. We got a
"missing chunk number 0 for toast value N" (N being a number) this week on
their production box. We verified that it was only a problem with one row,
tried to fix it with updates, and ended up deleting the
On Wed, Aug 18, 2010 at 9:48 AM, Derrick Rice wrote:
> I've been reading up on the documentation for WAL shipping and warm standby
> configuration. One concern that I have (a common one, I'm sure) is that it
> seems that after bringing a standby server up as primary, other standby
> servers (inclu
I have a CMS with a table of items, and another table serving as a log
of operations performed on the items. The revelent table structure is
as follows:
items
itm_id | usr_id_create | itm_date_create | usr_id_modify |
itm_date_modify | .
itm_id is a serial primary key.
usr_id_* are the keys
On Thu, Aug 19, 2010 at 15:42, Tom Lane wrote:
> Jeremy Palmer writes:
>> Could it be that I have too much memory allocated for postgresql? My
>> resource settings are:
>> shared_buffers = 94952
>> temp_buffers = 1GB
>> work_mem = 19339
>> maintenance_work_mem = 191845
>> max_stack_depth = 2MB
>
Jeremy Palmer writes:
> Could it be that I have too much memory allocated for postgresql? My resource
> settings are:
> shared_buffers = 94952
> temp_buffers = 1GB
> work_mem = 19339
> maintenance_work_mem = 191845
> max_stack_depth = 2MB
1GB for temp_buffers is a *LOT*. You do realize that's p
On Thu, Aug 19, 2010 at 05:40:21AM +0200, Adrian von Bidder wrote:
> On Thursday 19 August 2010 01.32:06 Benjamin Smith wrote:
> > This way we can be sure that either all the databases are in synch, or
> > that we need to rollback the program patch/update.
>
> I guess this might be more a hack th
Great thanks. This function idea works perfectly!
create function xtsquery (tsquery,tsquery) returns tsquery as $$
select $1 || $2 $$ language sql;
SELECT fts_title, ts_headline(fts_title, query) from object_fts ot,
xtsquery(to_tsquery('dc2', 'kriev:*'), to_tsquery('english',
'kriev:*')) query whe
On Thu, 19 Aug 2010, darklow wrote:
Hello,
I am using PostgreSQL 8.4 full text search in following way:
Custom FTS configuration called "dc2" with these dictionaries in
following order for asciihword token: latvian_ispell, english_stem,
russian_stem
Latvian ispell dictionary contains words wi
On Thu, 19 Aug 2010, darklow wrote:
Hello,
I am using PostgreSQL 8.4 full text search in following way:
Custom FTS configuration called "dc2" with these dictionaries in
following order for asciihword token: latvian_ispell, english_stem,
russian_stem
russian_stem will never called ! Sorry, I
Hello,
I am using PostgreSQL 8.4 full text search in following way:
Custom FTS configuration called "dc2" with these dictionaries in
following order for asciihword token: latvian_ispell, english_stem,
russian_stem
Latvian ispell dictionary contains words with different endings but
same meaning (
32 matches
Mail list logo
