Brandon E Hofmann <[EMAIL PROTECTED]> writes:
> In plpgsql, how do you return back a result set that is determined and
> generated at runtime based on a report request?
If I understand what you are asking for, you don't.
> Also why does plpgsql require you to define what is returned?
plpgsql is
-hackers is not the place for these questions. Please ask your questions
in the correct forum, possibly pgsql-general. -hackers is for discussion
of backend development.
cheers
andrew
lmyho wrote:
Which is good. But I've got big trouble to login to this initial db by
using this auto-crea
>> Which is good. But I've got big trouble to login to this initial db by
>> using this auto-created username "postgres" through pgAdmin:((( The first
>>try failed due to "Ident authentication failed", so I follow the suggestion
>>on the pop-up window of pgAdmin3, and changed the ident method in
> You could try to change the ident method to trust (in pg_hba.conf). This
> should allow you to login.
> Then, set the password of the postgres user (alter user postgres with password
> 'blabla1212' ; ). Then you could change the ident method back to md5 .
>
Hi Adrian,
Thank you for help!! I
Hi lmyho,
lmyho [2006-03-28 0:17 -0800]:
> I am totally new to the PostgreSQL, and pgAdmin. I really need
> your help.
>
> I just installed the PostgreSQL8.1 and pgAdmin3 on a Debian system,
> using the apt-get install command. Apparently, the initial
> database and the user "postgres"
On 3/28/06, lmyho <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> Which is good. But I've got big trouble to login to this initial db by
> using this auto-created username "postgres" through pgAdmin:((( The first
> try failed due to "Ident authentication failed", so I follow the suggestion
> on the
Through googling, i found that Normal Disk has external data transfer rate of
around 40MBps,
^^
Does this includes, seek and rotational latency ?
where as Main Memory has Data transfer rate ra
Anjan,
> But, in PostgreSQL all costs are scaled relative to a page fetch. If we
> make both sequential_page_fetch_cost and random_page_cost to "1", then we
> need to increase the various cpu_* paramters by multiplying the default
> values with appropriate Scaling Factor. Now, we need to dete
On Mon, Dec 12, 2005 at 06:39:42PM +0530, Anjan Kumar. A. wrote:
> Through googling, i found that Normal Disk has external data transfer rate
> of around 40MBps,
> where as Main Memory has Data transfer rate ranging from 1.6GBps to 2.8GBps.
I think 40MB/s is a burst speed. You should do some test
Defaulat values of various parameters in PostgreSQL:
#random_page_cost = 4 # units are one sequential page fetch
cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)
#e
Am Sonntag, den 11.12.2005, 17:55 -0500 schrieb Carlos Moreno:
...
> I'm interested in adding additional hash functions -- PG supports, as part
> of the built-in SQL functions, MD5 hashing. So, for instance, I can simply
> type, at a psql console, the following:
>
> select md5('abc');
>
> My "fe
Actually, there is probably comparatively little to gain from making it
a builtin. And SHA1 is already there in the pgcrypto contrib module.
Presumably if we wanted a builtin we would start from that code base.
cheers
andrew
Carlos Moreno wrote:
Hi,
I'm very new to this list -- I've bee
Hi,
I'm very new to this list -- I've been using and advocating PostgreSQL for
no less than 4 or 5 years now, and have participated in some of the other
mailing lists, but never on this one.
My question is (short version): how would one go about adding a new
(built-in) function to PostgreSQL?
Since sequential access is not significantly faster than random access in a
MMDB, random_page_cost will be approximately same as sequential page fetch cost.
As every thing is present in Main Memory, we need to give approximately same
cost to read/write to Main Memory and CPU Related operation
Anjan,
> In our case we are reading pages from Main Memory File System, but not from
> Disk. Will it be sufficient, if we change the default values of above
> paramters in "src/include/optimizer/cost.h and
> src/backend/utils/misc/postgresql.conf.sample" as follows:
>
> random_page_cost
7:25:02 -0500
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Please help
>
> [EMAIL PROTECTED] writes:
> > I've have a MAJOR crash an hour ago and postgresql doesn't sta
[EMAIL PROTECTED] writes:
> I've have a MAJOR crash an hour ago and postgresql doesn't start anymoe
> (version 7.3.4).
> Oct 30 17:16:21 server postgres[4135]: [7] PANIC: Invalid page header in block 6157
> of 29135442
> Oct 30 17:16:21 server postgres[4132]: [1] LOG: startup process (pid 4135)
Date: Mon, 21 Oct 2002 11:35:33 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Please help
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > It seems that conne
rom: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Please help
>
> Olivier PRENANT <[EMAIL PROTECTED]> writes:
> > Without modifying anything, postgresql (since today) has a strange
>
Tom Lane <[EMAIL PROTECTED]>,
> > pgsql-hackers list <[EMAIL PROTECTED]>
> > Subject: Re: [HACKERS] Please help
> > > The point is, it occurs today for the very first time!
> > > Question: does (with 7.2) augmenting max_connection suffice, or do I
On Monday 21 October 2002 15:42, Olivier PRENANT wrote:
> Hi all,
>
> Without modifying anything, postgresql (since today) has a strange
> behavior:
>
> All connections are rejected with No space left on device.
>
> There's plenty of space in shm, disk...
I have no idea whether it's relevant, but
Olivier PRENANT <[EMAIL PROTECTED]> writes:
> pyrenet=# VACUUM ANALYZE ;
> FATAL 2: could not open transaction-commit log directory
>(/usr/local/pgsql/data/pg_clog): Too many open files
Hmm. Do you have any idea what sysconf(_SC_OPEN_MAX) returns on your
platform? You could try reducing the ma
; From: Larry Rosenman <[EMAIL PROTECTED]>
> > > To: [EMAIL PROTECTED]
> > > Cc: Tom Lane <[EMAIL PROTECTED]>,
> > > pgsql-hackers list <[EMAIL PROTECTED]>
> > > Subject: Re: [HACKERS] Please help
> > > > The point is, it oc
On Mon, 21 Oct 2002, Tom Lane wrote:
> Date: Mon, 21 Oct 2002 12:52:10 -0400
> From: Tom Lane <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers list <[EMAIL PROTECTED]>
> Subject: Re: [HACKERS] Please help
>
> Olivier PRENANT <[EMAIL PROT
Olivier PRENANT <[EMAIL PROTECTED]> writes:
> It seems that connection from php pg_connect not supplying a password
> lives the process for a "certain ammount of time" running, then postmaster
> just hangs.
That's hard to believe. In 7.2 or later, the backend should give up and
close the connecti
On Thu, 2002-07-11 at 17:22, Luis Alberto Amigo Navarro wrote:
> I can't improve performance on this query:
This _may_ work.
SELECT
supplier.name,
supplier.address
FROM
supplier,
nation,
WHERE supplier.suppkey IN (
SELECT part.partkey
FROM part
WHERE part.name
On Thu, 2002-07-11 at 17:22, Luis Alberto Amigo Navarro wrote:
> I can't improve performance on this query:
You may also want to rewrite
lineitem.shipdate<(('1994-01-01')::DATE+('1 year')::INTERVAL)::DATE
into
lineitem.shipdate<(('1995-01-01')::DATE
if you can, as probably the optimiser will
On Thu, 2002-07-11 at 17:22, Luis Alberto Amigo Navarro wrote:
> I can't improve performance on this query:
You could try rewriting the IN's into = joins
or even use explicit INNER JOIN syntax to force certain plans
with a select inside another and depending on value of partsupp.partkey
it is re
On Thursday 11 July 2002 12:06, J. R. Nield wrote:
> On Thu, 2002-07-11 at 11:22, Luis Alberto Amigo Navarro wrote:
> > I can't improve performance on this query:
>
> Blame Canada!
Whatever ...
How's that silver medal down there in the states?
;-)
---(end of broadcast
On Thu, 2002-07-11 at 11:22, Luis Alberto Amigo Navarro wrote:
> I can't improve performance on this query:
Blame Canada!
--
J. R. Nield
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.po
30 matches
Mail list logo
