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 more
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
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
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
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 list. At
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
Ü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. The
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 trying
[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
* 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
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
[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 election
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 just
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, tom
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
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
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 that a
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 they
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 large
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
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
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
of
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
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
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 of it.
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
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
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
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
[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
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
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,
[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 ...
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 exactly. I
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
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
[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 does an
[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 you have
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 using an
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
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 don't
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 design a
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
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
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 for.
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
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. it
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 reason to also
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
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 only
Bruce Momjian pgman@candle.pha.pa.us 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
Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us 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
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
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 view, allowing
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
[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
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 this
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 be:
-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,
59 matches
Mail list logo