2010/1/27 Pierre Chevalier :
> Hello,
>
> Some time ago, it was written here:
>>
>> ...
>> I think there should be a generic way in Postgres to return from an EAV
>> model. Although I have no evidence on that I keep thinking that the db must
>> be more effective at that than the application would b
hi,
I test it as follow:
TEST=# select version();
version
-
PostgreSQL 8.4.1, compiled by Visual C++ build 1400, 32-bit
(1 row)
TEST=# CREATE DOMAIN MY_DOMAIN AS DECIMAL (5, 2);
CREATE DOM
Hi,
Regarding Pentaho - please keep in mind that Pentaho needs significant
amount of memory. We had a lot of issues with Pentaho crashing with java
out of memory error. If you are using a 64 bit machine, you may be able to
give it sufficient RAM and keep it happy. If all you have is one 4 GB
ma
Mark this one solved. I finally stumbled across an old, forgotten e-mail
thread from 2006 where Tom Lane solved exactly this problem. See
http://archives.postgresql.org/pgsql-general/2006-02/msg01039.php.
~ Thanks again, Tom!
~ Ken
>
> -Original Message-
> From: Ken Winter [mailto:k...
Hello all,
I solve my problem using the following. It seems that when inherit from parent
table, the parent table's constraint is not being carried over to child table.
CREATE OR REPLACE FUNCTION measurement_insert_trigger()
RETURNS TRIGGER AS
$BODY$DECLARE
measurement_table_index bigint;
Hello Vick,
Can I get some advice from your side?
Currently, I have table :
1 lot is pointing to many units
1 unit is pointing to many measurements
Say, let say, I want "Give me all the measurements result within this lot".
For a single lot, with 100,000 units, with each unit having 48 differe
Greg Smith 2ndquadrant.com> writes:
> You're probably running into this problem:
> http://notemagnet.blogspot.com/2008/05/pgbench-suffering-with-linux-2623-2626.html
You are so right. The last thing I would have suspected is a kernel bug. I am
definitely going to try to be more aware of kernel
Hello,
Some time ago, it was written here:
...
I think there should be a generic way in Postgres to return from an
EAV model. Although I have no evidence on that I keep thinking that
the db must be more effective at that than the application would be.
...
Yes, thanks.
The problem with those
Hello all,
By referring to tutorial on
http://www.if-not-true-then-false.com/2009/11/howto-create-postgresql-table-partitioning-part-1/
I have several doubt, on the type of query, which will take advantage on table
partition.
CREATE TABLE impressions_by_day (
advertiser_id INTEGER NOT
Thanks and Regards
Yan Cheng CHEOK
--- On Tue, 1/26/10, Alban Hertroys wrote:
> From: Alban Hertroys
> Subject: Re: [GENERAL] Primary Key Increment Doesn't Seem Correct Under Table
> Partition
> To: "Yan Cheng Cheok"
> Cc: pgsql-general@postgresql.org
> Date: Tuesday, January 26, 2010, 6:36
zhong ming wu wrote:
Is there a way to figure out from binaries what options were used to
compile/config? For example with apache I can do "httpd -l"
pg_config is what you're looking for.
In some distributions, this may not be installed by default with the
rest of the server. For example,
Is there a way to figure out from binaries what options were used to
compile/config? For example with apache I can do "httpd -l"
Thanks
mr. wu
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
Mike Bresnahan wrote:
As you see, the TPS remains the same as I increase the number of clients. These
results make it look like PostgreSQL is single-threaded and not taking advantage
of the multiple cores. Could someone please explain?
You're probably running into this problem:
http://note
On Tue, Jan 26, 2010 at 3:01 PM, Mike Bresnahan
wrote:
> During these tests top(1) reported 60-70% idle CPU.
>
> As you see, the TPS remains the same as I increase the number of clients.
> These
> results make it look like PostgreSQL is single-threaded and not taking
> advantage
> of the multipl
On 27/01/2010 1:09 AM, Keresztury Balázs wrote:
hi,
I would like to write a trigger on a table which contains detailed
information about users. If I add a new user to this table, I'd like this
trigger to add the user to the database as well. Later I also want to
implement triggers for updating a
I have a read-only database that I am testing the performance of to get a sense
of how many concurrent users I can support. The database fits entirely in RAM so
I expect there to be little to no disk activity. Because of this, I expect
throughput to scale almost linearly with the number of CPUs I h
S Arvind wrote:
> There is a list of hosts available on the PostgreSQL site:
http://www.postgresql.org/support/professional_hosting
most of the site provided there r not have postgres,.. i think its
better to clear up the links in that page...
Any suggestions about inaccurate info there would
On 26/01/2010 22:28, stee...@gmail.com wrote:
> I am new to posgres.
> By running Pg-dump like this, do we need to type in pwd for login manually?
It depends on what access rules are defined in the pg_hba.conf file.
Read about it here:
http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-
I am new to posgres.
By running Pg-dump like this, do we need to type in pwd for login manually?
Thanks
Sent from my BlackBerry device on the Rogers Wireless Network
-Original Message-
From: Moe
Date: Tue, 26 Jan 2010 19:25:50
To:
Subject: Re: [GENERAL] pg dump.. issue with when using
Andy Colson wrote:
I recall seeing someplace that you can avoid WAL if you start a
transaction, then truncate the table, then start a COPY.
Is that correct? Still hold true? Would it make a lot of difference?
That is correct, still true, and can make a moderate amount of
difference if the
Hashimoto Yuya wrote:
> Judging from the result, I could see that stats collector process
> caused this unusually high CPU utilization rate.
> I found similar problem at
> http://archives.postgresql.org/pgsql-general/2008-06/msg00934.php,
> although there seemed
> no clear cause proven nor the stat
S Arvind wrote:
most of the site provided there r not have postgres,.. i think its
better to clear up the links in that page...
if you found specific hosts listed there that do not in fact offer
postgres, it would be quite helpful to provide a list of those you've
contacted so the web folks c
hi,
I'd like to implement row level security in a PostgreSQL 8.4.1 database, but
after several unsuccessful trial I got stuck a little bit.
I have a fact table (project) with a unique id (lets call this project_id)
which is going to be secured. There is another table (access) containing the
acces
Thank you both, that did the trick.
Sincerely / Moe
On Tue, Jan 26, 2010 at 7:14 PM, Tom Lane wrote:
> Moe writes:
> > I have a simple script file db :
> > #!/bin/bash
> > pg_dump -U postgres prodDB > /var/a/db/$(date
> "+%Y-%m-%d_%H:%M")-prodDB.dump
>
> > Which works fine when executed manual
Moe writes:
> I have a simple script file db :
> #!/bin/bash
> pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
> Which works fine when executed manually ( ./db ).. I get a dump file which
> is around 1.9 MB
> I run this script from the crontab schedueler (crontab -e)
hi,
I would like to write a trigger on a table which contains detailed
information about users. If I add a new user to this table, I'd like this
trigger to add the user to the database as well. Later I also want to
implement triggers for updating and deleting, but I got stuck at the first
part of
Moe wrote:
> Hi folks,
>
> I have a simple script file db :
> #!/bin/bash
> pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
>
> --
> Which works fine when executed manually ( ./db ).. I get a dump file which is
> around 1.9 MB
>
>
> I run this script from
On Tue, Jan 26, 2010 at 11:54 AM, Moe wrote:
> Hi folks,
>
> I have a simple script file db :
> #!/bin/bash
> pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
>
> --
> Which works fine when executed manually ( ./db ).. I get a dump file which
> is around 1.9 MB
Hi folks,
I have a simple script file db :
#!/bin/bash
pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
--
Which works fine when executed manually ( ./db ).. I get a dump file which
is around 1.9 MB
I run this script from the crontab schedueler (crontab -e) :
Stefan Schwarzer writes:
> ERROR: could not load library "/usr/local/pgsql/lib/tablefunc.so":
> dlopen(/usr/local/pgsql/lib/tablefunc.so, 10): no suitable image
> found. Did find:
> /usr/local/pgsql/lib/tablefunc.so: mach-o, but wrong
> architecture
That's very curious.
On 1/25/2010 8:12 PM, Craig Ringer wrote:
On 26/01/2010 12:15 AM, Dino Vliet wrote:
5) Other considerations?
Even better is to use COPY to load large chunks of data. libpq provides
access to the COPY interface if you feel like some C coding. The JDBC
driver (dev version only so far) now prov
most of the site provided there r not have postgres,.. i think its better to
clear up the links in that page...
As Craig told i am also interested in cloud..
have to check it up..
On Tue, Jan 26, 2010 at 6:51 PM, Thom Brown wrote:
> 2010/1/26 S Arvind
>
> Hi Everyone,
>> me and my friend wants
The following does basically the same thing, but I find it a bit
easier
to follow:
sudo -u postgres /usr/local/pgsql/bin/pgsql < tablefunc.sql
Thanks for that. Looks indeed less complicated! :-)
But not yet success for me:
I did re-start, just to be sure.
for postgres:
./configu
On 26/01/2010 9:01 PM, S Arvind wrote:
Hi Everyone,
me and my friend wants a central db to do our development as we are in
different location. Do any one know postgres service provider who is
doing service which can help us?
There are quite a few services that host PostgreSQL. Google can help y
2010/1/26 S Arvind
> Hi Everyone,
> me and my friend wants a central db to do our development as we are in
> different location. Do any one know postgres service provider who is doing
> service which can help us?
>
> Arvind S
>
There is a list of hosts available on the PostgreSQL site:
http://ww
On 23/01/2010 5:19 AM, Sarkar, Sudipta wrote:
> Hi,
>
> I downloaded postgres 8.4 in zip format and installed it under
> c:\postgres用�裘� on a traditional Chinese windows 2003 server. Note the
> Chinese characters in the folder name. Then I tried to create a database
> using initdb. I specified
Hi Everyone,
me and my friend wants a central db to do our development as we are in
different location. Do any one know postgres service provider who is doing
service which can help us?
Arvind S
In response to Yan Cheng Cheok :
> Currently, I plan to use table partition to solve the following problem.
> I have a table which is going to grow to a very huge row, as time goes on.
> As I know, as table grow larger, the read operation will be slower.
>
> Hence, I decide to use table partition,
On 26 Jan 2010, at 11:00, Yan Cheng Cheok wrote:
> However, whenever I insert row into measurement table, I realize its primary
> key value is going from 2, 4, 6, 8, 10...
>
> May I know how can I prevent this?
Apparently nextval on that sequence gets called multiple times in your queries.
> A
Currently, I plan to use table partition to solve the following problem.
I have a table which is going to grow to a very huge row, as time goes on.
As I know, as table grow larger, the read operation will be slower.
Hence, I decide to use table partition, in order to improve read speed.
I have
Currently, I have a table which I implement table (measurement) partition
policy.
http://www.postgresql.org/docs/current/static/ddl-partitioning.html
Whenever an item being inserted into measurement table, modulo will be perform
on measurement table primary key. Then, by using the result of mod
I had solved my second problem using the following technique :
EXECUTE 'INSERT INTO ' || measurement_table_name || '(fk_unit_id, v) VALUES
(' || NEW.fk_unit_id || ',' || NEW.v || ')';
yccheok wrote:
>
> By referring to
> http://www.postgresql.org/docs/current/static/ddl-partitioning.html
>
>
Does it mean, if it isn't broken, don't fix it?
Thanks and Regards
Yan Cheng CHEOK
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
By referring to
http://www.postgresql.org/docs/current/static/ddl-partitioning.html
(1) I create trigger function as follow :
CREATE OR REPLACE FUNCTION measurement_insert_trigger()
RETURNS TRIGGER AS
$BODY$DECLARE
measurement_table_index bigint;
measurement_table_name text;
BEGIN
m
44 matches
Mail list logo
