Just to add to this list, I have been using Postgresql to store data
for multiple GPS applications handling more than 150-200 vehicles.
Some of the tables that I have are running into 20 - 25 million rows
at the max, and on average 10 million rows. I am yet to see a problem
from the database side,
Raymond,
I used the pgInstaller on the Win2K box and it is working. I
downloaded from a different mirror. The installation ran a little
different. Additionally, there seemed to be an issue with rights.
The installer setup a user which I accepted but it came back saying
that the rights weren't r
On Thursday 19 March 2009 5:25:03 pm jc_mich wrote:
> Hi all
>
> I'm new in PL/PGSQL developing, I'm trying to initialize a variable from a
> SQL query, this query counts some rows, I've made the next code, but it
> doesn't work.
>
> CREATE FUNCTION schema.myFunction() RETURNS BOOLEAN AS $$
> DECLA
Hi all
I'm new in PL/PGSQL developing, I'm trying to initialize a variable from a
SQL query, this query counts some rows, I've made the next code, but it
doesn't work.
CREATE FUNCTION schema.myFunction() RETURNS BOOLEAN AS $$
DECLARE
counter RECORD;
BEGIN
SELECT * INTO STRICT counter
On Thu, Mar 19, 2009 at 11:50 AM, Scott Marlowe wrote:
> On Tue, Mar 17, 2009 at 5:25 AM, Juan Pereira
> wrote:
>> Hello,
>>
>> The question is: Which DBMS do you think is the best for this kind of
>> application? PostgreSQL or MySQL?
>
> Another advantage pgsql has is that many ddl operations on
Dann Corbit wrote:
>
> Here is another interesting benchmark with a particular user's
> application:
> http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html
>
> P.S.
> Oracle won't let you publish any benchmark numbers.
> So if you find an Oracle comparison, it's "unauthorized
2009/3/19 Grzegorz Jaśkiewicz :
> 2009/3/19 Merlin Moncure :
>
>> if you are moving arrays (and/or composites) into out of database
>> through libpq, check out libpqtypes:
>>
>> http://libpqtypes.esilo.com/
>
> Thanks, I will have to do it via libpqxx unfortunately. Which
> complicates matter a bit
On Thu, Mar 19, 2009 at 3:23 PM, Scott Marlowe wrote:
> On Thu, Mar 19, 2009 at 3:26 PM, John Cheng
> wrote:
> > Comparison between MySQL using the MyISAM engine with PostgreSQL is
> really
> > not sensible. For one, the MyISAM engine does not have transaction and
> > foreign key support, while P
On Mar 19, 2009, at 4:50 PM, Will Rutherdale (rutherw) wrote:
It isn't actually possible at this stage for me to benchmark "the
application" because it doesn't yet exist. There are a number of
potential projects floating around, with as yet unwritten
specifications, to run on different platfor
Hi,
I have table with several columns and need to perform fulltext search over
volatile number of columns.
I can't use multicolumn gist index or gin index over concatenated columns,
so I've created several single column indexes (one for each column I want to
search) and now I need to query them l
Michael Higgins wrote:
> On Thu, 19 Mar 2009 12:28:11 -0500
> ries van Twisk wrote:
>
> >
> > On Mar 19, 2009, at 11:53 AM, ANKITBHATNAGAR wrote:
> >
> > >
> > > Hi
> > > This happens when I import csv file via my app into postgres.
> > > The csv file has some “hello” from microsoft word 2003.
On Thu, 19 Mar 2009 12:28:11 -0500
ries van Twisk wrote:
>
> On Mar 19, 2009, at 11:53 AM, ANKITBHATNAGAR wrote:
>
> >
> > Hi
> > This happens when I import csv file via my app into postgres.
> > The csv file has some “hello” from microsoft word 2003.
> > In postgres it appears as �hello�
> >
This looks similar to things I've seen before. MyISAM can be made to
look twice as fast as Postgres if the application is cooked to throw
away transaction processing, updates, and referential integrity, none of
which MyISAM seems to support well.
I plan to make a point of this to people, as I per
On Thu, Mar 19, 2009 at 4:24 PM, Will Rutherdale (rutherw)
wrote:
> Okay, you've given me some useful information.
>
> As the original subject line indicates, I'm open to the idea that no such
> benchmark exists.
>
> If anyone asks about this stuff, I can just say that performance varies
> widel
2009/3/19 John R Pierce :
> pgResult = PQexec(pgConn, "select array['123','456','abc','def'];");
> pgarray = PQgetvalue(pgResult,0,0);
>
> will return a pointer to the ARRAY in postgres format as defined by the
> typsend/recieve internal functions for the ARRAY type. you would need to
> walk
2009/3/19 Merlin Moncure :
> if you are moving arrays (and/or composites) into out of database
> through libpq, check out libpqtypes:
>
> http://libpqtypes.esilo.com/
Thanks, I will have to do it via libpqxx unfortunately. Which
complicates matter a bit, since they don't expose libpq. (which for
Here is another interesting benchmark with a particular user's
application:
http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html
P.S.
Oracle won't let you publish any benchmark numbers.
So if you find an Oracle comparison, it's "unauthorized"
--
Sent via pgsql-general mailing l
I am jumping into this thread late, and maybe this has already been
stated clearly, but from my experience benchmarking, LVM does *not*
lie about fsync() on the servers I've configured. An fsync() goes to
the physical device. You can see it clearly by setting the write
cache on the RAID controlle
Okay, you've given me some useful information.
As the original subject line indicates, I'm open to the idea that no such
benchmark exists.
If anyone asks about this stuff, I can just say that performance varies widely
by database and application, that Postgres performs well enough against other
On Thu, Mar 19, 2009 at 3:26 PM, John Cheng wrote:
> Comparison between MySQL using the MyISAM engine with PostgreSQL is really
> not sensible. For one, the MyISAM engine does not have transaction and
> foreign key support, while PostgreSQL supports transaction and foreign key.
> Would anyone real
On Thu, Mar 19, 2009 at 4:11 PM, Will Rutherdale (rutherw)
wrote:
> I am already aware of this issue, and am preparing to explain it to people.
Well, keep in mind that MOST people are gonna wave you off, and figure
it doesn't matter that much. Lots of developers are pretty cavalier
with their us
On Thu, Mar 19, 2009 at 3:56 PM, Will Rutherdale (rutherw)
wrote:
> I'm having trouble with the tweakers reference below.
>
> I was hoping to see something where hardware platform is held constant while
> RDBMS is varied, but it seems to be just the opposite. Or maybe I didn't
> read the articl
I am already aware of this issue, and am preparing to explain it to
people.
Having said that, if it were possible to set up a reasonably average
database, with a test application that hits it with a reasonable mix of
select, insert, and update operations, and run it one at a time against
diffe
On Thu, Mar 19, 2009 at 4:02 PM, Will Rutherdale (rutherw)
wrote:
> I am *not* primarily interested in embedded, but I know people who are, and I
> have already compared with SQLite.
>
> My main point of concern right now is for more middle sized platforms (such
> as an average workstation), to
I'm having trouble with the tweakers reference below.
I was hoping to see something where hardware platform is held constant while
RDBMS is varied, but it seems to be just the opposite. Or maybe I didn't read
the article the right way.
-Will
-Original Message-
From: Scott Marlowe [ma
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Scott Marlowe
> Sent: Thursday, March 19, 2009 2:57 PM
> To: Will Rutherdale (rutherw)
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Is there a meaningfu
I am *not* primarily interested in embedded, but I know people who are, and I
have already compared with SQLite.
My main point of concern right now is for more middle sized platforms (such as
an average workstation), to be able to answer the question of how Postgres
shows in transactions per
On Thu, Mar 19, 2009 at 3:50 PM, Will Rutherdale (rutherw)
wrote:
> Even if such a question is answered, it isn't going to be the only
> factor. For example I have collected reasonable numbers already on
> footprints of different RDBMSs, because embedded guys might find that
> important if they'r
It isn't actually possible at this stage for me to benchmark "the
application" because it doesn't yet exist. There are a number of
potential projects floating around, with as yet unwritten
specifications, to run on different platforms ranging from embedded to
larger servers. People just want to h
2009/3/19 Grzegorz Jaśkiewicz :
> Hi,
>
> Anyone here passed array to C/c++ code via libpq(xx) ??
> I need to pass on an array of strings, some of them might contain coma symbol.
> I am wondering, if there's anything already in libpq(xx) that would
> chop value into an array of char* , or will it j
On Thu, Mar 19, 2009 at 3:16 PM, Dann Corbit wrote:
> Here are some benchmark figures:
> http://tweakers.net/reviews/657/6
SNIP
> My opinion:
> Most benchmarks are run by someone with an axe to grind. I never
> believe them.
Generally I agree with that sentiment. However, it's interesting tha
Comparison between MySQL using the MyISAM engine with PostgreSQL is really
not sensible. For one, the MyISAM engine does not have transaction and
foreign key support, while PostgreSQL supports transaction and foreign key.
Would anyone really give up transaction and integrity for slightly more
perfo
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Will Rutherdale (rutherw)
> Sent: Thursday, March 19, 2009 1:32 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Is there a meaningful benchmark?
>
> Hi. I
Grzegorz Jaśkiewicz wrote:
Hi,
Anyone here passed array to C/c++ code via libpq(xx) ??
Do you mean, fetching the output of a query like
SELECT ARRAY['123','456','abc','def'];
?
I need to pass on an array of strings, some of them might contain coma symbol.
I am wondering, if there's a
On Mar 19, 2:04 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 18/03/2009 22:22, ray wrote:
>
> > I do not see an opportunity to request a log to be written. From the
> > Psotgre site, I downloaded:
> > postgresql-8.3.7-1-windows.exe
>
> Ah, I see - that's the one-click installer, which is main
Hi. I'm writing up a database comparison paper in my department at
work, with Postgres being a major candidate. I have been attempting to
research various issues and provide a meaningful comparison.
One issue I would like to give some kind of information on is
comparative performance. When I lo
"Rob Richardson" writes:
> I just discovered the existence of a couple of functions I don't
> understand in one customer's PostgreSQL database:
What do the substitute output functions do differently?
> UPDATE pg_type SET typoutput='c_textout'WHERE typname='SET';
This one has been a no-op si
On Mar 19, 2:04 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 18/03/2009 22:22, ray wrote:
>
> > I do not see an opportunity to request a log to be written. From the
> > Psotgre site, I downloaded:
> > postgresql-8.3.7-1-windows.exe
>
> Ah, I see - that's the one-click installer, which is main
I'm trying to determine the permissions PUBLIC has on several
tables/views. Or would this be the default permissions for a table/view?
pg_user, pg_roles, pg_group, pg_authid, pg_auth_members, pg_database,
pg_tablespace, and pg_settings.
\dp pg_user
returns (0 rows).
I am logged in to templ
Marco Colombo wrote:
> Yes, but we knew it already, didn't we? It's always been like
> that, with IDE disks and write-back cache enabled, fsync just
> waits for the disk reporting completion and disks lie about
I've looked hard, and I have yet to see a disk that lies.
ext3, OTOH seems to lie.
ID
Hey folks,
At PostgreSQL Conference West 08, Josh Tolley did a great presentation
on how to write a procedural language and the SFPUG meeting in March had
a presentation on Unison which is a software used with Proteomic
mining.
Below are the links to not only the video but also the slides. Of ex
On Wed, Mar 18, 2009 at 3:57 PM, Greg Sabino Mullane wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
>
> > I'm trying to use Perl's DBD::Pg module to import a file as a large
> object.
> > For this I'm using the following:
> > my $oid = $dbh->func( "/absolute/path/to/file", 'lo_i
On 18/03/2009 22:22, ray wrote:
> I do not see an opportunity to request a log to be written. From the
> Psotgre site, I downloaded:
> postgresql-8.3.7-1-windows.exe
Ah, I see - that's the one-click installer, which is maintained by
EnterpriseDB. I haven't used that one; I was thinking of the com
On Thu, Mar 19, 2009 at 04:22:56PM +0200, Peter Eisentraut wrote:
> Joins nest from left to write, so
>
> tbl_c NATURAL JOIN tbl_a NATURAL JOIN tbl_b
>
> means
>
> (tbl_c NATURAL JOIN tbl_a) NATURAL JOIN tbl_b
>
> If you want a different order, you can set the parentheses differently,
> with p
On Thu, Mar 19, 2009 at 12:11 PM, jc_mich wrote:
>
> Hi all
>
> I'm new developing procedures in PL/PGSQL. I'm using Query Tool as code
> editor, but execute query button only mark sintax errors and I want to run
> my application.
select myfunction(arg1, arg2);
--
Sent via pgsql-general mailing
hello
2009/3/19 jc_mich :
>
> Hi all
>
> I'm new developing procedures in PL/PGSQL. I'm using Query Tool as code
> editor, but execute query button only mark sintax errors and I want to run
> my application.
>
> How can I test my function?
>
write
select nameofyourfunctions(parameters);
regards
Hi all
I'm new developing procedures in PL/PGSQL. I'm using Query Tool as code
editor, but execute query button only mark sintax errors and I want to run
my application.
How can I test my function?
Thanks!
--
View this message in context:
http://www.nabble.com/How-to-run-a-procedure-tp2260619
Hi,
Anyone here passed array to C/c++ code via libpq(xx) ??
I need to pass on an array of strings, some of them might contain coma symbol.
I am wondering, if there's anything already in libpq(xx) that would
chop value into an array of char* , or will it just return a string
and it is up to user to
Tom Lane wrote:
> Adrian Klaver writes:
>> Nothing. I have created a Postgres instance on an EC2 virtual machine with
>> attached EBS(Elastic Block Storage)..[...]
>
> ... I wonder whether you have any guarantees about database consistency
> in that situation? PG has some pretty strong requirem
- glext...@gmail.com wrote:
> Hi--
>
>
> I'm having a bit of trouble with the EXECUTE statement for the
> following function.
>
>
> I saw a lot of traffic re. plpgsql & variable substitution for 8.4,
> but I'm convinced this is something simple (newbie):
>
>
>
> CREATE FUNCTION topm
Hi--
I'm having a bit of trouble with the EXECUTE statement for the
following function.
I saw a lot of traffic re. plpgsql & variable substitution for 8.4,
but I'm convinced this is something simple (newbie):
CREATE FUNCTION topmixtot (int[]) RETURNS SETOF record AS $$
DECLARE
gids ALIAS
On Mar 19, 2009, at 11:53 AM, ANKITBHATNAGAR wrote:
Hi
This happens when I import csv file via my app into postgres.
The csv file has some “hello” from microsoft word 2003.
In postgres it appears as �hello�
Could somebody help on this?
Check your encodings.
Ries
Ankit
--
Sent via p
Hi
This happens when I import csv file via my app into postgres.
The csv file has some “hello” from microsoft word 2003.
In postgres it appears as �hello�
Could somebody help on this?
Ankit
--
View this message in context:
http://www.nabble.com/Special-charaters-tp22604452p22604452.html
Sent
2009/3/19 Alvaro Herrera :
> Milos Findura wrote:
>> hi,
>> I found a deadlock on 2 queries, DELETE and REINDEX TABLE
>
> What version is this?
>
8.3
Milos is my colleague
regards
Pavel Stehule
>
>
> --
> Alvaro Herrera http://www.CommandPrompt.com/
> PostgreSQL R
Milos Findura wrote:
> hi,
> I found a deadlock on 2 queries, DELETE and REINDEX TABLE
What version is this?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
--
Sent via pgsql-general mailing l
On Tue, Mar 17, 2009 at 5:25 AM, Juan Pereira
wrote:
> Hello,
>
> The question is: Which DBMS do you think is the best for this kind of
> application? PostgreSQL or MySQL?
Another advantage pgsql has is that many ddl operations on tables do
NOT require exclusive locks on those tables. Creating i
hi,
I found a deadlock on 2 queries, DELETE and REINDEX TABLE
DELETE waits for RowExclusiveLock on table address_jd
and
REINDEX waits for AccessExclusiveLock on PRIMARY KEY address_jd_pk
log:
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-1]
host=10.0.5.144,user=ppstat,db=ppstat ERROR: deadlock d
Problem solved!
The sinner is probably windows defender.
Went to C:\Windows\system32\drivers\etc\ and opened the hosts file, and entered
"127.0.0.1 localhost" at the bottom of the file, saved and rebooted pc.
Hello,
As a continued follow up to this thread, Tim Post replied on the LVM
list to this affect:
"
If a logical volume spans physical devices where write caching is
enabled, the results of fsync() can not be trusted. This is an issue
with device mapper, lvm is one of a few possible customers of D
Thomas Kellerer wrote:
Harald Armin Massa, 17.03.2009 15:00:
That is: what table size would you or anybody consider really,
really large actually?
I recently attended and Oracle training by Tom Kyte and he said
(partially joking though) that a database is only large when the size
is measured
É possível alterar o database corrente para criar um schema nele sem uso do \c
do psql?
Obrigado
MarceloG
On Thu, Mar 19, 2009 at 8:42 AM, Anton V. Belyaev
wrote:
> I have 4-cored machine, so I expected the query to be able to run for
> a long time without performance degrade for application.
As Bill mentioned, this won't help a bit if you've got a slow / dodgy
/ overloaded IO subsystem. What does
In response to "Anton V. Belyaev" :
> Hello,
>
> I want to run a long running query in background to collect
> statistics. I.e. how many users played the game last month more than
> 50 times.
>
> SELECT count(*) FROM (SELECT user_id, COUNT(*) AS total_games FROM
> games, game2user WHERE games.fi
Hello,
I want to run a long running query in background to collect
statistics. I.e. how many users played the game last month more than
50 times.
SELECT count(*) FROM (SELECT user_id, COUNT(*) AS total_games FROM
games, game2user WHERE games.finished > '2009-02-19' AND games.id =
game2user.game_i
Greetings!
I just discovered the existence of a couple of functions I don't
understand in one customer's PostgreSQL database:
-- Function: c_mode()
-- DROP FUNCTION c_mode();
CREATE OR REPLACE FUNCTION c_mode()
RETURNS text AS
$BODY$ UPDATE pg_type SET typoutput='c_textout'WHERE typn
Thom Brown wrote:
SELECT tbl_a.location, tbl_b.language
FROM tbl_c
NATURAL INNER JOIN tbl_a
NATURAL INNER JOIN tbl_b
The confusion comes when 2 of those tables reference the 3rd table using
the same column.
So are natural joins only allowed to join 2 tables? If not, how can it
be used for m
Not so,
statements have diffrent pid. Delete is called in application, bud
REINDEX is
called via some cron admin script.
t.
On Thursday 19 of March 2009 13:35:03 Tom Lane wrote:
> Milos Findura writes:
> > where can be problem?
>
> Presumably, one statement or the other is inside a tr
Milos Findura writes:
> where can be problem?
Presumably, one statement or the other is inside a transaction that
already had a lower-grade lock on the target table.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On Thu, Mar 19, 2009 at 5:24 AM, Thom Brown wrote:
> The confusion comes when 2 of those tables reference the 3rd table using the
> same column.
>
> So are natural joins only allowed to join 2 tables? If not, how can it be
> used for more than 1 table has links to the other tables?
Not sure how
Hi,
I've read the PostgreSQL documentation on natural joins, but it only ever
shows it being used once. Is it possible to use it more than once?
Say if I have the following 3 tables (this is a poor example by the way):
tbl_a
a_id serial NOT NULL
location text
tbl_b
b_id seria
hi,
I found a deadlock on 2 queries, DELETE and REINDEX TABLE
DELETE waits for RowExclusiveLock on table address_jd
and
REINDEX waits for AccessExclusiveLock on PRIMARY KEY address_jd_pk
log:
Mar 19 00:30:53 ch08bl09 postgres[25576]: [5-1]
host=10.0.5.144,user=ppstat,db=ppstat ERROR: deadlock d
71 matches
Mail list logo
