IN SELECT rolname FROM pg_roles LOOP
RETURN NEXT rec.rolname;
END LOOP;
END;
$$ LANGUAGE plpgsql;
And simpler as an SQL function (although, again, why bother?):
CREATE OR REPLACE FUNCTION test_sql() RETURNS SETOF name AS $$
SELECT rolname FROM pg_roles
$$ LANGUAGE sql;
ibpq believes that the
*other end* of the connection was terminated unexpectedly, but
considering it was an Oracle instance that it was communicating with,
I'm not sure what it could/should do better. In any case, the Oracle
side of this connection is what "closed unexpectedly".
access to /home/database/pgdata/cobis/bitvg?
Try:
su postgres
cd /home/database/pgdata/cobis/bitvg
Joe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column&#
Cornelia Boenigk wrote:
Hi Joe
> Try:
> su postgres
> cd /home/database/pgdata/cobis/bitvg
Succeeds, ls -la shows all files in that directory and can open them
with less.
Kind of odd, particularly given your reply to Tom's question in a nearby
post. Could it be an
tions. I think only plpgsql does right now.
Actually no. Plperl, plphp, plruby and I believe even pl/Tcl support set
returning functions.
and so does PL/R
;-)
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensiv
ant to pay for
support for a free product.
Joe
joe_audette [at] yahoo dotcom
http://www.joeaudette.com
http://www.mojoportal.com
- Original Message
From: Nikolay Samokhvalov <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Thursday, August 3, 2006 2:58:03 PM
Subje
I'm having a little trouble restoring a backup (from the production
server to our development server).
I recently updated both production and development servers to
postgres 8.1.4 from 8.0.x. When I updated production, I did a fresh
initdb and imported from a previous dump. This server is r
Hi,Development is Mac OS 10.4.0 (PPC). Production is Mac OS 10.4.7 (Intel). Is that the kicker... PPC vs Intel?On Aug 8, 2006, at 1:46 PM, Talha Khan wrote:Hey Joe!! Which OS are you running on development server and production server?? regards Talha Khan On 8/8/06, Joe Lester <[EMAIL PROTEC
ack from a business trip, and am trying to get caught up --
give me a few days and I'll see if I can help (i.e. I should be able to
find time on the weekend)...
Joe
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
se, which will probably
be sometime after postgres 8.2 beta starts.
Joe
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messag
Hello,
I am designing database for a web product with large number of data records.
- Few tables but number of objects is tens-hundreds of thousands.
- less than 100 queries per second.
The application has basically tens thousands of (user) accounts,
every account has associated hundreds of it
PHP and Java are not the only options.
My project, mojoPortal, is written in C# and runs under .NET on windows or Mono
on nix
It works with PostgreSQL or MySQL (or MS SQL or SQLite)
Worth a look:
http://www.mojoportal.com
joe_audette [at] yahoo dotcom
http://www.joeaudette.com
http://
on gborg or pgfoundry.
Joe
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
.objname);
res.privs := priv;
RETURN NEXT res;
end if;
end loop;
for rec in
select lanname as objname from pg_language loop
priv := '''';
sep := '''';
if has_language_privilege(v_user, quote_ident(rec.objname),
''USAGE'') then
priv := priv || sep || ''USAGE'';
sep := '','';
end if;
if priv != '''' then
res.objtype := ''language'';
res.objname := quote_ident(rec.objname);
res.privs := priv;
RETURN NEXT res;
end if;
end loop;
for rec in
select nspname as objname from pg_namespace loop
priv := '''';
sep := '''';
if has_schema_privilege(v_user, quote_ident(rec.objname),
''CREATE'') then
priv := priv || sep || ''CREATE'';
sep := '','';
end if;
if has_schema_privilege(v_user, quote_ident(rec.objname),
''USAGE'') then
priv := priv || sep || ''USAGE'';
sep := '','';
end if;
if priv != '''' then
res.objtype := ''schema'';
res.objname := quote_ident(rec.objname);
res.privs := priv;
RETURN NEXT res;
end if;
end loop;
return;
end;
' language plpgsql;
HTH,
Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
etails. Can you post a self-contained example that
recreates the problem?
Joe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
enerate any UPDATE query.
Do you want me to take a look at this, or are you planning to?
Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
Any guidance on the preferred fix?
We cannot fix this by changing ExecScanSubPlan as you suggest.
That would amount to saying that all plans have to be run to completion,
which destroys LIMIT to name just one unpleasant conseque
.
OK -- this one is a good bit simpler. Any more comments?
Joe
Index: src/backend/utils/fmgr/funcapi.c
===
RCS file: /opt/src/cvs/pgsql-server/src/backend/utils/fmgr/funcapi.c,v
retrieving revision 1.12
diff -c -r1.12 funcapi.c
e relname like 'table%';
oid | relname
-+-
1245674 | table1
1245676 | table2
(2 rows)
It seems that second pass through ExecCheckRTEPerms() is not doing the
right thing. It ought to be checking table2 (not table1) for UPDATE as
userid == 1 (not 101), shouldn
[EMAIL PROTECTED] wrote:
RH> I could have sworn there was something in contrib/ too, but I can't see it
RH> now.
Yes it is gone. :)
See contrib/tablefunc for a function called connectby().
Joe
---(end of broadcast)---
TIP 5: Have you
[EMAIL PROTECTED] wrote:
I know I can write plpgsql functions that return sets.
Does postgres support returning multiple sets from a function?
No.
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
here for a variety of packages to do just about any kind of
analysis you can think of:
http://cran.r-project.org/
Some assembly required, but powerful and free.
HTH,
Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free
nning). If the local transaction fails, send an
ABORT to the remote side before closing the connection. However I can't
offhand think of a way to do that in an automated fashion.
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usen
Oleg Lebedev wrote:
Agreed. I wonder if I should simulate local Xactions by using local
dblink calls?
What do you think, Joe?
It is an interesting thought. Withing a single plpgsql function, open
one local and one remote persistent, named dblink connection. Start a
transaction in each. Go into
s that would be
unique enough to be sure same named types were actually the same.
Joe
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
like this in the docs.
Is there currently any way of doing this? are there any plans for it?
There is no way to do this now, and no plans that I know of, but it does
look useful. I'm not sure how painful it would be to make it happen
though...
Joe
---(e
= anyarray,
initcond = '{}'
);
array_append() is built-in in 7.4 -- and note both Pavel's solution and
this one require 7.4.x
HTH,
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
.4 if arrays are important to you.
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
2 | row\134row\002row\005
row\011 | row\005 | 3 | row\134row\002row\005row\011
row\003 | row\\| 1 | row\134row\003
row\007 | row\003 | 2 | row\134row\003row\007
(9 rows)
HTH,
Joe
Index: contrib/tablefunc/tablefunc.c
==
Joe Lester <[EMAIL PROTECTED]> writes:
I installed Postgres 7.4.1 on a dual processor G5 running Mac OS
10.3.2. I'm trying to increase the max_connections to 300 and running
into some trouble.
Hmm, it WorksForMe (TM). You did reboot after changing /etc/rc, no?
Yes, I did a "Restar
Joe Lester <[EMAIL PROTECTED]> writes:
That's odd. It's giving me a -1 for the shmmax value. I assume that's
NOT normal. Why would that be?
It's not --- you should get back the same value you set. I speculate
that you tried to set a value that exceeded some internal
Would this be kern.maxfiles? There's also one called
kern.maxfilesperproc.
Is it OK to set these before starting the server? Or should I set them
in /etc/rc?
On Feb 10, 2004, at 10:04 AM, Tom Lane wrote:
Also look at increasing the kernel's limit on number of open files
(I remember seeing it i
I'm using PostgreSQL 7.4.1. I have 140 clients connected on average
using libpq. When one client sends "NOTIFY timeclock;" to the server
all 140 clients are listening for it.
After receiving a notification from libpq (PQnotifies), each client
proceeds to execute a query for the last five record
Ron St-Pierre wrote:
I am using postgres 7.3.4 and need to be able to determine which
database a query is being run in (from a script). pg_database lists
databases but doesn't tell me which one is currently active.
See:
http://www.postgresql.org/docs/7.3/static/functions-misc.html
HTH,
Hello all,
I am in the process of planning disk utilization for postgres and was
wondering what was the storage size was for btree, rtree and hash indexes.
Thanks,
-Joe
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
---(end of broa
Yes, my client receives the notification and then it immediately
executes a query that hangs for a while.
On Feb 15, 2004, at 12:07 PM, Tom Lane wrote:
Hmm. Are you certain that the clients have received the NOTIFY?
Perhaps the bottleneck is in delivering the NOTIFY messages, not in
executing th
Thanks. I was kind of suspecting that. But it's nice to have it
confirmed.
I might try a random delay on the client side after receiving the
notification, before I query. That may help to break up the load on the
server.
On Feb 16, 2004, at 10:27 AM, Mikhail Terekhov wrote:
I'd say it is relat
300029002300
Any idea or suggestion?
See contrib/tablefunc for a function called crosstab().
HTH,
Joe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHer
rray",
and this type really needs to be marked as requiring double alignment
so that arrays of double-aligned datatypes will come out correctly.
anyarray has been defined this way since 7.3 -- any concerns there? I
see that back then pg_statistic used text[] instead of anyarray, so
pe
eq;
CREATE SEQUENCE
regression=# select nextval('seq'), currval('seq'), s from
generate_series(1,4) as t(s);
nextval | currval | s
-+-+---
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
(4 rows)
Joe
--
ATILE_VOLATILE'v' /* can change even within a scan */
OT: generate_series looks useful. Is this only in 7.5?
Yes, new in 7.5.
Joe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
;[SQL] How
to avoid "Out of memory" using aggregate functions? ". Is this fixed? Why is the
postmaster exceeding it's 102MB sort mem size when doing these queries and not paging out the data?
-Joe Maldonado
--
Using M2, Opera's revolutionary e-mail c
ts
2004-03-08 00:00:00-08
2004-03-08 03:00:00-08
2004-03-08 06:00:00-08
2004-03-08 09:00:00-08
2004-03-08 12:00:00-08
2004-03-08 15:00:00-08
2004-03-08 18:00:00-08
2004-03-08 21:00:00-08
2004-03-09 00:00:00-08
(9 rows)
HTH,
Joe
---(end of
x27;'tigris'' then
Second, you'll need to add a "return;" line after the "END IF" for the
cases where there is no match. In fact, you can just move the one from
within the IF...END IF to outside it.
HTH,
Joe
---(end of broadcast)-
Would anyone have some example code they could share using libpq to
encode an image into a text field? Right now, I'm converting my image
into a hexadecimal string representation in my SQL statement. I'm sure
there must be a better (faster) way. The hex encodeing/decoding slows
things down for
varchar, varchar) returns varchar as '
select replace($1 || '' '' || $2 || '' '' || $3, '' '', '' '')
' language sql;
regression=# select fconcat_name('John','','Doe');
fconc
Eric Ridge wrote:
On Apr 6, 2004, at 11:54 AM, Jan Wieck wrote:
And now you know why they are so good if you don't use all rows. This
benefit I think goes away if you use Joe Conway's suggestion of WITH
HOLD.
Okay, so WITH HOLD is actually materializing the entire resultset
(sequenti
I'm trying to figure out what the optimal Postgres configuration would be for my server (with 200 connecting clients, even though I'd really like to get it up to 500).
I've got a 700 MHz eMac running Mac OS 10.3.2 (Panther) with 512 MB of RAM. I've messed around with some settings but I'm still ge
Yeah. It was my shell that was the bottleneck. What did the trick was
adding this line in /etc/profile:
ulimit -n 8000
Thanks!
Bruno Wolff III <[EMAIL PROTECTED]> writes:
It sounds like what is really happening is that
you are hitting an OS limit on the number of open files. You should be
able
Marc G. Fournier wrote:
do you force learn those spam that get through the cracks? I get about 20
or 30 messages that slip through the cracks, which I process through with
sa-learn nightly ...
No, I haven't been doing that, but I guess I ought to start. Thanks for
the suggestion!
That makes sense since the "connection reset by peer" statement is
always followed immediately by
"unexpected EOF on client connection"
I should have noticed that before :-0
Thanks!
On Apr 20, 2004, at 10:04 PM, Doug McNaught wrote:
Joe Lester <[EMAIL PROTECTED]>
urly cron job as
follows:
/usr/bin/sa-learn --mbox --spam /path/to/false-neg.mbox
Now I just drop all false negatives into that mailbox, and clean them
out periodically. Hopefully that will make a significant improvement.
Joe
---(end of broadcast)-
::DB to store binary data in a bytea column, by
all means.
Did you try using pg_escape_bytea()?
Joe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere"
scalar return datums
pg_conversion.c:get_generic_array_datum()
conversion from multiple (char *values) to Datum using the gathered
info for array return datums
HTH,
Joe
---(end of broadcast)---
TIP 6: Have you searched our list archives
n" and show us the output of
make
make install
make installcheck
Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
rule_and_refint_t3 | rule_and_refint_t2 | {id3a,id3c} | {id2a,id2c}
fktable| pktable| {fk}| {id}
clstr_tst | clstr_tst_s | {b} | {rf_a}
(4 rows)
HTH,
Joe
---(end of broadcast)---
TI
(please keep posts on the list so that others can follow along)
[EMAIL PROTECTED] wrote:
Joe, I'm sorry but I cannot create functions or anything like that, it's
all has to be a select statement (or series of select statements). Users
pull up our product and browse all the databases an
Adam H. Pendleton wrote:
Joe Conway wrote: | Scot L. Harris wrote: |> Running Fedora Core 2
trying to build pgadmin3 from source. |> |> Build wxWindows from
sources. Appeared to build and install no problem. |> |> But when
building pgadmin get the following error as it tries to bu
src/include/utils: builtins.h
Log message:
Add comparison operators and btree indexing support for type
bytea. From Joe Conway.
You could go through cvs web to find the actual diffs, given the date
),
ballpark(11825.5540);
ballpark | ballpark | ballpark | ballpark
--+--+--+--
15.6 | 1826 | 7130 |11830
(1 row)
HTH,
Joe
---(end of broadcast)---
TIP 8: explain analyze is your friend
ainst calling this a bug? Now's the time to speak
up, particularly if you depend on this as a feature.
Thanks,
Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
y the diff to your
local copy of beta1:
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/dbsize/dbsize.c.diff?r1=1.10;r2=1.11
HTH,
Joe
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index sc
Thanks for the suggestion Scott. I did a...
find / -type f -size +10 -print
The results contained 9 Gig! of swap files:
/private/var/vm/swapfile0
/private/var/vm/swapfile1
/private/var/vm/swapfile10
[plus many more entries]
That seems to indicate to me a memory "leak" of some sort. My s
On Aug 20, 2004, at 2:28 PM, Tom Lane wrote:
I think what you've found is an OS X bug.
I was able to replicate this behavior on OS X 10.3.5. All I did was
start the postmaster and then start a continuous loop in a shell
window:
while true
do
psql -c "select count(*) from tenk1" regression
do
On Aug 20, 2004, at 2:43 PM, Tom Lane wrote:
Bill Moran <[EMAIL PROTECTED]> writes:
Joe Lester <[EMAIL PROTECTED]> wrote:
I'm wondering, however, if you have a connection leak instead. i.e.
is it possible that your client application is opening a whole bunch
of connections and n
On Aug 20, 2004, at 3:01 PM, Bill Moran wrote:
Please don't wrap machine-generated output ... it makes it VERY
difficult
to understand.
This is usually caused by a setting in your mail client that reads
something like "wrap lines at 72 characters" being turned on.
You should wrap your text at 72 c
pointers will be appreciated.
You can do what you want with set returning functions in
contrib/tablefunc. See examples towards the end of my recent OSCON
presentation:
http://www.joeconway.com/pres_oscon_2004-r1.pdf
and the source sql:
http://www.joeconway.com/flex.sql
HTH,
Joe
rt| index | time.jsp
(1 row)
See:
http://www.postgresql.org/docs/current/static/functions-string.html
On Postgres 8.0.0beta1 you could also do:
select s.f[2], s.f[3], s.f[4]
from (select string_to_array('/help/support/index/time.jsp','/') as f)
as s;
f |f
Greg Stark wrote:
How do you check to see how many records, or ideally which records, are being
toasted and/or stored externally?
I don't know of a builtin way to do that from SQL, but the attached
seems to work for me.
Joe
checktoast.tar.gz
Description: GNU Zip compressed
Joe Conway wrote:
Greg Stark wrote:
How do you check to see how many records, or ideally which records,
are being
toasted and/or stored externally?
I don't know of a builtin way to do that from SQL, but the attached
seems to work for me.
FWIW, this version has a bit more robust type che
Hello,
How come within a create schema block I cannot create a sequence?
I have entered in:
CREATE SCHEMA joe
CREATE SEQUENCE joe_seq start 1
CREATE TABLE joe_table (int id, varchar name)
;
and I get a syntax error for SEQUENCE. though if it is just tables I do not
-Joe
0%
in transactions per second.
Very interesting. Whose SAN are you using that supports the 2.6 kernel?
Thanks,
Joe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
s/7.3/interactive/arrays.html
Array support and documentation is significantly better in 7.4.x.
Joe
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Otto Blomqvist wrote:
I have several functions that are compiled as .so and runs pretty well
under PSQL. However I would like to be able to return errors (for
debugging) using something like this
See:
http://www.postgresql.org/docs/current/static/error-message-reporting.html
Joe
Katsaros Kwn/nos wrote:
> Having taken a look at the dblink code I have some questions:
ISTM that you might start with dblink_record() and modify it to suit
using SPI and asynchronous libpq calls. See:
http://www.postgresql.org/docs/current/static/libpq-async.html
anyone? My guess is that _poll is
referenced somewhere in libpq.a. Anyone have any ideas on how to get
the linking happening on Mac OS 10.3.5?
Thanks!
Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.post
resql.org/idocs/index.php?plpgsql-trigger.html
NEW
Data type RECORD; variable holding the new database row on INSERT/UPDATE
operations on ROW level triggers.
OLD
Data type RECORD; variable holding the old database row on UPDATE/DELETE
operations on ROW level triggers.
Hope this helps,
Joe
27;) FROM imagetable WHERE ...
And then convert from hex back to bin:
function hex2bin($data)
{
$data = trim($data);
$len = strlen($data);
return pack("H" . $len, $data);
}
If PHP could open a binary cursor (which I don't think it can, but could be
wrong)
cessed by the
last SQL query sent down to the SQL engine; and RESULT_OID, the Oid of the
last row inserted by the most recent SQL query. Note that RESULT_OID is only
useful after an INSERT query.
HTH,
-- Joe
---(end of broadcast)---
TIP 3: if posti
id from history where event_type = 120::int8;
See
http://fts.postgresql.org/db/mw/msg.html?mid=1031765
for some further explanation/history.
HTH,
-- Joe
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
tables.
>
> OK. That works for ./bin/psql, but NOT on the libpq's PQexec.
> What do I have to type here?
>
> Thanx again and lots of greetings from cool Spain
> Steve
Start up psql with the -E on the command line. Then do \d TABLE. This will
show you the actual SQL command
ware (dual ppro 200
with 512MB and RAID5) I got lookups times at around 10 milliseconds, from a
table with 20 million records. The key was a 40 byte hex string. The timing
was from running "set show_query_stats = true;" and then looking at the tail
of the postgres serv
xecute the same query not using SELECT TOP
?
>
See the LIMIT clause:
http://www.postgresql.org/idocs/index.php?sql-select.html
Hope this helps,
-- Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
README in
contrib/oid2name for more information. I haven't used it myself, but the
oid2name contib should let you more easily associate the OID names with the
database object names.
Hope this helps,
-- Joe
---(end of broadcast)---
TIP 5:
t sure of the best way to fix this yet, but I found that when
calling the function with argument types matching the prototype
perfectly, this code never gets executed.
HTH,
Joe
p.s. here's a backtrace:
#0 AllocSetAlloc (context=0x830a624, size=128) at aset.c:731
#1 0x081bcb14 in MemoryCont
Joe Conway wrote:
I get nanswers = 16777216, so right off the bat 67MB or so is allocated.
Then there's this:
/* compute the cross product from right to left */
for (;;)
{
oneres = (Oid *) palloc0(FUNC_MAX_ARGS * sizeof(Oid));
I'm guessing this gets executed nans
res the query statement so that I can
place it in a insert query? Is there a variable in
the server that holds the query statement as a string?
I think this shows how to do what you want:
http://archives.postgresql.org/pgsql-sql/2003-05/msg00301.php
HTH,
Joe
---(end
nt to allow non-superusers to execute C language
functions, or create their own? The latter is a huge, gaping security
hole, which is why the language is marked "untrusted".
Joe
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
gresql.org with links from the home page?
Joe
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
more null values are eliminated, then a completion
condition is raised: warning — null value eliminated in set function."
I've never seen a database that emits the required warning, though.
Joe
---(end of broadcast)---
TIP 5: Have
Sorry forgot to mention we are running postgres 7.2.3.
-Joe
On Tue, 2003-07-15 at 16:15, scott.marlowe wrote:
> On 15 Jul 2003, Joe Maldonado wrote:
>
> > Hello,
> > Vacuum analyze is taking a really long time on a fairly small table and
> > during the time the vacuu
nk it took about 24 hours. Based on that
experience, I'd say your 18 hours on a 133 Mhz machine is not bad.
The exact same data, later loaded onto a dual 1.4GHz pentium III server
took about an hour.
HTH,
Joe
---(end of broadcast)---
TI
.
Total CPU 0.00s/0.00u sec elapsed 0.00 sec.
NOTICE: Analyzing
We dropped the table and recreated it and things have seemed to be
working right for now though I have an accelerated simulation of the
conditions running on another db to see if we can reproduce...
-Joe
On Tue, 2003-07-15 at 16:35
* this, but we currently require that support functions for indexes
* not leak memory.
*/
#define PG_FREE_IF_COPY(ptr,n) \
do { \
if ((Pointer) (ptr) != PG_GETARG_POINTER(n)) \
pfree(ptr); \
} while (0)
Maybe you can use that or do something simi
ents using arrays is much easier.
HTH,
Joe
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
key
constraints on this table.
You probably could do something like:
UPDATE mytable SET somefield = somefield;
Joe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
get a few moments.
Joe
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
I tried that after I posted, but only saw roughly 30% improvement (which
is consistent with my earlier tests IIRC). Not bad, but this still left
plperl initial call at ~40 msec versus plpgsql at ~4 msec.
Hm. And the first call to a p
, I guess. Might as well make one in plpgsql too --- even if it
does nothing today, it might be useful in the future, so the
documentation ought to recommend "call 'plxxx_init' when preloading plxxx"
as a general thing.
OK -- I'll put a patch together.
Thanks,
Joe
--
e PHP embed API instead of the PHP CLI (command line interface)
10.Fix license
Joe
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
301 - 400 of 518 matches
Mail list logo
