On 30/01/2011, at 13:03, Alban Hertroys wrote:
> On 28 Jan 2011, at 22:12, Herouth Maoz wrote:
>
>> 2. That database has a few really huge tables. I think they are not being
>> automatically vacuumed properly. In the past few days I've noticed a vacuum
>> process on one of them which has been
On Sun, Jan 30, 2011 at 04:56:29PM +0200, Herouth Maoz wrote:
>
> Unless my eyes were deceiving me, this was not the case. Sure, there have
> been heavy transactions during that time (e.g. the daily backup of the
> database, and the daily inserts into other tables, which take a long time,
> and
On 30/01/2011, at 12:27, Craig Ringer wrote:
>
> OK, so you're pre-8.4 , which means you have the max_fsm settings to play
> with. Have you seen any messages in the logs about the free space map (fsm)?
> If your install didn't have a big enough fsm to keep track of deleted tuples,
> you'd face
Doesn't seem to work either. Maybe something changed in 9.1?
create index test_idx on testtable using gin(to_tsvector(wordcolumn||'
'||reverse(wordcolumn)));
ERROR: functions in index expression must be marked IMMUTABLE
On Sun, Jan 30, 2011 at 3:28 AM, Oleg Bartunov wrote:
> I used 9.1dev, bu
Matt Warner writes:
> Doesn't seem to work either. Maybe something changed in 9.1?
> create index test_idx on testtable using gin(to_tsvector(wordcolumn||'
> '||reverse(wordcolumn)));
> ERROR: functions in index expression must be marked IMMUTABLE
That's not the same case he tested. The single-
Aha! Thanks for pointing that out. It's indexing now.
Thanks!
Matt
On Sun, Jan 30, 2011 at 9:12 AM, Tom Lane wrote:
> Matt Warner writes:
> > Doesn't seem to work either. Maybe something changed in 9.1?
> > create index test_idx on testtable using gin(to_tsvector(wordcolumn||'
> > '||reverse(
If I understand this, it looks like this approach allows me to match the
beginnings and endings of words, but not the middle sections. Is that
correct? That is, if I search for "jag" I will find "jaeger" but not
"lobenjager".
Or am I (again) not understanding how this works?
TIA,
Matt
On Sun, J
Matt Warner writes:
> If I understand this, it looks like this approach allows me to match the
> beginnings and endings of words, but not the middle sections.
Yeah, probably. You might consider using contrib/pg_trgm instead if
you need arbitrary substrings.
regards, tom
Hi pgsql-general mailing list users,
I have a question related to the development of a new index structure.
I am a writing my masters thesis regarding index structures and the
possibility to parallize them.
I already found a post in the archives regarding Open MP, but my
question is somehow differ
=?ISO-8859-15?Q?Yves_Wei=DFig?= writes:
> I am not aiming for full parallelization, only some
> parts of the algorithm regarding build, insert and search are going to
> be extended by Open MP. E.g. I want to parallelize searching in multiple
> pages by directing some portions to one thread and oth
Trapped in Steve Jobs Reality Distortion Field
On Jan 25, 2011, at 8:21 AM, John DeSoi wrote:
>
> On Jan 24, 2011, at 3:25 PM, Jerry LeVan wrote:
>
>> I assume that if I were to jump to Pg 9.x.x that phpPgAdmim would die, yes?
>
> I have not tried it, but my guess is it will work. I don't r
On 01/31/2011 12:14 AM, Herouth Maoz wrote:
On 30/01/2011, at 12:27, Craig Ringer wrote:
OK, so you're pre-8.4 , which means you have the max_fsm settings to
play with. Have you seen any messages in the logs about the free space
map (fsm)? If your install didn't have a big enough fsm to keep t
Thanks. pg_trgm looks interesting, but after installing the pg_trgm.sql, I
get error messages when following the documentation.
sggeeorg=> create index test_idx on test using gist(columnname
gist_trgm_ops);
ERROR: operator class "gist_trgm_ops" does not exist for access method
"gist"
STATEMENT:
Each database adapter in ActiveRecord sets up a mapping between ActiveRecord
types and the native database types. If the type is not defined, it just
defaults it as a string.
If you are using Rails, in one of your environment initializers, you can add
the following code:
ActiveRecord::Base.co
Hi,
thanks for the answer.
I understand that the backend is not thread safe, but it would be possible
to parallelize, let's say a big for-loop without breaking anything, or?
Greets, Yves W.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Sunday, January 30, 2011 10:3
15 matches
Mail list logo
