Hurray, that works!
Many thanks David
CREATE OR REPLACE FUNCTION custom.pr_test_parentfunction (
v_action varchar,
out swv_refcur refcursor,
out swv_refcur2 refcursor,
out swv_refcur3 refcursor
)
RETURNS record AS
$body$
DECLARE
SWV_Action VARCHAR(50) DEFAULT Coalesce(v_Act
jonathansfl wrote
> SELECT * INTO v_outvar1, v_outvar2, v_outvar3 FROM
> custom.pr_test_subfunction(SWV_Action);
> OPEN swv_refcur for SELECT v_outvar1;
> OPEN swv_refcur2 for SELECT v_outvar2;
> OPEN swv_refcur3 for SELECT v_outvar3;
> RETURN;
I've never used cursors in this
I'm trying to pass a REFCURSOR variable from a subfunction to its parent
calling function, who will then pass it to the user (for parsing).
thanks to David J I fixed it somewhat, but the user now receives the TEXT of
(etc.) instead of the actual data in that REFCURSOR
variable.
I think the proble
Thank you!
What kind of variable would I declare? Is this any form of right?
No change to subfunction.
In PARENT Function:
DECLARE v_outvar1 REFCURSOR; v_outvar2 REFCURSOR; v_outvar3 REFCURSOR;
?And use:
SELECT * INTO v_outvar1, v_outvar2, v_outvar3 FROM
dev.pr_test_subfunction(SWV_Action);
jonathansfl wrote
> greetings. I'm trying to write a function that acts like a switchboard,
> calling other functions depending on incoming parameters.
> I'm getting error: query has no destination for result data
>
>
> SELECT * FROM dev.pr_test_subfunction(SWV_Action);
In pl/pgsql if you
ed...';
However it works now. Again thanks to Mr. Wolfe.
Thanks and Regards
Kaleeswaran Velu
From: Wolfe Whalen
To: Kaleeswaran Velu
Cc: Postgres SQL List
Sent: Thursday, April 4, 2013 12:58 PM
Subject: Re: [SQL] Postgres trigger issue with update statem
On 04/03/2013 09:08 PM, Kaleeswaran Velu wrote:
Hello Friends,
I am new to Postgres DB. Recently installed Postgres 9.2.
Facing an issue with very simple trigger, tried to resolve myself by
reading documents or google search but no luck.
I have a table A(parent) and table B (child). There is a
Hi Kaleeswaran,
We're glad to have you on the mailing list. I don't know enough about
your trigger function to know exactly where it's going wrong, but I
threw together a quick example that has an insert trigger on a child
table that updates a row on the parent table. I'm hoping this might
hel
Harald Fuchs wrote:
>> hi, i am fairly new in postgresql, so if anyone can help me would be great
>> if i simply do:
>> select ver_no
>> from version
>> order by ver_no
>> the result will be something like this:
>> .1.3.1
>> .1.3.2.5.
>> .1.4.1.7.12
>> .1.4.11.14.7.
>> .1.4.3.109.1.
>> .1.4.8.
In article ,
James Bond writes:
> hi, i am fairly new in postgresql, so if anyone can help me would be great
> if i simply do:
> select ver_no
> from version
> order by ver_no
> the result will be something like this:
> .1.3.1
> .1.3.2.5.
> .1.4.1.7.12
> .1.4.11.14.7.
> .1.4.3.109.1.
> .1.4.8.
James Bond wrote:
> hi, i am fairly new in postgresql, so if anyone can help me would be great
>
> if i simply do:
>
> select ver_no
> from version
> order by ver_no
>
> the result will be something like this:
>
> .1.3.1
> .1.3.2.5.
> .1.4.1.7.12
> .1.4.11.14.7.
> .1.4.3.109.1.
> .1.4.8.66.
>
On Mon, 24 Jan 2011 10:38:02 +0100
- wrote:
> Hello everyone.
> My question if any known one postgres function, for full text
> search that separates words with "| "?
> As plainto_tsquery separating words with "& ".
>
> For example text "word1 word2 word3 word4"
> and conversion rates for full t
fine. However, PostGRES can interact with
tables with mixed case letters just fine.
Thanks,
Mike
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Monday, August 30, 2010 11:40 PM
To: Michael Andrew Babb
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] PostGres
On Mon, Aug 30, 2010 at 1:31 PM, Michael Andrew Babb wrote:
> Hi All,
> If I execute a make table query along the lines of “select * into
> SF30001_test from SF30001” I can interact with the table in ArcCatalog just
> fine.
what do
\z SF30001
\z SF30001_test
say about the permissions on the two t
Bryce Nesbitt writes:
> Every so often our production Postgres 8.3 system will get statement
> that runs for a few hours, or a few days, or more, and needs to be
> killed dead. We kill it with pg_cancel_backend(), and cpu usage of the
> process immediately drops, and the process starts serving ot
On Tue, Apr 14, 2009 at 2:59 PM, Bryce Nesbitt wrote:
> Scott Marlowe wrote:
>>
>> What does pg_locks say during this time? Specifically about locks
>> that aren't granted?
>
> I don't know, yet. Though these events go for 15-30 minutes before postgres
> restart, and no deadlocks are detected, s
Scott Marlowe wrote:
What does pg_locks say during this time? Specifically about locks
that aren't granted?
I don't know, yet. Though these events go for 15-30 minutes before
postgres restart, and no deadlocks are detected, so I don't think it is
locks.
--
Sent via pgsql-sql mailing list (p
Thanks for the thoughts on what to check. Unfortunately, the priority
of the people responding to the incidents has been to get the system
live again. I will add these items to a list that, hopefully, will be
run through prior to restarting Postgres.
Achilleas Mantzios wrote:
Did you check
On Tue, Apr 14, 2009 at 12:25 AM, Bryce Nesbitt wrote:
> We have a medium scale installation of Postgres 8.3 that is freezing about
> once a week. I'm looking for any hints on how to diagnose the situation, as
> nothing is logged.
>
> The system is matched pair of Sunfire servers, running Debian
Στις Tuesday 14 April 2009 09:25:54 ο/η Bryce Nesbitt έγραψε:
> We have a medium scale installation of Postgres 8.3 that is freezing
> about once a week. I'm looking for any hints on how to diagnose the
> situation, as nothing is logged.
>
> The system is matched pair of Sunfire servers, runnin
am Tue, dem 11.11.2008, um 14:57:20 +0100 mailte Bart van Houdt folgendes:
> Hi all,
Please, don't hijack other threads.
>
> This might be a stupid question, but I wasn't able to find any information on
> it, so here it goes:
> Oracle knows a view which contains information about indexed colu
Cool!
Thx :D
Bart van Houdt
Syfact International B.V.
Database developer
-Original Message-
From: Mario Splivalo [mailto:[EMAIL PROTECTED]
Sent: dinsdag 11 november 2008 15:03
To: pgsql-sql@postgresql.org
Cc: Bart van Houdt
Subject: Re: [SQL] Postgres version of all_ind_cols
Bart van
Bart van Houdt wrote:
Hi all,
This might be a stupid question, but I wasn't able to find any information on
it, so here it goes:
Oracle knows a view which contains information about indexed columns
(all_ind_cols), is there something similar available in Postgres?
I want to be able to create a
I guess you can change a little the query to your needs.
The problem is pretty much the same...
I've used c3 column in equality, but if this column
has repeated values, just choose any column or combination of columns which
is unique.
Best,
Oliveiros
SELECT a.c1,a.c2,b.c3,b.c4,a.c5,b.c6
FROM
(
SE
Just add two conditions on the previous query
A particularity of this approach is that the non-null record will always
appear with the first child in alphabetical order.
But, according to what you explain, I guess it is OK, and if it doesn't it
is easily changed. :-)
Also I've changed the first c
hi,
i don't want any sort.. just like this example
*num father child age col5
*1 joe bruce14 8
lei 10
mike 5
2manuel child135 16
child233
child3 30
this is what
Howdy, Zied.
The query below outputs the results as you want, but
I suspect you have a more general situation you want to solve.
If you have more than one father, say "manuel", you would want something like
this ?
num father child age
1 joe bruce14
lei
Hai all,
my postgres version is PostgreSQL 8.1.8 didn't support clock_timestamp()
regards:
Anoop
2008/7/25 Anoop G <[EMAIL PROTECTED]>:
>
> Hai all,
>
>I have database running on server. I am using python to run my
> application.postgres client is running on the clients .All clients are
> connected to a single database running on server. Each time application
> starts ,the login time is
Anoop G wrote:
Hai all,
I have database running on server. I am using python to run my
application.postgres client is running on the clients .All clients are
connected to a single database running on server. Each time application
starts ,the login time is taken from server using the query
"
Hai all,
I have database running on server. I am using python to run my
application.postgres client is running on the clients .All clients are
connected to a single database running on server. Each time application
starts ,the login time is taken from server using the query
"""select CAST ( t
On Thu, Jul 24, 2008 at 7:56 AM, Anoop G <[EMAIL PROTECTED]> wrote:
> Hai all,
>
> when i was going through the Postgresql documents, i came across a section
> which tells about the TIME ZONE settings
>
>
> what i understood from the document is, based on the value given in this
> conf file postgre
Chadwick Horn wrote:
It looks to me like psql is managing to start a new connection
before the postmaster notices the crash of the prior backend and
tells everybody to get out of town. Which is odd, but maybe not
too implausible if your kernel is set up to favor interactive
processes over ba
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
I keep getting this error:
Attempting reset: WARNING: terminating connection because of crash of
another server process
It looks to me like psql is managing to start a new connection before
the postmaster notices the crash of the prior backend and
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
> I keep getting this error:
> Attempting reset: WARNING: terminating connection because of crash of another
> server process
It looks to me like psql is managing to start a new connection before
the postmaster notices the crash of the prior backend an
TECTED]>
To: "Chadwick Horn" <[EMAIL PROTECTED]>
Cc: "Tom Lane" <[EMAIL PROTECTED]>;
Sent: Tuesday, March 18, 2008 8:37 AM
Subject: Re: [SQL] postgres server crashes unexpectedly
On Tue, 18 Mar 2008, Chadwick Horn wrote:
Sorry about the lack of information
On Tue, 18 Mar 2008, Chadwick Horn wrote:
Sorry about the lack of information on the system. We're running fedora (not
for sure what version though) core (whitebox).
This may not matter in the least bit, but have you tried running the DB on
a real RHEL, or CentOS box? The kernel and libs on
t;[EMAIL PROTECTED]>
To: "Chadwick Horn" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, March 17, 2008 7:32 PM
Subject: Re: [SQL] postgres server crashes unexpectedly
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
PANIC: corrupted item pointer: offset = 0, size = 0
LOG:
"Chadwick Horn" <[EMAIL PROTECTED]> writes:
> PANIC: corrupted item pointer: offset = 0, size = 0
> LOG: autovacuum process (PID 3037) was terminated by signal 6
Hmm ... the only instances of that error text are in PageIndexTupleDelete
and PageIndexMultiDelete, so we can fairly safely say that y
Pascal Tufenkji wrote:
Hi Shane,
You are exactly right.
My issue is that, I now have one role called sti - that has carried the
group members from the old version -
So what do you think my options are, so I can separate them?
I have only one option in my mind:
- Revoke the me
ry 08, 2008 3:54 PM
To: [EMAIL PROTECTED]
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Postgres roles
Pascal Tufenkji wrote:
> My questions are:
>
>
>
> 1. how do I identify the users assigned to this role :
> (in the older version)
> SELECT grolist f
Pascal Tufenkji wrote:
My questions are:
1. how do I identify the users assigned to this role :
(in the older version)
SELECT grolist from pg_group where groname = 'sti';
"The view pg_group exists for backwards compatibility: it emulates a
catalog that existed in PostgreSQL before
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> Namely, I shutdown the database, issued two commands:
> /sbin/sysctl -w kernel.shmmax=134217728
> /sbin/sysctl -w kernel.shmall=2097152
> and rebooted the computer.
>
> After it came up, I checked the shmmax and it is set
> as 33554432. Which surpris
--- On Wed, 11/14/07, Tena Sakai <[EMAIL PROTECTED]> wrote:
> The postgres server I have (on redhat linux with recent
> Dell hardware) is running terribly slow.
Hello Tena,
If you do not get a response to your question regarding performance, you might
try resending this email to : [EMAIL PROTECT
On 8/29/07, Radhika Sambamurti <[EMAIL PROTECTED]> wrote:
> Hi,
> I am using a function in postgres 7.4 that returns an integer.
> I modified my store procedure (same function and parameters) to point to
> another table, and return an int.
> But now I am not getting the correct answer only 0.
>
>
Sumeet <[EMAIL PROTECTED]> writes:
> My Vacuum's are running very very slow and expecially when vacuuming indexes
> in large tables of size in 5-10 gigabytes,
> can some one help me determine the parameters for postgres.conf which will
> help me vacuum fast. I'm running postgres on a server with 32
On Tue, 2007-03-13 at 15:48, Sumeet wrote:
> On 3/13/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
> On 3/14/07, Sumeet <[EMAIL PROTECTED]> wrote:
> > Hi All,
> Hi,
>
> > Sorry if this is the wrong list to ask this question.
> General woould have
The only info i have is
Apple xRaid drive array with 14 400GB drives for a total of 5 TB storage
I have around 10-15 indexes for each tables. does the number of indexes slow
down the vacuum process?
indexes are compund indexes on multiple fields.
-Sumeet
On 3/13/07, Andrej Ricnik-Bay <[EMAIL P
On 3/14/07, Sumeet <[EMAIL PROTECTED]> wrote:
Hi All,
Hi,
Sorry if this is the wrong list to ask this question.
General woould have been better :)
My Vacuum's are running very very slow and expecially when vacuuming indexes
in large tables of size in 5-10 gigabytes,
can some one help me det
On Tue, 2006-09-05 at 11:22 -0400, Tom Lane wrote:
> Mario Splivalo <[EMAIL PROTECTED]> writes:
> > So, I guess it's obvious that postgres doesn't treat regular expressions
> > the same way as java/perl/pyton/php/awk/sed do...
>
> When you get into stuff as arcane as word-boundary constraints, you
On 9/5/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
In Perl at least, \b is a word boundary. In PostgreSQL (and probablyTcl as well) it's a backslash AFAICT.More specifically, Perl, Java and Python interpret \b as a backspace in the Character class only (got that from the Regular _expression_ poc
Mario Splivalo <[EMAIL PROTECTED]> writes:
> So, I guess it's obvious that postgres doesn't treat regular expressions
> the same way as java/perl/pyton/php/awk/sed do...
When you get into stuff as arcane as word-boundary constraints, you'll
find that regexes are not NEARLY as well standardized as
Mario Splivalo wrote:
> On Tue, 2006-09-05 at 10:21 -0400, Alvaro Herrera wrote:
> > Mario Splivalo wrote:
> > > On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> > > > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
> > > >
> > > > pulitzer2=# select 'stop works' ~ '^\s*
On Tue, 2006-09-05 at 10:21 -0400, Alvaro Herrera wrote:
> Mario Splivalo wrote:
> > On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> > > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
> > >
> > > pulitzer2=# select 'stop works' ~ '^\s*(?:[\
> > > +|-]|(?:[sS][t
Mario Splivalo wrote:
> On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> > On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
> >
> > pulitzer2=# select 'stop works' ~ '^\s*(?:[\
> > +|-]|(?:[sS][tT][oO][pP]\b)).*$';
> > ?column?
> > --
> >
On Tue, 2006-09-05 at 08:42 -0500, Aaron Bono wrote:
> On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
>
> pulitzer2=# select 'stop works' ~ '^\s*(?:[\
> +|-]|(?:[sS][tT][oO][pP]\b)).*$';
> ?column?
> --
> f
> (1 row)
>
On Tue, 2006-09-05 at 10:11 -0400, Tom Lane wrote:
> Mario Splivalo <[EMAIL PROTECTED]> writes:
> > Now, here is what happens if I try this in postgres:
>
> > pulitzer2=# select '+mario' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$';
>
> I'm thinking you've forgotten to double your backslashes.
>
Mario Splivalo <[EMAIL PROTECTED]> writes:
> Now, here is what happens if I try this in postgres:
> pulitzer2=# select '+mario' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$';
I'm thinking you've forgotten to double your backslashes.
regards, tom lane
-
On 9/5/06, Mario Splivalo <[EMAIL PROTECTED]> wrote:
pulitzer2=# select 'stop works' ~ '^\s*(?:[\+|-]|(?:[sS][tT][oO][pP]\b)).*$'; ?column?-- f(1 row)Here, postgres should return true, but it gives me false.
\b is a back-space - is that what you are wanting there? If I remove it I get tru
Schnabl, Sebastian wrote:
> I use postgres 8.1 and trie to run jboss over sequoia-ha
> (http://sequoia.continuent.org/HomePage). But i have an problem with
> sequences. Sequoia claims to support for good reasons and
> db-independece only "sql-standard(s)". Therefore they DON'T support
> the postgre
On Fri, 2005-10-21 at 10:20 -0400, Tom Lane wrote:
> Mario Splivalo <[EMAIL PROTECTED]> writes:
> > I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> > One has 85000 records, and other has 100 records. I've been running
> > the tests on 7.4.3,
>
> Your later message sho
Mario Splivalo <[EMAIL PROTECTED]> writes:
> I have a query that does COUNT, LEFT JOIN and GROUP BY from two tables.
> One has 85000 records, and other has 100 records. I've been running
> the tests on 7.4.3,
Your later message shows 7.4.8. Which is it?
> But, now I downloaded postgres 7.4.9
On Friday 21 October 2005 14:34, Mario Splivalo wrote:
| On Fri, 2005-10-21 at 14:01 +0200, Havasvölgyi Ottó wrote:
| > Mike,
| >
| > Please send the EXPLAIN ANALYZE of the two versions of the query.
^^^
| There they are, they are both the same:
|
| join_test=# sele
On Fri, 2005-10-21 at 14:01 +0200, Havasvölgyi Ottó wrote:
> Mike,
>
> Please send the EXPLAIN ANALYZE of the two versions of the query.
There they are, they are both the same:
join_test=# select version();
version
--
Mike,
Please send the EXPLAIN ANALYZE of the two versions of the query.
Best Regards,
Otto
- Original Message -
From: "Mario Splivalo" <[EMAIL PROTECTED]>
To:
Sent: Friday, October 21, 2005 1:13 PM
Subject: [SQL] Postgres 7.4.9 slow!
Hello! I'm not sure if this belongs to this mai
O "Michael Hφller" έγραψε στις Sep 22, 2005 :
>
>
> Hello,
>
> I like to automate a daily check and like to run select statement via
> cron but this seems to be more tricky than I thought
>
> I tried the following:
> su postgres -c "select count(*) from TABLE where xx;"
Firstoff, 'sel
am 22.09.2005, um 15:55:53 +0200 mailte "Michael Höller" folgendes:
>
>
> Hello,
>
> I like to automate a daily check and like to run select statement via
> cron but this seems to be more tricky than I thought
>
> I tried the following:
> su postgres -c "select count(*) from TABLE where xx
Hi Michael,
On Thursday 22 September 2005 15:55, Michael Höller wrote:
| I like to automate a daily check and like to run select statement via
| cron but this seems to be more tricky than I thought
|
| I tried the following:
| su postgres -c "select count(*) from TABLE where xx;"
you mean
There is the postgresql-8.0.3-1.i386.rpm for Fedora Core 4 in
http://ftp.idilis.ro/mirrors/fedora/core/4/i386/os/Fedora/RPMS/
and others mirrors. I don't know if it works with Fedora Core 2. Probably not.
For Fedora Core 3 there is the postgresql-7.4.6-1.FC3.1.i386.rpm in
http://ftp.idilis.ro/m
Dinesh Pandey wrote:
From where can I download?
"Postgres 8.x" + required packages and "installation instruction" of
Postgres for Fedora Core 2 OS.
Umm - did you try the website: http://www.postgresql.org/
Click "Downloads", click "FTP Browser", look in v8.03, linux, rpms,
fedora, fedor
Hello.
You (Dinesh Pandey) wrote:
> I am installing Postgres 8.0.1 on Solaris 10 Sparc:
> [...]
> I am getting this error
> [...]
> ld: fatal: library -lgcc_s: not found
How did you configure?
I built 8.0.2 using ./configure --prefix=/opt/local
(i.e. nothing special) on a fresh Solaris 10 03/05
On Wed, Mar 30, 2005 at 04:23:34PM -0500, Robert Treat wrote:
>
> Would it be possible to use a BEFORE trigger to reformat the -DD-MM
> date to -MM-DD ? The error I see on 7.4 is ERROR: date/time field
> value out of range: "2005-14-01" so ISTM you could do some data
> manipulation if you
On Mon, 2005-03-28 at 15:48, Scott Marlowe wrote:
> On Mon, 2005-03-28 at 13:44, Thomas Seeber wrote:
> > Hi,
> >
> > We were upgrading from postgres 7.3 -> 8.0 and having a little
> > problems importing dates from some of our data sources. Say we have a
> > date like '2004-17-05'. In postgres 7
On Mon, 2005-03-28 at 13:44, Thomas Seeber wrote:
> Hi,
>
> We were upgrading from postgres 7.3 -> 8.0 and having a little
> problems importing dates from some of our data sources. Say we have a
> date like '2004-17-05'. In postgres 7.3, postgres would intrept this
> as Year Day Month automatica
> > Yes, you are rigth... my insert/update are very
> simple
> > and without problems and so I think to use
> 'foreign
> > key' coded to make faster/simpler the management
> and
> > don't overloading the db (and use exception code
> > management )... but I had a problem with pgSQL
> because
> > ser
> > No, I haven't foreign keys in the older version,
> in
> > that new I've it... however I manage relations
> from
> > app code (PHP)...
>
> Really ?
> In my experience this is a sure way to get
> inconsistencies slowly
> creeping into your database, and you also get a load
> of fun
--- PFC <[EMAIL PROTECTED]> wrote:
> You mean, you have no foreign keys in your database
?
> In SELECT they are definitely useful (think select
> for update, isolation
> level serializable...)
No, I haven't foreign keys in the older version, in
that new I've it... however I manage re
Hi, Stef,
Stef schrieb:
> It will be a bonus to pick up exactly what is missing, but for now, just
> identifying
> differences is what I want to achieve. I'm using postgres 7.3 mostly, but
> I may want to use this for 7.4 and 8.0 databases as well.
>
> Has anybody got some suggestions of what
Really ?
In my experience this is a sure way to get
inconsistencies slowly
creeping into your database, and you also get a load
of funky concurrency
issues.
Yes, you are rigth... my insert/update are very simple
and without problems and so I think to use 'foreign
key' coded to make
No, I haven't foreign keys in the older version, in
that new I've it... however I manage relations from
app code (PHP)...
Really ?
In my experience this is a sure way to get inconsistencies slowly
creeping into your database, and you also get a load of funky concurrency
issues.
doesn't MYSQ
I don't require transaction because the query aren't
complex and update a single tuple (in SELECT
transactions are useless)
You mean, you have no foreign keys in your database ?
In SELECT they are definitely useful (think select for update, isolation
level serializable...)
- start quote -
Yo
Hi Richard, thank you for your apreciated answers!!!
- start quote -
Well, do you care whether your data is consistent or
not? If not, you
don't need transactions.
- end quote -
I don't require transaction because the query aren't
complex and update a single tuple (in SELECT
transactions are us
Hi, thanks a lot! you are rigth, but I did read your
message ;)
Yes,
1- I misconfigured PostgreSQL (I thought that was
already configured in base to the released version -
Fedora Core 3 64bit).
2- The bench is, clearly after your precisations, an
MySQL tuned application tests.
3- I think the bench
[EMAIL PROTECTED] (PFC) writes:
>> The reason PostgreSQL is slower is because it (and by extension the team
>> behind it) cares about your data.
>
> Sure, postgres is (a bit but not much) slower for a simple
> query like SELECT * FROM one table WHERE id=some number, and
> postgres is a lot sl
On Wed, 02 Mar 2005 09:00:14 -0600, Scott Marlowe
<[EMAIL PROTECTED]> wrote:
(...)
> The reason PostgreSQL is slower is because it (and by extension the team
> behind it) cares about your data.
>
> Here's a list of the things MySQL will gladly do wrong:
>
> http://sql-info.de/mysql/gotchas.html
This sort of discussion should really go onto -performance, but I'm
at pains to stomp out a common misperception.
On Wed, Mar 02, 2005 at 10:45:38PM +0100, PFC wrote:
>
> Sure, postgres is (a bit but not much) slower for a simple
> query like SELECT * FROM one table WHERE id=some numb
On Wed, 2005-03-02 at 15:45, PFC wrote:
> > The reason PostgreSQL is slower is because it (and by extension the team
> > behind it) cares about your data.
>
> Sure, postgres is (a bit but not much) slower for a simple query like
> SELECT * FROM one table WHERE id=some number, and postgres
The reason PostgreSQL is slower is because it (and by extension the team
behind it) cares about your data.
Sure, postgres is (a bit but not much) slower for a simple query like
SELECT * FROM one table WHERE id=some number, and postgres is a lot slower
for UPDATES (although I heard that it's f
On Tue, 2005-03-01 at 04:52, mauro wrote:
> > Not always, AFAICT. The four most common reasons why PG tests slower
> > than Mysql are:
> > 1. You haven't configured or have misconfigured PostgreSQL.
> > 2. You are testing a MySQL-tuned application (lots of small, simple
> > queries, no views, no
Mauro Bertoli wrote:
Hi Richard, thank you for your apreciated answers!!!
- start quote -
Well, do you care whether your data is consistent or
not? If not, you
don't need transactions.
- end quote -
I don't require transaction because the query aren't
complex and update a single tuple (in SELEC
Mauro Bertoli wrote:
Hi, thanks a lot! you are rigth, but I did read your
message ;)
Yes,
1- I misconfigured PostgreSQL (I thought that was
already configured in base to the released version -
Fedora Core 3 64bit).
2- The bench is, clearly after your precisations, an
MySQL tuned application tests.
mauro wrote:
Not always, AFAICT. The four most common reasons why PG tests slower
than Mysql are:
1. You haven't configured or have misconfigured PostgreSQL.
2. You are testing a MySQL-tuned application (lots of small, simple
queries, no views, no subselects etc)
3. You are only testing one conne
On Tue, Mar 01, 2005 at 02:52:31AM -0800, mauro wrote:
> select_range_key2 89224
> select_range_prefix 89054
> update_of_primary_key_many_keys 20495
These look suspect, especially the first two, and they account for
over 78% of the total. D
> Not always, AFAICT. The four most common reasons why PG tests slower
> than Mysql are:
> 1. You haven't configured or have misconfigured PostgreSQL.
> 2. You are testing a MySQL-tuned application (lots of small, simple
> queries, no views, no subselects etc)
> 3. You are only testing one connec
mauro wrote:
What number does '' represent?
'No response' value...
Would've been better to have a genuine response_provided flag, but then
you obviously know that.
Who is providing an empty string where you've asked for a number, and
why not trap this error (or store a NULL)?
You are certainly r
> What number does '' represent?
'No response' value...
> Does that mean a string of '/2' should equal your number divided by two?
right, but it is never required.
> If not, why not?
because I use it to GROUP BY values.
> Who is providing an empty string where you've asked for a number, and
> why
I had a good install, but I did not
install 7.4 when I installed redhat.
It asked for the cd’s a couple times
when I loaded the RPMS 8.0.1
I also did not use any fire wall or
security (it is in a secure environment).
Joel Fradkin
__
mauro wrote:
Hi, In previous version di Postgres (7.2) I used this table:
CREATE TABLE tablename (id serial, field int1, field2 text);
Now this query work:
UPDATE tablename SET field1=''; (NOTE: implicit conversion to 0)
UPDATE tablename SET field2='';
(this cause of simple code-generation query -
mauro wrote:
Hi, I understand this is an super-older thread!! note: i like
postgres and not mysql!
Hi Mauro! Whether you like it or hate it, you're in the right place to
ask questions about it.
I'm a Postgres server user: I've postgres 7.2 and 8.0 in many servers
and I've tested performance Postgr
pgsql-sql@postgresql.org
Subject: Re: [SQL] postgres 8 data directory other then default?
Joel Fradkin wrote:
> I am trying to use a different drive for the data.
>
> I have edited postgres.conf to point to the new location, but I get the
> error /pgdata/PG_VERSION is missing.
>
1 - 100 of 180 matches
Mail list logo
