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!
--
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
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 not
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 the
-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
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 the
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 pop-up
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 have
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've
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
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)
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
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 determine
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
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 = 4;
Josh Berkus josh@agliodbs.com 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
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
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?
Ü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
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
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
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
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 feature
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
WHERE uniqueid = i_id;
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
[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) was
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 start anymoe
(version 7.3.4).
Oct 30 17:16:21 server postgres[4135]: [7
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 connection and
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 PROTECTED] writes:
pyrenet=# VACUUM ANALYZE ;
FATAL 2
: 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 have
to recompile?
You might need to up
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
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 connection from php pg_connect not supplying a password
lives the process
]
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
behavior:
All connections are rejected with No space left on device.
Could
[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 have
to recompile?
You might need to up the Shared Memory parameters and the Semaphore
Parameters in your OS
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 maybe
I can't improve performance on this
query:
SELECTsupplier.name,supplier.addressFROMsupplier,nationWHEREsupplier.suppkey
IN(SELECTpartsupp.suppkeyFROMpartsuppWHEREpartsupp.partkey
IN(SELECTpart.partkeyFROMpartWHEREpart.name
like 'forest%')AND
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?
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
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
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:
This _may_ work.
SELECT
supplier.name,
supplier.address
FROM
supplier,
nation,
WHERE supplier.suppkey IN (
SELECT part.partkey
FROM part
WHERE part.name
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
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
table "child"
43 matches
Mail list logo