Il 18-03-2009 21:32, Bryan Herger ha scritto:
All,
I am porting a database from MS SQL Server to Postgres. One of the
tables contains a list of names, which I would like to list
alphabetically. I noticed in the “O” names the following difference:
MSSQL:
O’Daniel
O’Neill
Oliveira
Oliver
While
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
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
On Thu, Mar 19, 2009 at 5:24 AM, Thom Brown thombr...@gmail.com 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?
Milos Findura find...@gmail.com 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)
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 find...@gmail.com writes:
where can be problem?
Presumably, one statement or the other
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
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
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 =
In response to Anton V. Belyaev anton.bely...@gmail.com:
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
On Thu, Mar 19, 2009 at 8:42 AM, Anton V. Belyaev
anton.bely...@gmail.com 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
É possível alterar o database corrente para criar um schema nele sem uso do \c
do psql?
Obrigado
MarceloG
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
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
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.
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
On Tue, Mar 17, 2009 at 5:25 AM, Juan Pereira
juankarlos.open...@gmail.com 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
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
2009/3/19 Alvaro Herrera alvhe...@commandprompt.com:
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/
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
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
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
- 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 topmixtot (int[])
Tom Lane wrote:
Adrian Klaver akla...@comcast.net 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
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
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:
hello
2009/3/19 jc_mich juan.mich...@paasel.com:
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
On Thu, Mar 19, 2009 at 12:11 PM, jc_mich juan.mich...@paasel.com 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
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 possibly
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
On Wed, Mar 18, 2009 at 3:57 PM, Greg Sabino Mullane g...@turnstep.comwrote:
-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,
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
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.
IDE
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
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 maintained by
Rob Richardson rob.richard...@rad-con.com 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
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
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 maintained by
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
-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'm
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
On Thu, Mar 19, 2009 at 3:16 PM, Dann Corbit dcor...@connx.com 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
2009/3/19 Grzegorz Jaśkiewicz gryz...@gmail.com:
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* ,
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
On Thu, Mar 19, 2009 at 3:50 PM, Will Rutherdale (rutherw)
ruth...@cisco.com 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
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
-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 meaningful
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
On Thu, Mar 19, 2009 at 4:02 PM, Will Rutherdale (rutherw)
ruth...@cisco.com 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
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
On Thu, Mar 19, 2009 at 3:56 PM, Will Rutherdale (rutherw)
ruth...@cisco.com 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
On Thu, Mar 19, 2009 at 4:11 PM, Will Rutherdale (rutherw)
ruth...@cisco.com 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
On Thu, Mar 19, 2009 at 3:26 PM, John Cheng chonger.ch...@gmail.com 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
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
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
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
2009/3/19 Merlin Moncure mmonc...@gmail.com:
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
2009/3/19 John R Pierce pie...@hogranch.com:
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
On Thu, Mar 19, 2009 at 4:24 PM, Will Rutherdale (rutherw)
ruth...@cisco.com 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
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
On Thu, 19 Mar 2009 12:28:11 -0500
ries van Twisk p...@rvt.dds.nl 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�
Michael Higgins wrote:
On Thu, 19 Mar 2009 12:28:11 -0500
ries van Twisk p...@rvt.dds.nl 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.
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
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
On Thu, Mar 19, 2009 at 3:23 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Thu, Mar 19, 2009 at 3:26 PM, John Cheng chonger.ch...@gmail.com
wrote:
Comparison between MySQL using the MyISAM engine with PostgreSQL is
really
not sensible. For one, the MyISAM engine does not have
2009/3/19 Grzegorz Jaśkiewicz gryz...@gmail.com:
2009/3/19 Merlin Moncure mmonc...@gmail.com:
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
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
True
On Thu, Mar 19, 2009 at 11:50 AM, Scott Marlowe scott.marl...@gmail.com wrote:
On Tue, Mar 17, 2009 at 5:25 AM, Juan Pereira
juankarlos.open...@gmail.com wrote:
Hello,
The question is: Which DBMS do you think is the best for this kind of
application? PostgreSQL or MySQL?
Another advantage
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
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 $$
DECLARE
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
71 matches
Mail list logo