Folks,
Please help update the wiki page around how to beta test. Particularly,
please update it with particular things we'd like to see users test for,
like data corruption related to freezing (with some notes on how to test
for this).
https://wiki.postgresql.org/wiki/HowToBetaTest
Thanks!
--
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
When using a temp table in plpgsql functions that has columns comprised
from many tables populated by joins, how do you specify a temp table return
type when its generated by select into and dropped dynamically? I get an
error when I specify returns setof temp_table. Also when I specify a
perman
-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
Dear All,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" have also been automatically created during th
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
Hannu Krosing wrote:
Ühel kenal päeval, P, 2005-12-11 kell 17:55, kirjutas Carlos Moreno:
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
Hannu Krosing wrote:
Ask your question as a separate post, not as an answer t another
thread :)
Also, if you post to a mailing list, you should have the courtesy to
arrange it so your spam filter does not reject replies.
cheers
andrew
---(end of broadcast)--
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
Ühel kenal päeval, P, 2005-12-11 kell 17:55, kirjutas Carlos Moreno:
> 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 v
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
Josh Berkus writes:
> I don't see why you're increasing the various cpu_* costs.
You missed the point Josh --- these numbers are relative to the cost of
a page fetch, so if page fetch is measured in microseconds instead of
milliseconds, then you *do* want to bump the CPU costs up.
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
I'm working on a project, whose implementation deals with PostgreSQL. A brief
description of the project is given below.
Project Description:
In Main Memory DataBase(MMDB) entire database on the disk is loaded on to
the main memory during initial startup of the sys
Anyone please help... I'm a newbie on creating functions in postgresql.
Here is an oracle package that I'm trying to port to postgresql:
CREATE OR REPLACE PACKAGE BODY NewsPkg.NewsTools
AS
PROCEDURE del_news (i_id IN VARCHAR2)
IS
BEGIN
DELETE FROM tbl_news_type
WH
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)
I've have a MAJOR crash an hour ago and postgresql doesn't start anymoe
(version 7.3.4).
Here's the error log:
Oct 30 17:16:20 server postgres[4135]: [1-2]This probably means that some data
blocks are corrupted
Oct 30 17:16:20 server postgres[4135]: [1-3]and you will have to use the last
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
I can't improve performance on this
query:
SELECT supplier.name, supplier.addressFROM supplier, nationWHERE supplier.suppkey
IN( SELECT partsupp.suppkey FROM partsupp WHERE partsupp.partkey
IN(SELECT part.partkeyFROM partWHERE part.name
like 'forest%' )
>>
>> create unique index child_id_index on child (id);
>Thanks a lot. You saved my day :-)))
Always feels good to be able to help :-)
> > > CREATE TABLE will create implicit trigger(s) for FOREIGN
> KEY check(s)
> > > ERROR: UNIQUE constraint matching given keys for referenced
> > > tab
> I stated this before, but I did not get a helpful answer. I
> might have
> misunderstood tghe documentation on foreign keys:
>
> create table global(id serial);
> create table child(anything text) inherits(global);
need:
create unique index child_id_index on child (id);
> gives me
I stated this before, but I did not get a helpful answer. I might have
misunderstood tghe documentation on foreign keys:
create table global(id serial);
create table child(anything text) inherits(global);
insert into child(anything) values ('test);
Now, a select * from child shows
id anyth
44 matches
Mail list logo
