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 needs
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
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
On Mon, Feb 2, 2009 at 2:30 PM, Scara Maccai m_li...@yahoo.it 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
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', '?? ??? ? ? ?? ?
?')
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 o...@sai.msu.su 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 created
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 wrong way?
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
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 o...@sai.msu.su 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
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
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
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 br...@momjian.ushttp://momjian.us
EnterpriseDB
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
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
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
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 via
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
On Thu, Jan 29, 2009 at 8:16 AM, Gregory Stark st...@enterprisedb.com 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
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 would
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 four
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 =
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
Christopher Browne cbbro...@gmail.com 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
Anyone?
- Messaggio inoltrato -
Da: Scara Maccai m_li...@yahoo.it
A: pgsql-general pgsql-general@postgresql.org
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
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
You realise you just described the very project you saw me write a
presentation on today right?
:-p
On 2/2/09, Gregory Stark st...@enterprisedb.com wrote:
Christopher Browne cbbro...@gmail.com writes:
- Managing jobs (e.g. - pgcron)
A number of people have mentioned a job scheduler. I think
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)
) WITH
Gregory Stark wrote:
Christopher Browne cbbro...@gmail.com 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
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 in
- 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
(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.
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
On Mon, 02 Feb 2009 21:36:54 -0500
justin jus...@emproshunts.com 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
On Mon, 2 Feb 2009 18:53:07 -0800
rhubbell rhubb...@ihubbell.com wrote:
On Mon, 02 Feb 2009 21:36:54 -0500
justin jus...@emproshunts.com 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
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 t...@sss.pgh.pa.us wrote:
.snip
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
Phoenix Kiula phoenix.ki...@gmail.com 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
--
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
On Tue, Feb 3, 2009 at 1:30 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Phoenix Kiula phoenix.ki...@gmail.com 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)
On Feb 3, 2009, at 5:21 AM, Phoenix Kiula wrote:
On Mon, Jan 12, 2009 at 1:02 PM, Tom Lane t...@sss.pgh.pa.us wrote:
.snip
regression=# update pg_attribute set atttypmod = 35+4 where
attrelid = 't1'::regclass and attname = 'f1';
UPDATE 1
regression=# \d t1
Table
51 matches
Mail list logo