Idea :
Create a function with the same name as your function, but which takes a
timestamp as an argument, converts it to a string according to your
specifications, then calls your function which needs a string.
Postgresql will decide which function to call according to the types of
Hi,
I see that one of the bug fixes in 7.4.3 is:
"Fix temporary memory leak when using non-hashed aggregates (Tom)"
I am still using 7.4.2, and want to find out if I need to upgrade to 7.4.3.
I did not quite understand the bug, or find a way to re-produce this in the
mailist archives.
--On Dienstag, August 03, 2004 20:51:45 -0600 Scott Marlowe
[EMAIL PROTECTED] wrote:
On Tue, 2004-08-03 at 13:05, CSN wrote:
Just wondering, is updateable views slated for a
future version of Postgresql? In addition to using
rules that is.
It's on the todo list. Of course, the just means
Gunasekaran Balakrishnan wrote:
Hi,
I see that one of the bug fixes in 7.4.3 is:
Fix temporary memory leak when using non-hashed aggregates (Tom)
I am still using 7.4.2, and want to find out if I need to upgrade to 7.4.3.
I did not quite understand the bug, or find a way to
The problem is that postgres has failed to thrive as a web based back end database.
Ever heard of
the LAMP soluton? Linux + Apache + Mysql + Php. Its unfortunate, but real. Its easy
to find
hosting with Mysql db, its not as easy (although getting more common I think) to find
hosting with
Hello,
my web application grows slower and slower over time. After some
profiling I came to the conclusion that my SQL queries are the biggest
time spenders (25 seconds). Obviously I need to optimise my queries and
maybe introduce some new indexes.
The problem is, that my application uses
Hi,
I have some problem of performance on a PG database, and I don't
know how to improve. I Have two questions : one about the storage
of data, one about tuning queries. If possible !
My job is to compare Oracle and Postgres. All our operational databases
have been running under Oracle for about
The result is that for short queries (Q1 and Q2) it runs in a few
seconds on both Oracle and PG. The difference becomes important with
Q3 : 8 seconds with oracle
80 sec with PG
and too much with Q4 : 28s with oracle
17m20s with PG !
Of course when I run 100
Content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: [PERFORM] Tuning queries on large database
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Date: Wed, 4 Aug 2004 09:06:54 -0400
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: [PERFORM] Tuning queries on large
sort_mem = 5
That is way, way too large. Try more like 5000 or lower.
num_poste | numeric(9,0)| not null
For starters numerics are really, really slow compared to integers. Why
aren't you using an integer for this field since youhave '0' decimal
places.
schema
I am trying to get an hourly backup of postgres. I tried using the
script below
but when I try to restore off the dumped file it throws an error that
says it
cannot read the data [-1]. If I just type in pg_dump -Fc --file=***
username= database
it restores fine. So something is going on
I have given the requested info below, but read this first:
1) Check the permissions on the backup file, ensure that the user permissions are
such that the
system user you are trying to restore with has permission to read the file
2) Look at the actual backup file, ensure that there is a backup
On Wed, 2004-08-04 at 03:28, Jay wrote:
hi people,
i am using mysql and i am having the following problem
I know this is not the correct to ask this problem.
Surely a MySQL mailing list could have answered this? I thought they
had good community support.
but i am need of
help
Hi,
I am adding image and large object support in my Cocoa
postgresql browser.
Are there going to be any enhanced bytea support functions
coming along?
It seems sorta silly to have to write customized C code
to import a file into a bytea field.
Maybe something like
CREATE TABLE image (
name
Interesting, IBM is saying that the code is worth 85M dollars!
On Wed, 2004-08-04 at 00:19, Scott Ribe wrote:
I could be reading it incorrectly, but the paragraph was outside any
attributed quote:
You are correct that the specific comment about pg not thriving was outside
any quotes.
On Tue, 2004-08-03 at 05:57, Kay-Uwe Genz wrote:
But pg_user is a view and cant referenced. So I try to use pg_shadow,
but PG say that this is an System table and I cant use it.
so you real question is probably:
how can i modify the structure of system tables ?
you do not say what your
Hi everyone,
I'm trying to write a recursive plpgsql function in PostgreSQL 7.4.2
that given a tree node id (ictid) will return all the nodes below it in
the tree, one row per node. When I try and execute the function I get
the following error message:
CONTEXT: PL/pgSQL function
Mark Cave-Ayland [EMAIL PROTECTED] writes:
I'm trying to write a recursive plpgsql function in PostgreSQL 7.4.2
that given a tree node id (ictid) will return all the nodes below it in
the tree, one row per node. When I try and execute the function I get
the following error message:
You've got
If I'm not mistaken you have an infinit recursion because you are always
pulling the same id (whatever _id starts at) throughout each function call.
Postgres is most likely killing the functions when it's hits some stack
or memory limit.
Mark Cave-Ayland wrote:
Hi everyone,
I'm trying to write
I have a bunch of data in Sybase and some of it is in image fields. We
use bcp on this data transparently all the time without major issues in
character mode. Is there a fundamental technical reason that BLOBs
can't be COPY'd in postgresql or is it just that nobody has ever wanted
to
20 matches
Mail list logo