-Original Message-
From: [EMAIL PROTECTED] on behalf of Michael Fuhr
Sent: Wed 2/9/2005 4:22 AM
To: Premsun Choltanwanich
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] How can I use large object on PostgreSQL Linux
> I wonder if admin is pgadmin-tools.
Yes, it is.
Regards,
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Hans-Jürgen
Schönig) wrote:
> I think it is important not to think in dogmas (in this case this
> means SQL syntax is always better) - there should be a reasonable
> compromise between compatibility and standard.
> My compromise would
Hi!
Tom Lane [2005-02-03 11:12 -0500]:
> Martin Pitt <[EMAIL PROTECTED]> writes:
> >> I am thinking the easiest solution will be to re-add get_progname() to
> >> 8.0.X and bump the major for 8.1.
>
> > Seconded. Then we don't need another library version, and it is still
> > not necessary to drag
[EMAIL PROTECTED] wrote:
In this case, the behavior observed could be changed by altering the
sample size for a table. I submit that an arbitrary fixed sample size is
not a good base for the analyzer, but that the sample size should be based
on the size of the table or some calculation of its devia
On Sun, Feb 06, 2005 at 07:30:37PM -0500, Tom Lane wrote:
>
> ReadBuffer needs to do a lookup to map the page ID to a buffer ID,
> which in principle requires only a shared lock on the page-to-buffer
> mapping (embodied in the buf_table hash table). Assuming success, it
> also needs to mark the b
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
>> "Currently used with Oracle databases thru their Extensible
>> Indexing Cartridge.
>> What we are interested in is finding out whether or not we can use our
>> technology directly with PostgreSQL. That would involve, from a overly
>> simplistic vie
Hi!
Tom Lane [2005-02-04 10:27 -0500]:
> This problem isn't worth spending more development time on than it takes
> to change SO_MAJOR_VERSION (we have lots of higher-priority issues).
I just did that:
--- postgresql-8.0.1-old/src/interfaces/libpq/Makefile 2005-01-26
20:24:19.0 +0100
+
Tom Lane wrote:
Bruce Momjian writes:
Hans-Jürgen Schönig wrote:
My compromise would be: Support both syntaxes if possible.
Great... code away. I would suggest a:
oracle_compat = true/false in the postgresql.conf
Yes I am kidding. The differences between Oracle and PostgreSQL
for mo
Bruce Momjian writes:
> Hans-Jürgen Schönig wrote:
>> My compromise would be: Support both syntaxes if possible.
> I can see your point, but imagine if we had Oracle compatibility for
> lots of cases --- our system would have either non-standard or duplicate
> ways of doing things, and that would
I don't sure. However It maybe possibled cause I use PostgreSQL 8 RC1 with pgAdmin.>>> Michael Fuhr <[EMAIL PROTECTED]> 09-Feb-05 11:22 AM >>>
On Tue, Feb 08, 2005 at 02:55:01PM +0700, Premsun Choltanwanich wrote:> From my first information, I got 3 errors /lo, /dbsize and /admin. That> mean now
On Tue, Feb 08, 2005 at 02:55:01PM +0700, Premsun Choltanwanich wrote:
> From my first information, I got 3 errors /lo, /dbsize and /admin. That
> mean now only /admin that I cannot found anywhere.
>
> I still try to find it. If anybody know more information about /admin
> (in Windows is admin
Hans-Jürgen Schönig wrote:
> Neil Conway wrote:
> > Robert Treat wrote:
> >
> >> Actually i believe people want both syntax's as the former is used by
> >> oracle and the latter by db2 (iirc)
> >
> >
> > I think the past consensus has been to adopt the SQL standard syntax. Is
> > there any rea
On Tue, 2005-02-08 at 14:51 -0800, elein wrote:
> An untrusted language is so because of what it can do and cannot do.
> An untrusted language cannot access the filesystem, for example.
>
There is a bit of confusion in the terminology. Trusted means that the
language has been deemed "safe", i.e.
Tom Lane wrote:
On Tue, Feb 08, 2005 at 11:12:07PM +0100, Thomas Hallgren wrote:
Is it OK to design a trusted language so that it allows access to
the filesystem provided that the session user is a super-user?
AFAICS, what Thomas proposes would be exactly equivalent to root running
David Fetter <[EMAIL PROTECTED]> writes:
> On Tue, Feb 08, 2005 at 11:12:07PM +0100, Thomas Hallgren wrote:
>> Is it OK to design a trusted language so that it allows access to
>> the filesystem provided that the session user is a super-user?
> I believe that that is what UNTRUSTED languages are f
elein wrote:
An untrusted language is so because of what it can do and cannot do.
An untrusted language cannot access the filesystem, for example.
WHO writes and runs untrusted and trusted procedures is a different
thing. It is the security mechanism meant to restrict writting
and running the func
An untrusted language is so because of what it can do and cannot do.
An untrusted language cannot access the filesystem, for example.
WHO writes and runs untrusted and trusted procedures is a different
thing. It is the security mechanism meant to restrict writting
and running the functions writte
> Mark, Stephen, etc:
>
>> > I can see your point, however I wonder if the issue is that the
>> default
>> > stats settings of '10' (3000 rows, 10 histogram buckets) is too low,
>> and
>> > maybe we should consider making a higher value (say '100') the
>> default.
>>
>> Personally, I think that'd b
On Tue, Feb 08, 2005 at 11:12:07PM +0100, Thomas Hallgren wrote:
> Hi,
> A TRUSTED language specifies that ordinary users can use the
> language. It also implies that access to the file system should be
> prevented. In essence, ordinary users can never access the
> filesystem.
>
> Is it OK to des
Mark, Stephen, etc:
> > I can see your point, however I wonder if the issue is that the default
> > stats settings of '10' (3000 rows, 10 histogram buckets) is too low, and
> > maybe we should consider making a higher value (say '100') the default.
>
> Personally, I think that'd be reasonable.
I
Hi,
A TRUSTED language specifies that ordinary users can use the language.
It also implies that access to the file system should be prevented. In
essence, ordinary users can never access the filesystem.
Is it OK to design a trusted language so that it allows access to the
filesystem provided th
On Tue, Feb 08, 2005 at 04:29:34PM -0500, [EMAIL PROTECTED] wrote:
> > [EMAIL PROTECTED] writes:
> >> Is there a way, and if I'm being stupid please tell me, to use something
> >> like a row ID to reference a row in a PostgreSQL database? Allowing the
> >> database to find a specific row without us
>[EMAIL PROTECTED]@[EMAIL PROTECTED] wrote
> > Short summary:
> >
> > * It looks to me like the planner vastly overestimates
> > the # of pages read by index scan in quite a few of my
> > tables even though stats collected by ANALYZE are correct.
> >
> > * The problem happens any time y
> [EMAIL PROTECTED] writes:
>> Is there a way, and if I'm being stupid please tell me, to use something
>> like a row ID to reference a row in a PostgreSQL database? Allowing the
>> database to find a specific row without using an index?
>
> ctid ... which changes on every update ...
Well, how doe
On Tue, 8 Feb 2005, Marc G. Fournier wrote:
On Tue, 8 Feb 2005, Oleg Bartunov wrote:
Marc,
On Tue, 8 Feb 2005, Marc G. Fournier wrote:
I believe that this is what Oleg et al tap into with the tsearch2 stuff,
no? I have someone asking me about it, and want to make sure that I'm
telling him the rig
Summary:
"Currently used with Oracle databases thru their Extensible
Indexing Cartridge.
What we are interested in is finding out whether or not we can use our
technology directly with PostgreSQL. That would involve, from a overly
simplistic view, allowing Postgres to use external indexes."
Does t
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> I believe that this is what Oleg et al tap into with the tsearch2 stuff,
> no? I have someone asking me about it, and want to make sure that I'm
> telling him the right answer ... is this what GiST is?
Better ask what he means by "external" exact
[EMAIL PROTECTED] writes:
> Is there a way, and if I'm being stupid please tell me, to use something
> like a row ID to reference a row in a PostgreSQL database? Allowing the
> database to find a specific row without using an index?
ctid ... which changes on every update ...
On Tue, 8 Feb 2005, Oleg Bartunov wrote:
Marc,
On Tue, 8 Feb 2005, Marc G. Fournier wrote:
I believe that this is what Oleg et al tap into with the tsearch2 stuff,
no? I have someone asking me about it, and want to make sure that I'm
telling him the right answer ... is this what GiST is? And, if
Marc,
On Tue, 8 Feb 2005, Marc G. Fournier wrote:
I believe that this is what Oleg et al tap into with the tsearch2 stuff, no?
I have someone asking me about it, and want to make sure that I'm telling him
the right answer ... is this what GiST is? And, if so, what is a *good* doc
for me to poin
[EMAIL PROTECTED] wrote:
actually [EMAIL PROTECTED], is Mark Woodward. Pleased to meet you.
:)
(I hate using my name on lists like this because of spammers)
Not to be confused with me :-)
---(end of broadcast)---
TIP 6: Have you searched our list arch
A question to the hackers:
Is there a way, and if I'm being stupid please tell me, to use something
like a row ID to reference a row in a PostgreSQL database? Allowing the
database to find a specific row without using an index?
I mean, an index has to return something like a row ID for the databa
I haven't worked with GiST, although I have been curious from time to
time. Just never had the time to sit, read, and try out the GiST system.
On my text search system (FTSS) I use functions that return sets of data.
It make be easier to implement that than a GiST.
Basically, I create a unique ID
Hi Tom,
The problem was worse then that:
there were actually twice the same row in the table, delete those twins
helped.
One of my customer suffered the same problem in 2 of his tables and even
the OID was the same!
how can that be possible?
again, deleting those rows helped
On Tue, 8 Feb 2005,
I believe that this is what Oleg et al tap into with the tsearch2 stuff,
no? I have someone asking me about it, and want to make sure that I'm
telling him the right answer ... is this what GiST is? And, if so, what
is a *good* doc for me to point them at to get up to speed with it? Is
what w
On Tue, Feb 08, 2005 at 10:10:58AM -0800, Joshua D. Drake wrote:
> >>Anyone up for it? This is our chance to get a really top notch PHP
> >>driver for PostgreSQL that supports all the appropriate goodies.
> >
> >What exactly do you want people to do?
>
> My thought process was to beat the heck out
Anyone up for it? This is our chance to get a really top notch PHP
driver for PostgreSQL that supports all the appropriate goodies.
What exactly do you want people to do?
My thought process was to beat the heck out of it. Find things that
don't work, should work, aren't implemented and hopefully m
>
> Short summary:
>
> * It looks to me like the planner vastly overestimates
> the # of pages read by index scan in quite a few of my
> tables even though stats collected by ANALYZE are correct.
>
> * The problem happens any time you have multiple columns
> that have a number of re
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> > B) gather a full matrix of the level of "correlation" between each column
> > and
> >each other column. If this were a single floating point number per pair
> >then it might be feasible. It would still obviously be n^2 in the number
Short summary:
* It looks to me like the planner vastly overestimates
the # of pages read by index scan in quite a few of my
tables even though stats collected by ANALYZE are correct.
* The problem happens any time you have multiple columns
that have a number of repeated values
except isinf() works just fine on my system. It's just when CheckFloat4Val is
called with infinity as the "val" you
you get the overflow message. If I move the isinf into CheckFloat4Val all is
fine.
If you don't want to fix this, it's fine with me. I am just reporting problems
and trying
On Tue, Feb 08, 2005 at 01:55:47PM +0200, Hannu Krosing wrote:
> So I guess that making it commit and open new transaction at a regular
> interval (like each minute) during vacuuming single table would not
> alter its visible behaviour. That would solve my problem of long-running
> vacuums on larg
"Jim Buttafuoco" <[EMAIL PROTECTED]> writes:
> this test is likely to fail. I have now seen this on my real old Alpha
> and now HP PARISC systems.
It works fine on PARISC, and has ever since I've been associated with
this project --- I run these tests multiple times a day on old HP
hardware, and t
On Mon, Feb 07, 2005 at 17:45:23 -0500,
Greg Stark <[EMAIL PROTECTED]> wrote:
>
> However for discrete values like the "top ten most common values" and the
> "total number of distinct values" it's not so clear at all that you can
> extrapolate from a sample at all. And it's certainly not clear t
A couple of us using the US Census TIGER database have noticed something
about the statistics gathering of analyze. If you follow the thread "Query
Optimizer 8.0.1" you'll see the progression of the debate.
To summarize what I think we've seen:
The current implementation of analyze is designed ar
Tom,
The other option is to note that on older ( and I mean real old systems where
the fp unit is sub par) systems that
this test is likely to fail. I have now seen this on my real old Alpha and now
HP PARISC systems. Is there a way to
just modify the regression test to pass by these test on
ohp@pyrenet.fr writes:
> I had a crash last night and since while vacuuming databases (either full
> or lazy) I get this error:
> duplcate key violates unique cnstraint "pg_statistic_relid_att_index"
Reindexing pg_statistic would probably make that go away ...
regards, to
"Jim Buttafuoco" <[EMAIL PROTECTED]> writes:
> All I want to do is add a check in CheckFloat4Val for infinity (and remove
> the
> individual checks before the CheckFloat4Val call in other routines).
That's not at all what you proposed before, and it would have vastly
more side-effects than jus
> [EMAIL PROTECTED] writes:
>
>> The basic problem with a fixed sample is that is assumes a normal
>> distribution.
>
> That's sort of true, but not in the way you think it is.
>
[snip]
Greg, I think you have an excellent ability to articulate stats, but I
think that the view that this is like ele
Tom,
I'm back with this issue. I have comparied the src/backend/utils/adt/float.c
from 7.4.6 against CVS HEAD. There was
some work done on the infinity handling (don't know who, I am NOT a CVS
expert/user). The problem I see is that the
float4in does a check to see if the value is infinity
* Mark Kirkwood ([EMAIL PROTECTED]) wrote:
> I can see your point, however I wonder if the issue is that the default
> stats settings of '10' (3000 rows, 10 histogram buckets) is too low, and
> maybe we should consider making a higher value (say '100') the default.
Personally, I think that'd be re
> [EMAIL PROTECTED] wrote:
>>
>> In this case, the behavior observed could be changed by altering the
>> sample size for a table. I submit that an arbitrary fixed sample size is
>> not a good base for the analyzer, but that the sample size should be
>> based
>> on the size of the table or some calc
On Feb 8, 2005, at 20:43, Christopher Kings-Lynne wrote:
Yeah, this is on my personal "hope to do for 8.1" list. At least the
country/city part, haven't really thought about the other one.
One of the two forms already works...can't quite remember which...
I think this is perhaps what you were tryin
Ühel kenal päeval (esmaspäev, 7. veebruar 2005, 19:01-0300), kirjutas
Alvaro Herrera:
> > Also, why must it be run outside of transaction block if it can be
> > rollbacked ?
>
> A vacuum actually uses several transactions, so it wouldn't work as the
> user would expect if run in a transaction. T
Yeah, this is on my personal "hope to do for 8.1" list. At least the
country/city part, haven't really thought about the other one.
One of the two forms already works...can't quite remember which...
---(end of broadcast)---
TIP 3: if posting/reading t
> Hi,
>
> Just a quick check that the extension to AT TIME ZONE to
> allow specifying intervals as well as country/city is on the
> list for 8.1.
>
> I believe it was a fairly simple thing to do now that we have
> our own time zone library...
Yeah, this is on my personal "hope to do for 8.1"
B) gather a full matrix of the level of "correlation" between each column and
each other column. If this were a single floating point number per pair
then it might be feasible. It would still obviously be n^2 in the number of
columns though, so there would have to be some way to limit on h
Hi,
Just a quick check that the extension to AT TIME ZONE to allow
specifying intervals as well as country/city is on the list for 8.1.
I believe it was a fairly simple thing to do now that we have our own
time zone library...
Chris
---(end of broadcast)
Not that I can see. You still have to get the sequence object from
someplace, and having it be a distinct datatype is zero help for finding
a column-specific sequence.
What about allowing sequence qualifiers in the SERIAL definition?
Chris
---(end of broadcast)-
Thank You Michael Fuhr ,
Now, I already installed the contrib/lo and contrib/dbsize modules from source as your suggestion.
From my first information, I got 3 errors /lo, /dbsize and /admin. That mean now only /admin that I cannot found anywhere.
I still try to find it. If anybody know mo
60 matches
Mail list logo