Hi,
>
> There's a performance improvement submitted here:
> http://archives.postgresql.org/message-id/a778a7260810280033n43f70d36x8c437eacf9a54...@mail.gmail.com
>
> But I haven't been following the development of it closely, so you'll
> have to read the thread to see whether it will meet your ne
Hi!
2009.01.31. 10:13 keltezéssel, Erik Jones írta:
On Jan 30, 2009, at 11:37 AM, durumdara wrote:
The main viewpoints:
- quick (re)connect - because mod_python basically not store the
database connections persistently
mod_python is not a database adaptor.
Yes, I know. But because of mod_
Oleg, like I mentioned earlier. I have a different .affix file that I got
from Andrew with the stop file and I get no errors creating the dictionary
using that one but I get nothing out from ts_lexize.
The size on that one is : 406,219 bytes
And the size on the hunspell one (first) : 406,229 bytes
Mohamed,
comment line in ar.affix
#FLAG long
and creation of ispell dictionary will work.
This is temp, solution.
Teodor is working on fixing affix autorecognizing.
I can't say anything about testing, since somebody should provide
first test case. I don't know how to type arabic :)
Oleg
O
On Mon, Feb 2, 2009 at 2:30 PM, Scara Maccai wrote:
> Paolo Saudin wrote:
>> I use a master table with a "fulldate" field and filled with sequential
>> dates to
>> fill gaps when meteo data is missing.
>
> I'm sorry, I still don't get it: how can you be sure that postgresql won't
> call perl_sli
Probably can. But you're talking about disabling off-host archiving.
The whole point behind this is prevention in case a host hard drive
fails... if it fails and you don't use off-host archiving then you've
lost the files you need to rebuild the database along with the original
database.
Thanks,
On Mon, 2 Feb 2009, Mohamed wrote:
Hehe, ok..
I don't know either but I took some lines from Al-Jazeera :
http://aljazeera.net/portal
just made the change you said and created it successfully and tried this :
select ts_lexize('ayaspell', '?? ??? ? ? ?? ?
?')
b
On Mon, 2 Feb 2009, Oleg Bartunov wrote:
On Mon, 2 Feb 2009, Mohamed wrote:
Hehe, ok..
I don't know either but I took some lines from Al-Jazeera :
http://aljazeera.net/portal
just made the change you said and created it successfully and tried this :
select ts_lexize('ayaspell', '?? ?
On Mon, Feb 2, 2009 at 4:34 PM, Oleg Bartunov wrote:
> On Mon, 2 Feb 2009, Oleg Bartunov wrote:
>
> On Mon, 2 Feb 2009, Mohamed wrote:
>>
>> Hehe, ok..
>>> I don't know either but I took some lines from Al-Jazeera :
>>> http://aljazeera.net/portal
>>>
>>> just made the change you said and creat
Thanks for the answer.
I see the point with the backup :)
Regards
Thomas
Scot Kreienkamp, 02.02.2009 16:19:
Probably can. But you're talking about disabling off-host archiving.
The whole point behind this is prevention in case a host hard drive
fails... if it fails and you don't use off-host
Octavio Alvarez wrote:
> On Fri, 2009-01-30 at 15:32 -0500, Bruce Momjian wrote:
> > Octavio Alvarez wrote:
> > > On Thu, 2009-01-29 at 13:16 +, Gregory Stark wrote:
> > > > So, what do people say? Is Postgres perfect in your world or does
> > it
> > > > do some
> > > > things which rub you the
Ok, thank you Oleg.
I have another dictionary package which is a conversion to hunspell aswell:
http://wiki.services.openoffice.org/wiki/Dictionaries#Arabic_.28North_Africa_and_Middle_East.29
(Conversion of Buckwalter's Arabic morphological analyser) 2006-02-08
And running that gives me this erro
Mohamed,
please, try to read docs and think a bit first.
On Mon, 2 Feb 2009, Mohamed wrote:
On Mon, Feb 2, 2009 at 4:34 PM, Oleg Bartunov wrote:
On Mon, 2 Feb 2009, Oleg Bartunov wrote:
On Mon, 2 Feb 2009, Mohamed wrote:
Hehe, ok..
I don't know either but I took some lines from Al-Jaz
My short list is:
* in-place upgrade
* named parameters in SQL functions
* native jobs
* timestamptz that preserves original timezone (not offset but
political timezone like America/New_York)
* I hate: "select * from dblink(...) as WHY(I_NEED int4, TO_SPECIFY
int4, THIS text)"
* ability to c
Little harsh, are we? I have read the WHOLE documentation, it's a bit long
so confusion might arise + I am not familiar with postgre AT ALL so the
confusion grows.
Perhaps I am an idiot and you don't like helping idiots or perhaps it's
something else? Which one is it?
If you don't want to help me,
wstrzalka wrote:
> * stat collector is really greedy by definition even when system is
> idle, when you have really really many relations
I think this will be fixed in 8.4.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If yo
Daniel,
I was able to compile bamboo just following instructions.
The only problem was related to cmake version, I had to install latest
version of cmake 2.6-patch 2.
I used postgresql from CVS HEAD.
Then I compiled and installed exts/postgres/chinese_parser, but when
installing it into databa
On Mon, Feb 02, 2009 at 09:48:37AM -0800, Scara Maccai wrote:
> > I need to store a lot of int8 columns (2000-2500) in a table.
> > I was thinking about using int8[]
An array of ints sounds like the way to go here as you wouldn't be able
to have that many columns. TOAST is one non-obvious impleme
Hehe, ok..
I don't know either but I took some lines from Al-Jazeera :
http://aljazeera.net/portal
just made the change you said and created it successfully and tried this :
select ts_lexize('ayaspell', 'استشهد فلسطيني وأصيب ثلاثة في غارة إسرائيلية
جديدة')
but I got nothing... :(
Is there a way
On Feb 2, 8:23 pm, br...@momjian.us (Bruce Momjian) wrote:
> wstrzalka wrote:
> > * stat collector is really greedy by definition even when system is
> > idle, when you have really really many relations
>
> I think this will be fixed in 8.4.
>
That would by great news for "mine" cluster.
--
Sent
I have a database running very happily in 8.2 (to be upgraded soon). The system
was installed with tsearch2 enabled, however, we have yet to use it. I am going
through an effort to reduce "cruft" in the database, which includes four
tables: pg_ts_cfg, pg_ts_cfgmap, pg_ts_dict, pg_ts_parser. Are
Gregory Stark wrote:
I'm putting together a talk on "PostgreSQL Pet Peeves" for discussion at
FOSDEM 2009 this year. I have a pretty good idea what some them are of course,
but I would be interested to hear if people have any complaints from personal
experience. What would be most interesting is
I noticed that if I use...
IF (TG_OP = 'DELETE' AND OLD.myColumn) THEN
-- Do something
END IF;
when an insert happens, I get an error that 'OLD' has not been
assigned. I would of thought that the control structure would just
ignored the rest of the 'if' statement if the first part (TG_OP) was
f
On Thu, Jan 29, 2009 at 8:16 AM, Gregory Stark wrote:
> So, what do people say? Is Postgres perfect in your world or does it do some
> things which rub you the wrong way?
Things I'd particularly like to have that aren't entirely on the map yet:
- In place upgrade
- Stored procedures that can man
On Fri, Jan 30, 2009 at 02:08:19PM -0800, Nick Boutelier wrote:
> I noticed that if I use...
>
> IF (TG_OP = 'DELETE' AND OLD.myColumn) THEN
> -- Do something
> END IF;
>
> when an insert happens, I get an error that 'OLD' has not been
> assigned. I would of thought that the control structure w
I copied back to list as your chances of getting an answer are greater.
On Sunday 01 February 2009 10:15:04 pm you wrote:
> The Postgres version is PostgreSQL version 8.3.4.
> OS type - Windows XP Proffesional Version 2002
> Our application is a client server Java application which collects data
>-Messaggio originale-
>Da: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] Per conto di Scara Maccai
>Inviato: lunedì 2 febbraio 2009 10.36
>A: Paolo Saudin; pgsql-general@postgresql.org
>Cc: pgsql-general
>Oggetto: Re: R: [GENERAL] complex custom aggregate
On Mon, Feb 02, 2009 at 09:40:16AM -0500, Eric Brown wrote:
> I have a database running very happily in 8.2 (to be upgraded soon).
> The system was installed with tsearch2 enabled, however, we have yet
> to use it. I am going through an effort to reduce "cruft" in the
> database, which includes fou
Hi Mohamed.
I don't know where you get the dictionary - I unsuccessfully tried the
OpenOffice one by myself (the Ayaspell one), and I had no arabic
stopwords file.
Renaming the file is supposed to be enough (I did it successfully for
Thailandese dictionary) - the ".aff'" file becoming the ".
> - EXPLAIN does not work with functions.
+1
and one more about explain - it would be great to have smth like:
EXPLAIN ANALYZE FULL - that would show details about the plan chosen
with detailed explanation and other plans considered.
It would reduce a few posts a week in style:
- 'why the query A
I have ran into some problems here.
I am trying to implement arabic fulltext search on three columns.
To create a dictionary I have a hunspell dictionary and and arabic stop
file.
CREATE TEXT SEARCH DICTIONARY hunspell_dic (
TEMPLATE = ispell,
DictFile = hunarabic,
AffFile = hunarabic
No, I don't. But the ts_lexize don't return anything so I figured there must
be an error somehow.
I think we are using the same dictionary + that I am using the stopwords
file and a different affix file, because using the hunspell (ayaspell) .aff
gives me this error :
ERROR: wrong affix file form
Christopher Browne writes:
> - Managing jobs (e.g. - "pgcron")
A number of people have mentioned a job scheduler. I think a job scheduler
entirely inside Postgres would be a terrible idea.
However a cron daemon which used Postgres as a storage backend would be very
cool. It could then provide S
Anyone?
- Messaggio inoltrato -
> Da: Scara Maccai
> A: pgsql-general
> Inviato: Venerdì 30 gennaio 2009, 13:59:09
> Oggetto: [GENERAL] arrays and block size
>
> Hi,
>
> I need to store a lot of int8 columns (2000-2500) in a table.
>
> I was thinking about using int8[], and I would
Mohamed,
We are looking on the problem.
Oleg
On Mon, 2 Feb 2009, Mohamed wrote:
No, I don't. But the ts_lexize don't return anything so I figured there must
be an error somehow.
I think we are using the same dictionary + that I am using the stopwords
file and a different affix file, because us
You realise you just described the very project you saw me write a
presentation on today right?
:-p
On 2/2/09, Gregory Stark wrote:
> Christopher Browne writes:
>
>> - Managing jobs (e.g. - "pgcron")
>
> A number of people have mentioned a job scheduler. I think a job scheduler
> entirely insid
> Paolo Saudin wrote:
> For that purpose, a sliding mean calculation I use the following
>
> CREATE TABLE tbl_ayas
> (
> fulldate timestamp without time zone NOT NULL,
> id_1 real, -- temperature
> id_2 real, -- pressure
> ..
> CONSTRAINT tbl_ayas_pkey PRIMARY KEY (fulldate)
> )
Gregory Stark wrote:
Christopher Browne writes:
- Managing jobs (e.g. - "pgcron")
A number of people have mentioned a job scheduler. I think a job scheduler
entirely inside Postgres would be a terrible idea.
PgFoundry already has a project called "Job Scheduler".
--
Guy Rouillier
--
Sent
Paolo Saudin wrote:
> I use a master table with a "fulldate" field and filled with sequential dates
> to
> fill gaps when meteo data is missing.
I'm sorry, I still don't get it: how can you be sure that postgresql won't call
perl_sliding_mean with not-ordered timestamps-data? I don't mean only
- COPY command does not support collation. It's such a pita to massage
huge files that have "," has a decimal separator.
copy with delimiter '###'
http://www.postgresql.org/docs/current/static/sql-copy.html
--
Postgresql & php tutorials
http://www.designmagick.com/
--
Sent via pgsql-ge
(posted on novice too, no idea what difference is between lists)
I have been trying to do this and have been unsuccessful so far.
I have a table:
perf:
timestamp = timestamp with time zone
timeelapsed = numeric
bobble = text
timeelapsed records are the time elapsed metric in seconds.
e
rhubbell wrote:
(posted on novice too, no idea what difference is between lists)
I have been trying to do this and have been unsuccessful so far.
I have a table:
perf:
timestamp = timestamp with time zone
timeelapsed = numeric
bobble = text
timeelapsed records are the time elapsed metr
On Mon, 02 Feb 2009 21:36:54 -0500
justin wrote:
> rhubbell wrote:
> > (posted on novice too, no idea what difference is between lists)
> >
> > I have been trying to do this and have been unsuccessful so far.
> >
> > I have a table:
> >
> > perf:
> > timestamp = timestamp with time zone
> > tim
On Mon, 2 Feb 2009 18:53:07 -0800
rhubbell wrote:
> On Mon, 02 Feb 2009 21:36:54 -0500
> justin wrote:
>
> > rhubbell wrote:
> > > (posted on novice too, no idea what difference is between lists)
> > >
> > > I have been trying to do this and have been unsuccessful so far.
> > >
> > > I have a t
Dear all,
Does anyone know how to display an array data into row?
for exampla, I have data like this
conname contype conkey
kelas_pkey p {1,2}
kelas_tahun f {2}
And I want to to display those data above like below
kelas_pkey p 1
kelas_pkey p 2
kelas_tahun f 2
Do
On Mon, Jan 12, 2009 at 1:02 PM, Tom Lane wrote:
.
> regression=# update pg_attribute set atttypmod = 35+4 where attrelid =
> 't1'::regclass and attname = 'f1';
> UPDATE 1
> regression=# \d t1
> Table "public.t1"
> Column | Type | Modifiers
> +-
Hello
create or replace function unnest(anyarray)
returns setof anyelement as $$
select $1[i] from generate_series(array_lower($1,1),array_upper($1,1)) g(i);
$$ language sql immutable;
select conname, contype, unnest(conkey) from ...
regards
Pavel Stehule
2009/2/3 hendra kusuma :
> Dear all,
>
Phoenix Kiula writes:
> Tom, this has worked, and a "\d TABLENAME" shows that the column is
> varchar(35).
> But I still have messages in my log saying:
> ERROR: value too long for type character varying(20)
Cached plans maybe?
regards, tom lane
--
Sent via pgsql-ge
I've been able to use the libpq libraries on the iPhone simulator,
but I need to compile it on the ARM processor to actually run it on
an iPhone. It seems my choices are:
1) add the relevant .c files to the iPhone XCode project and try to
get the conditional macros and configuration correct
On Tue, Feb 3, 2009 at 1:30 PM, Tom Lane wrote:
> Phoenix Kiula writes:
>> Tom, this has worked, and a "\d TABLENAME" shows that the column is
>> varchar(35).
>
>> But I still have messages in my log saying:
>> ERROR: value too long for type character varying(20)
>
> Cached plans maybe?
>
>
On Feb 3, 2009, at 5:21 AM, Phoenix Kiula wrote:
On Mon, Jan 12, 2009 at 1:02 PM, Tom Lane wrote:
.
regression=# update pg_attribute set atttypmod = 35+4 where
attrelid = 't1'::regclass and attname = 'f1';
UPDATE 1
regression=# \d t1
Table "public.t1"
Column | Ty
51 matches
Mail list logo
