x asasaxax wrote:
Hi,
i´m trying to do a trigger that its called when update or insert, that
update the tsvectors, for text-search. Here´s my code:
CREATE OR REPLACE FUNCTION atualiza_vectors() RETURNS trigger AS $$
BEGIN
IF NEW.texto<>NULL THEN
UPDATE x SET vectors =
Vyacheslav Kalinin wrote:
On Tue, Aug 5, 2008 at 6:53 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
There's support for prefix text search in CVS HEAD, but not in any
released version ...
regards, tom lane
Oh, does that mean it won't be released until 8.4?
New features are
Hi all, I think I’ve read somewhere in the documentation that the
invocation of functions written in procedural languages (with the
exception of plpgsql) incur in performance hit due to the call the
language interpreter. Is that correct or am I completely off track?
Thank you in advance
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
> We've seen complaints about toast fetch time before. I don't think
> there's any really simple solution. You could experiment with disabling
> compression (SET STORAGE external) but I'd bet on that being a net loss
> unless the dat
[ cc'ing Remi to see if he remembers anything about how he got around this ]
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> FWIW: there also seems to be a fairly indepth discussion on the cobalt
> related netbsd list from last year about a problem that looks very
> similiar (at least to you
if you're using apache yes your module's performance is related to how many
child processes are spawned by mod_prefork
http://httpd.apache.org/docs/2.2/mod/prefork.html
HTH
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and
2008/8/6 Giorgio Valoti <[EMAIL PROTECTED]>:
> Hi all, I think I've read somewhere in the documentation that the invocation
> of functions written in procedural languages (with the exception of plpgsql)
> incur in performance hit due to the call the language interpreter. Is that
> correct or am I c
Sim Zacks <[EMAIL PROTECTED]> writes:
> After the alter table, then I have to update each row with an
> update dbmail_messageblks set messageblk=messageblk;
> so that it uses the new storage.
I wouldn't actually bet on that changing anything at all ...
I'd try something like messageblk = messagebl
Sim Zacks wrote:
DBMail is
a pre-built application, so until I am ready to start playing with its
internals I don't really have a choice about a number of its features.
Have you heard of this? Might be worth a quick look:
http://www.archiveopteryx.org/overview
--
Richard Huxton
Archonet L
> Mind you, I'd not especially recommend trying to run CVS HEAD for
> production purposes, but it would be real interesting at this point
> to see if you can compile it and run the regression tests with the
> toolchain you've got.
>
I've no problem doing that, this machine is a toy not a product
On 8/6/08, Glyn Astill <[EMAIL PROTECTED]> wrote:
> > Mind you, I'd not especially recommend trying to run CVS HEAD for
> > production purposes, but it would be real interesting at this point
> > to see if you can compile it and run the regression tests with the
> > toolchain you've got.
> >
>
> I'
I'm using compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm on CentOS 5 in
64bit mode.
The package did not create a libpq.so.4 link in /usr/lib64/, which
caused Apache to fail.
Regards,
Kevin Murphy
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
hi all,
maybe a simple question, but i found no answer. what is the best way to
get a psql-client at a linux system without the need of a server. is
there a configure-option (i don't find any) to compile only psql without
der server?
thanks and greetings from munich
christian
p.s. besides this i a
On 06/08/2008 16:38, [EMAIL PROTECTED] wrote:
hi all,
maybe a simple question, but i found no answer. what is the best way to
get a psql-client at a linux system without the need of a server. is
[snip]
p.s. besides this i am also interested, if there is a solution of this
problem for windows
Hi,
On Wed, 2008-08-06 at 11:19 -0400, Kevin Murphy wrote:
> I'm using compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm on CentOS 5
> in 64bit mode.
>
> The package did not create a libpq.so.4 link in /usr/lib64/, which
> caused Apache to fail.
http://yum.pgsqlrpms.org/8.3/redhat/rhel-5-x86_64
I am looking to hear from people that are using PostGres as their backend in a
commerically available product and how much work would be needed to ensure that
our configurations are optimized for each platform along with normal database
routines? What has the stability factor been once installe
On Aug 6, 2008, at 10:04 AM, Mike Gould wrote:
I am looking to hear from people that are using PostGres as their
backend in a commerically available product and how much work would
be needed to ensure that our configurations are optimized for each
platform along with normal database routin
On 06/ago/08, at 16:04, Pavel Stehule wrote:
2008/8/6 Giorgio Valoti <[EMAIL PROTECTED]>:
Hi all, I think I've read somewhere in the documentation that the
invocation
of functions written in procedural languages (with the exception of
plpgsql)
incur in performance hit due to the call the la
Is there any GUI for master-slave (I prefer CLI too)?
Are there any PostgreSQL-specific detailed videos that clearly
illustrate replication, PITR, failover, load-balance, backup etc (I
need it for a pitch)?
Any recommended commercial off-the-shelf/plug-and-play type products
or (hosted? (SimpleDB
On Wed, Aug 6, 2008 at 1:04 PM, Mike Gould <[EMAIL PROTECTED]> wrote:
> I am looking to hear from people that are using PostGres as their backend in
> a commerically available product and how much work would be needed to ensure
> that our configurations are optimized for each platform along with no
Devrim GÜNDÜZ wrote:
Hi,
On Wed, 2008-08-06 at 11:19 -0400, Kevin Murphy wrote:
I'm using compat-postgresql-libs-4-1PGDG.rhel5.x86_64.rpm on CentOS 5
in 64bit mode.
The package did not create a libpq.so.4 link in /usr/lib64/, which
caused Apache to fail.
http://yum.pgsqlrpms.org/8
I am trying to follow the instructions on the 8.0 interactive comments
(http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html) to build a
c function using MSDEV and PostgreSQL 8.3 on Windows XP/2003
I am running into errors around. fatal error C1083: Cannot open include
file: 'libintl.h
While testing on 8.3, i see that upon postmaster restart , i am loosing
data from pg_stat_user_tables. as i understand in 8.3 only way to reset
is by calling |pg_stat_reset().
Sorry for the long post:
Here is my test case:
sample=# SELECT version();
On mið, 2008-08-06 at 20:48 +0200, Giorgio Valoti wrote:
> On 06/ago/08, at 16:04, Pavel Stehule wrote:
>
> >
> > it's depend. Start of interpret is only one overhead.
> > Other is date
> > conversions to language compatible types (without C and plpgsql).
> So is plpgsql slower on date conversio
On Aug 6, 2008, at 11:57 AM, Raymond O'Donnell wrote:
On 06/08/2008 16:38, [EMAIL PROTECTED] wrote:
hi all,
maybe a simple question, but i found no answer. what is the best
way to
get a psql-client at a linux system without the need of a server. is
[snip]
p.s. besides this i am also intere
Hello All!
Its my first time here in maillist and I started work with postgre on last
moth.
My questions is: Threre is a way to create tables dinamic?
Example:
To create a table we use CREATE TABLE TableName ..
In my db, I have many tables with diferents names but with same colums
Example
Hi:
CREATE OR REPLACE FUNCTION MakeTables ( NameTable text ) RETURNS void as
$$
BEGIN
execute 'CREATE TABLE '||$1||' ( id int, name text )';
END;
$$
LANGUAGE 'plpgsql';
2008/8/7 Anderson dos Santos Donda <[EMAIL PROTECTED]>
> Hello All!
>
> Its my first time here in maillist and I started wo
Oisin Glynn wrote:
> I am trying to follow the instructions on the 8.0 interactive comments
> (http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html) to build a
> c function using MSDEV and PostgreSQL 8.3 on Windows XP/2003
>
> I am running into errors around. fatal error C1083: Cannot open
Anderson dos Santos Donda wrote:
> PS : If somebody want knows why I need to create this function, is because
> in my db have 1000 tables with the some colums, and each time I have a new
> client, I need to create this tables manually.
While EXECUTE or CREATE TABLE ... LIKE is the answer to the i
Chirag Dave <[EMAIL PROTECTED]> writes:
> While testing on 8.3, i see that upon postmaster restart , i am loosing
> data from pg_stat_user_tables.
Hm, I don't see any such behavior here. Are you sure you are shutting
the postmaster down normally? We do throw away stats during a crash
recovery,
On Wed, Aug 6, 2008 at 9:16 AM, Sim Zacks <[EMAIL PROTECTED]> wrote:
> We are using UTF-8, and I am testing SQL-ASCII at the moment. DBMail is
> a pre-built application, so until I am ready to start playing with its
> internals I don't really have a choice about a number of its features.
> The reas
2008/8/6 Giorgio Valoti <[EMAIL PROTECTED]>:
>
> On 06/ago/08, at 16:04, Pavel Stehule wrote:
>
>> 2008/8/6 Giorgio Valoti <[EMAIL PROTECTED]>:
>>>
>>> Hi all, I think I've read somewhere in the documentation that the
>>> invocation
>>> of functions written in procedural languages (with the excepti
> I don't quite follow that...the whole point of utf8 encoded database
> is so that you can use text functions and operators without the bytea
> treatment. As long as your client encoding is set up properly (so
> that data coming in and out is computed to utf8), then you should be
> ok. Dropping
On 2008-08-06 17:38, [EMAIL PROTECTED] wrote:
> what is the best way to get a psql-client at a linux system without
> the need of a server.
On Fedora/RedHat/CentOS or other yum based distribution:
# yum install postgresql
For Debian/Ubuntu or other dpkg based distribution I think it will be:
# dp
I ran the update, but now (obviously) it wants to vacuum again and
vacuum on that table took 9 hours yesterday.
Do the statistics change when changing the storage type? Meaning does it
really need to vacuum?
Thank you
Sim
Tom Lane wrote:
> Sim Zacks <[EMAIL PROTECTED]> writes:
>> After the alter
35 matches
Mail list logo
