Hello.
Is there any way to hide database structure (at least functions and triggers)
from a superuser/administrator?
Regards,
Zlatko
Bruce Momjian wrote:
>
> Is this item closed?
No, it isn't. Please add a TODO item about it:
* Prevent long-lived temp tables from causing frozen-Xid advancement
starvation
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prom
Is this item closed?
---
Alvaro Herrera wrote:
> Tom Lane wrote:
> > Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > > Tom Lane wrote:
> > >> Yeah, we had better investigate some way to clean them up. It was never
> > >> obv
On Tuesday 17 July 2007 17:47:01 Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > i think i got it fixed as i saw that i pushed my maintenance_work_mem too
> > high. It was higher than physical ram :-(
>
> Ooops, that will definitely cause problems.
yes it did! I ran it again. And now it takes 10 m
On Tuesday 17 July 2007 17:52:11 you wrote:
> [EMAIL PROTECTED] wrote:
> > I use int8 types in most PK or FK columns in a pg 8.1 database.
> >
> > Would int4 instead of int8 speed up creation of an index?
>
> Almost certainly, but by how much will depend on your hardware and size
> of index.
>
> >
On Jul 17, 2007, at 3:13 AM, Vince wrote:
When this fails, I get a useful error print:
$dbconn = pg_connect($connection_str);
Ouput:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user
"postgres1" in ...
How do
a) if the images are in the filesystem (and also under the web root), no
problem. Just use
b) if the images are in the database...
You use and setup URL rewriting in your
webserver so that a HTTP request on "images/filename.jpg" becomes
"serve_image?fname=filename.jpg" with serve_im
OK. Thanks.
Regards,
Zlatko
- Original Message -
From: "Pavel Stehule" <[EMAIL PROTECTED]>
To: "Zlatko Matić" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 17, 2007 12:14 PM
Subject: Re: [GENERAL] ERROR: a column definition list is required for
functions returning "record"
Hello
y
[EMAIL PROTECTED] wrote:
I use int8 types in most PK or FK columns in a pg 8.1 database.
Would int4 instead of int8 speed up creation of an index?
Almost certainly, but by how much will depend on your hardware and size
of index.
int4 will reduze the size of the table, of course. Would this
[EMAIL PROTECTED] writes:
> i think i got it fixed as i saw that i pushed my maintenance_work_mem too
> high. It was higher than physical ram :-(
Ooops, that will definitely cause problems.
regards, tom lane
---(end of broadcast)--
On Jul 17, 2007, at 8:09 AM, Rick Schumeyer wrote:
I've read the earlier threads on whether to store images in the
database or filesystem. I think I understand the pros and cons of
each method, but I have a question on a specific use case.
Let's say I have a web app, and I want to display
I use int8 types in most PK or FK columns in a pg 8.1 database.
Would int4 instead of int8 speed up creation of an index?
int4 will reduze the size of the table, of course. Would this reduce size of
index, too? By the same amount?
How much speed up will i gain on queries? Postgresql Doc menti
Rick Schumeyer wrote:
I've read the earlier threads on whether to store images in the database
or filesystem. I think I understand the pros and cons of each method,
but I have a question on a specific use case.
Let's say I have a web app, and I want to display the images in a web page.
a) if
Am Montag, 16. Juli 2007 16:19 schrieben Sie:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > After this i create the index and it took 10 hours just for one index
> > (primary key). I have 100.000.000 rows with one PK (int8), two integer
> > data values, and two FK (int8)
>
> What PG version is th
I've read the earlier threads on whether to store images in the database
or filesystem. I think I understand the pros and cons of each method,
but I have a question on a specific use case.
Let's say I have a web app, and I want to display the images in a web page.
a) if the images are in the
"Erik Peterson" <[EMAIL PROTECTED]> writes:
> I'm having this issue where once or twice per day (out of ~100,000 =
> queries)
> the table doesn't reflect a committed update immediately. Usually when =
> this
> problem occurs the update takes 1-3 minutes to be reflected in SELECT
> queries. Occasi
Hi,
We are pleased to announce that Sylph-Searcher 1.0.0 is released.
Sylph-Searcher is a client program for searching mail boxes. Supported
mail box format is MH style, i.e. 1 mail = 1 file.
Sylph-Searcher uses tsearch2 for full text search, thus searching is
very fast. For example, ~300,000 ma
Michael Fuhr wrote:
On Tue, Jul 17, 2007 at 01:51:21PM +0100, ann hedley wrote:
What I want is the average and stddev of the set of lengths returned by
this query. Something like...
select average(select distinct on (id) length(consensus) from cluster
order by id,length(consensus) desc);
Richard Huxton <[EMAIL PROTECTED]> writes:
> I think tag_hash (in /backend/utils/hash/hashfn.c) is responsible for
> internal hash-tables (rather than hash indexes). It takes a pointer to a
> key to hash and a keysize (in bytes), so either the pointer is bad or
> the size is too long and it's re
On Tue, Jul 17, 2007 at 01:51:21PM +0100, ann hedley wrote:
> What I want is the average and stddev of the set of lengths returned by
> this query. Something like...
>
> select average(select distinct on (id) length(consensus) from cluster
> order by id,length(consensus) desc);
I think this is
I have this query which returns the length of the longest consensus for
each id.
lumbribase=# select distinct on (id) length(consensus) from cluster
order by id,length(consensus) desc;
length
647
680
273
384
1285
What I want is the average and stddev of the set of leng
On 7/16/07, Steve Atkins <[EMAIL PROTECTED]> wrote:
On Jul 16, 2007, at 11:36 AM, Michael Nolan wrote:
> I have data (from an external source) which is in text format as a
> hex number (it's actually an IP address, but that's probably not
> relevant.)
It likely is relevant, as it means it's a
I have spent the last month battling and looking deeper into the issue,
here's a summary of were I'm at:
- Increasing shared buffers improved performance but did not resolve the
backend FATAL disconnect error.
- Dumping and recreating entire database also did not resolve the issue.
- re-initializ
Running 8.2.4 on Debian stable (Etch).
I'm having this issue where once or twice per day (out of ~100,000 queries)
the table doesn't reflect a committed update immediately. Usually when this
problem occurs the update takes 1-3 minutes to be reflected in SELECT
queries. Occasionally, it has taken
Hi,
I want to take a plan generated by the postgres optimizer and insert a
constant in place of another constant in the plan. There is a function
OidOutputFunctionCall() to get the constant. Similarly, is there any
function to set the value of the constant? What does
OidInputFunctionCall() do?
Once upon a time, in the days of 80-column punch cards and no
variable-length character encodings, there were databases that could
handle fixed-width character fields a bit faster than variable-width.
That doesn't apply to Postgres. There is no, none, nada performance
advantage to char(n), and
"Jason Nerothin" <[EMAIL PROTECTED]> writes:
> PG_FUNCTION_INFO_V1(par);
> Datum par(PG_FUNCTION_ARGS) // pete and repeat! takes text struct pointer
> {
> text *t = PG_GETARG_TEXT_P(0);
> text *new_t = (text*) palloc(VARSIZE(t));
> VARATT_SIZEP(new_t) = VARSIZE(t);
> memcpy((void*) VARDATA
Hello
you have to specify column names and column types. Like
postgres=# create or replace function foog() returns setof record as $$
declare r record; begin r := row(10,20); return next r ; return; end;
$$ language plpgsql;
postgres=# select * from foog() t(a int, b int); a | b
+
10
I have a plpgsql function that returns dataset.
First it was defined to return SETOF someview.
Then I changed it to return SETOF RECORD, in order to be able to return dataset
with varying number of columns.
But, I get the following error:"ERROR: a column definition list is required for
functions
Joshua D. Drake skrev:
> Vivek Khera wrote:
>>
>> On Jul 16, 2007, at 9:26 AM, Francisco Reyes wrote:
>>
>>> I guess the next question is 'what does postgresql considers a blob'?
>>> bytea fields? How about a large text with megabytes worth of data?
>>
>> bytea and text fields are NOT blobs. they
On 17.07.2007 09:45, Hannes Dorbath wrote:
This is a PHP, not a PostgreSQL question.
Well, pg_last_error() might not return something in that case. You can
create a custom error handler if the message is important for you.
--
Regards,
Hannes Dorbath
---(end of broad
On 17.07.2007 09:13, Vince wrote:
When this fails, I get a useful error print:
$dbconn = pg_connect($connection_str);
Ouput:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user
"postgres1" in ...
How do I capture
I'm experiencing much trouble making use of the V1 custom c function
definition framework built into postgres, probably by virtue of my lack of
experience with C.
In a nutshell, I've paid close attention to the documentation, have had some
success getting useful code out of the version 0 naming c
When this fails, I get a useful error print:
$dbconn = pg_connect($connection_str);
Ouput:
Warning: pg_connect() [function.pg-connect]: Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user
"postgres1" in ...
How do I capture this error and handle the printing
ARTEAGA Jose wrote:
I have spent the last month battling and looking deeper into the issue,
here's a summary of were I'm at:
- Increasing shared buffers improved performance but did not resolve the
backend FATAL disconnect error.
- Dumping and recreating entire database also did not resolve the
35 matches
Mail list logo
